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...
-
Many developers don't know about how to remove un-used code and block. Visual Studio giving facility to resolve this. The followin... -
/****** [dbo].[Split] Script ******/ CREATE FUNCTION [dbo].[Split] ( @RowData NVARCHAR(MAX), @Delimeter NVARCHAR(MAX) ) RETURNS @RtnVal...
No comments:
Post a Comment