SSMS is neither the appropriate nor the intended interface for such restrictions.

😎

Jeff Moden (4/27/2014)

---

Eirikur Eiriksson (4/8/2014)

---

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the"...

Check out this post

😎

LutzM (4/27/2014)

---

There are several options to avoid the "reload":

The easiest is to transfer the file to a different folder once it is processed.

Another option would be to store the last...

Duplicate post, already answered here.

😎

The DATEDIFF function is your friend here

😎

SELECT

isLocked

,LastLockoutDate

,currentDte

,DATEDIFF(MINUTE,LastLockoutDate,currentDte) AS DIFF_MINUTE

FROM @tAccount

Result

isLocked LastLockoutDate ...

Ooops:ermm: sorry about that

and thanks Luis!

😎

IMHO this is one way of generating a dynamic sql query but I have some doubts. It will certainly not produce reusable plans nor benefit from the usage of sp_executesql....

I believe you will find the answer here

😎

Note that sysusers is depreciated, use sys.database_principals instead.

Kind of a "must read"

Joe Celko's Trees and Hierarchies in SQL...

Complete listing using the MERGE statement

😎

USE tempdb;

GO

CREATE TABLE Table1(

[ID] int,

[Version] int,

...

Sorry, seams like I jumped the gun here:-D

I formatted the code and added few...

TJT (4/26/2014)

---

Yes this is straight forward, but what happens when a person doesn't have a group or a unit, but works just at the divisional level?

I am trying to imagine...

Just a thought, how would you use the SSMS message? If you need the count of records affected you can use the output clause or simply either @@ROWCOUNT or ROWCOUNT_BIG()

😎

DECLARE...

Take a look at this article

A SQL Server DBA myth a day: (26/30) nested transactions are real[/url]

😎