[ pl4stik @ 18.01.2013. 13:26 ] @
Napravio sam upit koji vraca ako neki column sadrzi parametar ili je null ali ne mogu da dodama i vreme.. tj. izmedju datuma Code: SELECT ID, Title, keyword, jobtype, DateCreated, location FROM Test WHERE (@Title IS NULL) OR (Title LIKE '%' + @Title + '%') AND (@keyword IS NULL) OR (keyword LIKE '%' + @keyword + '%') AND (@jobtype IS NULL) OR (jobtype LIKE '%' + @jobtype + '%') AND (@location IS NULL) OR (location LIKE '%' + @location + '%') AND (DateCreated BETWEEN '1/10/2013' AND '1/12/2013') Jel vidi neko sta je problem? |