Sorry I did not get your question right, like do you want to write a script for displaying user with some info based on the data in excel sheet or...

Yes, as Peter rightly mentioned, the relationships between the tables and the data storage in the tables would help analyze the issue.

I don't think CONVERT or CAST functions can accomplish the desired output result, basically I believe this functions are useful for converting the output datatype, however I am wondering if...

I believe Database Name  shows up only when you run Security Events, otherwise only Database ID is shown. I don't think there are any setting governing this behavior.

Thanks

Please refer to DECLARE CURSOR and CURSOR LOCKING in BOL for a detailed explanation and understanding on locking and concurrency issues.

Thanks

-Prasad

Well I believe they are mistaken, however each one has his own experience and based on their experience they arrive at conclusions, so I cannot definitely comment on their view...

Hi,

Did you try the cursor that I posted?

Thanks

Hi Noel,

Yeah this works fine with the assumption that the constraint is on the combination of the two columns PN and Cage, since the exists query is checking with a...

I havenot tried out this but how about something like this

create procedure AddLogin @LoginID varchar(20)

as

declare @sql varchar(100)

exec sp_grantdbaccess @loginID

set @sql='GRANT all

ON Engagement

TO ' + @loginID

exec (@sql)

set @sql ='GRANT...

Well usage of Dynamic SQL has its pro's and Con's and I learnt from the article posted by Frank, however if you still want to go with it then it...

Well write a small procedure and call it. I hope this serves your purpose.

CREATE procedure MyProc

as

declare @rowno INT,

 @amount NUMERIC(18,2),

 @totalrowno INT

DECLARE MYCUR CURSOR FOR

SELECT  rowno,

 totalrowno

FROM

 mytable

OPEN MYCUR

FETCH NEXT FROM mycur INTO @rowno,@totalrowno

WHILE...

Hmmm... Let me get a better idea,

First Point : So here tblPN and p are two different tables both having PN and Cage as columns and you are trying...

Well check if

(Select IDField from inserted)

and

(Select IDField2 from inserted)

are returning single records or not.

Thanks

Hi,

I just see in E-R Diagram! Am I missing any thing here like attachments etc...

Thanks

But why do you want to create the temp table in two steps, is there any specific reason, you can as well create it with the

CREATE table #mytable (column1...