SELECT
C.CategoryID
,
CategoryName ,
CASE WHEN ABS(DATEDIFF(W,GETDATE(),R.CreatedDate)) <= 5 THEN 'New' ELSE '' END AS 'NewReq' ,
CategoryFolderName
FROM Master.Catagory C
Subscribe to:
Post Comments (Atom)
-
<html> <body> <table> <tr><td>Text to Save:</td></tr> <tr> <td colspan="3...
-
MaxDepth – A positive integer that specifies the maximum nested node depth per read. The default value is 32. Maximum is 2147483647. Ma...
-
Many developers don't know about how to remove un-used code and block. Visual Studio giving facility to resolve this. The followin...
No comments:
Post a Comment