Log in to SSMS as windows user and attach the DB that should resolve Read Only Marked DB issue if you are moving mdf and ldf files from other machines...

To be more specific .. I make huge transactions in database like delete and Insert and Update. Right after this transactions i Shrink the Database and take Transaction log back...

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...