Advanced Search

AV Inventory tab

/ Published in: SQL
Save to your folder(s)
Segregowanie po ostatnio dodanym (czas, TLM)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT DISTINCT  [TLM_Body], [File], [Cat], [Filetype], [Description],  [EOMBegin], [Composer]
  2. FROM [Files]
  3. WHERE [Cat]='CMU' AND ([TLM_Body]  < GETDATE()-0) AND
  4. 	[FileType] IN(1, 4) AND
  5. 	(([File] NOT LIKE '?*$#') AND ([File] NOT LIKE '?*$##')) ORDER BY [TLM_Body] DESC;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.