So will there be any issues in using with(NOLOCK) for sys schemas ? I had the habit of using every where in SQL Statements ..What would be the pros and...

I need all columns if no Identity on the table as i am merging and Inserting the Columns data when Not Matched with Identity_Insert ON

for that i need to specify...

So the solution would be like like below

SELECT CONVERT(CHAR(10),DATEADD(dd,DATEDIFF(dd,1,DATEADD(DW,-@Years,GETDATE()))/7*7,1),120)

The above script looks good 🙂 and how about not using the DATEFirst for the below code ? Thanks in advance

SELECT CONVERT(VARCHAR, DATEADD(WW,-@x,DATEADD(DD, -((@@DATEFIRST + DATEPART(DW, GETDATE()) -3)...

The Solution is as below

SELECT CONVERT(VARCHAR,DATEADD(yy, -@x, DATEADD(D, -((@@DATEFIRST + DATEPART(DW, DATEADD(yy,-@x ,GETDATE()) ) -3) % 7), GETDATE())) ,23)

To be more clear i am looking to get date of Tuesday for the x parameter year

Example:

Assume x = 1 (One Year)

-->Today is 02/04/2015 Is Wednesday

-->I need...

SO we do not have any Query for CU # ? that i can run on Server instead of looking it manually ?

Thanks in Advance

Thank you so much .. that worked for me

Hi ,

All of the posts here work and the one i gave also works but i am looking for other ways of doing it in a simple manner and with...

here applying condition 99 is not needed as i need to delete all the rows in TableA with the same condition WHERE deleteflag is 1 for all the products

In TableA We don't have Product Column, It only in TableB

I guess this Query will delete all rows in TableA

my query would be as below

DELETE Table A

FROM TableA a

INNER JOIN TableB b ON b.ConsumerID = a.ConsumerID

WHERE a.ConsumerID IN

(

SELECT ConsumerID FROM TableB WHERE DeleteFlag= 1 AND ConsumerID NOT IN...

Hi i do not want to delete consumerID 100 as deleteflag is 0 for one product

and moreover this is not a home work , but i am trying to...

Hi I need to show % of Billable Hours in different colors like if the % of Billable Hours is >90% then Red and Billable Hours < 90% then Green...