Here is an example of a way you can retrieve 10-15 without a cursor using the top and order by clauses.

Create table top_test (id int identity, description char(1))

insert into top_test...

Basically the views are not created in the correct order. We have views that use views so probably this has something to do with it. So if you...

make that typo:

update abc set

@Hellobye = v1 = isnull(v1,@Hellobye),

@Hellobye2 = v2 = isnull(v2,@Hellobye2)

basically I think you want to set @Hellobye2 (instead of @Hellobye)to v2, or @hellobye2.

Gregory Larsen, DBA

If...

It looks to me, that Prakash's solution sets the V1 to the prior V1, and V2 to the prior V2, by saving the prior v1 in variable @Hellobye, and prior...

From BOL ....

....in the sysdtspackages table in the SQL Server msdb database as BLOB (binary large object) data.

...

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my...

Possible something like this will work for you.

create table sales (account int, month int, part int, amt money)

insert into sales values(1,6,1,1)

insert into sales values(1,7,1,1)

insert into sales values(1,8,1,1)

insert into sales values(1,9,2,1)

insert...

I assume this message is coming from "job history" "step details" information. The job history step details, don't always contain the real error. You might be able to use...

I'm not aware of one, but you could build your own, it think. If I needed to do that I would consider changing your "Security" "Audit" level to "All",...

If I understand you correctly you want some code that will schedule a job. Here is some code that will schedule job "ADRN1303 TRIGGER" to run in 15 minutes...

You might consider using a linked server from your dedicated machine to your production machine. This way from your dedicated machine you can launch jobs on your production machine...

If you truly don't want to keep any transaction log information, to keep the transaction log small your might consider changing your "Recover Model" to "Simple" if you are in...

You can schedule whatever you want using a SQL Server Agent job. If you look in EM there is a directory called "Management" under that there is another directory...

Yep. I think you got it....

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

You need to remove the WHERE clause the "Get the employee supervisor record" select statement. This statement is causing you to never return any supervisor records because supervisor records...

You could easily output the column_name and the value with something like this:

use pubs

select 'title_id',title_id,'title',title from titles

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...