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)
-
SQL Server has several fixed database roles such as db_datareader and db_datawriter , which grants the user read and write access res...
-
<html> <body> <table> <tr><td>Text to Save:</td></tr> <tr> <td colspan="3"...
-
Get Yahoo Contact for C# Create new Website Create AppCode Folder Create OAuthBase.cs in AppCode Folder like us...
No comments:
Post a Comment