Ok So I'm sure some one will send an assasin my way for saying this, but:

Cursors are not always evil, and will certainly help in this instance!

You can then simply...

Ian Scarlett, You da man!

Thanks!

That did the trick just nicely!

ok here is a generic query:

if exists(select * from msdb.dbo.sysobjects where id = object_id(N'[msdb].[dbo].[RTblClassDefs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

print 'true'

Stand on msdb, and run the query, true is printed

Stand on...

Tried this as well. No Luck 🙁

You can do even one better.

using the PK in count is faster than *

ie,

Select count(id) From...

This looks round about right 🙂

Thanks

I'm going to give this a shot.

Look at that code, add some semi colons, and you have yourself some sql flavour c# :-p

I have 2 such issues. the same 2 issues heard over and over again.

Coffee, and Nicotene.

Now the smoking is not that heavy. I smoke about 10 Camel Superlights a day....

Well Indexes I still do in the procedures. Mostly our procs are just glorified selects, and we let sql decide which indexes to use, but on a few reports we...

Great Article.

And, I've not had the pleasure (displeasure according to rumor) of using Crystal Reports or Reporting Services and, thus, have no idea how long they would take to...

This can get very hairy, very quickly...

Perhaps create 2 temp tables. then a cursor for the store, then populate a temp table with a identity column. then insert that table...

You are right. It is much faster this way.

Thanks a lot!!!!!!

This is a little script I keep close by. from time to time it comes in handy, esp if you need to audit the updated information, or do some calculations...

Well, this will go into a sql job. The reason I have it as tsql, is so that the file name can be dynamic.

the idea is to email a csv...

Create indexes on

CaseNUm

at_ID

If it is still slow, add anothert 2 index on TypeID

and StepName

Wow, should have thought of that!!!!!!!

and this simply because the original designer saved the postal code as int and not varchar(5)