SqlPrompt from redgate, u know it! 🙂 search for it!

Thats a good one, thanks lowell 🙂

siddartha pal (11/2/2009)

---

Suppose you have an db account with name 'ta' and pwd as 'ty'. When a user connects to DB through Asp.net, he useses the same account details in...

Usually you will have a seperate database account which will be used to connect to the database from your .net application (which users will not be aware of).

If you...

pramod_yg (11/1/2009)

---

But, one thing i wanted to understand is why is it putting the lock on the destination table when it is just selecting. I thought that the lock should...

Format your select and put where clause as you want. All the information that you want is returned. Build a sproc around this. (using insert and select)

Select *

from msdb.dbo.sysjobs...

Its not tuned for performance, but this is what I got as a first thought. Please test extensively if it works okay for you. Let us also wait to...

you need unpivot for this, take a look at the example in this link please.

http://msdn.microsoft.com/en-us/library/ms177410.aspx

Just in case if you need the query,

create table #t

( A int , B int...

select champ1, champ2

from table t1

where exists (select 1

...

I guess w3wp is a worker process for asp.net in .net framework 2.0 ( sorry if I missed somewhere, but when do you get that error? when you launch SSMS?)...

Mark's approach is good!

I guess this should also do.

CREATE TABLE #SORDER (CID int, PID varchar(20))

INSERT INTO #SORDER VALUES (0000001 ,'AAA123')

INSERT INTO #SORDER VALUES (0000002 ,'AAA121')

INSERT INTO #SORDER VALUES (0000003 ,'AAA111')

INSERT...

Have a look at exists and not exists in BOL, that should do for you!

Sorry if I have not completely undestood your requirement but to modify the stored procedure you need to click on 'execute', not save! That way it will 'ALTER' the stored...

ok Vinod, this time around I shall help you with test data. But as suggested by Gianluca, please make sure to post queries with data like this. You would get...

Why do you need CHAR(39) there, remove them and anyway there is an extra closing parenthesis at the end