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]

😎

TJT (4/26/2014)

---

I am trying to decide on the best relationship scenario for the following:

Department has one or more Employees

Department has one or more Divisions

Divisions have one or more Units

Units have...

This is a simple version of timezone handling and time adjustments:

😎

USE tempdb;

GO

/*

NOTE: GMT is an obsolete standard, use UTC instead!

000 Dateline Standard Time (GMT-12:00) International Date Line West ...

Just add a filter to the update statement

😎

DECLARE @child TABLE

(

ID INT NOT NULL

,PID INT NOT NULL

);

INSERT INTO @child(ID,PID)

SELECT CH.ID,CH.PID FROM

(VALUES

(101,10)

,(102,10)

,(103,5 )

,(104,6...

dastagiri16 (4/26/2014)

---

After my search i found the solution for that...

and modified my procedure as below.lll

alter procedure limitedupdate(@i nvarchar(max),@j int)

WITH EXECUTE AS OWNER

as

begin

set rowcount @j-2 ;

execute sp_executesql @i

set rowcount...

Have you looked into EXECUTE AS

😎

J Livingston's solution is the proper way of doing this but for clarification, here is a corrected version of what you where trying to do using dynamic sql.

😎

declare @cmd nvarchar(255)...

In my opinion, learning the software...

MVIT (4/26/2014)

---

I have the DB server in EST timezone.So all the dates do get stored in EST.

But in the procedure before processing the date, I need to convert the date

to...