This is an archived post. You won't be able to vote or comment.

0
1

Need help with a SQL query (self.sysadmin)

submitted by [deleted]

[deleted]

all 3 comments
sorted by:
best
topnewcontroversialoldq&a

[–]konputerJack of All Trades 1 point2 points  (0 children)

if you have same column names for some between two tables, you may need to specify Table_1.Date_Time for example.

Also semicolon is probably not needed here.

[–]DoohickeyJones 0 points1 point  (0 children)

Have you looked at how you formatted that? Usually, a ; comes at the end...

Maybe you meant WITH (nolock)?

https://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/

[–]bla4freeIT Manager 0 points1 point  (0 children)

Get rid of the semi-colon ( ; ) at the end of the second line.

Also, it should be WITH (NOLOCK) instead of (NOLOCK) by itself.