Stupid question here.

What kind of hardware can write 200 GIG of data to the disk in the log (not to mention to the db) in only 2 minutes?? I...

Now how can we help a guy who can't even tell what he wants .

Is it possible that my Pubs is broken... That...

Hey I got a server to keep alive too you know .

Congrats Sushila, and Fhanlon for correctly guesssing this solution.

Hey Jay can you post the actual requirements next time, we won't have to shoot out every possible answer to every possible...

btw this works for me, so I assume that the first line is erroring

Declare @a as datetime

Select @a = cast(getdate() as varchar(10))

Select @a

try

Select * from dbo.tblShipping_rpt_date where isdate(shippg_rpt_dt) =...

I assume that either of these line is causing you the problem.

Can you run the code from QA and see which lines causes the error?

select @sys_date = CAST(tblShipping_rpt_date.shippg_rpt_dt AS...

Here's my guess, for the fun of it. Might be totally off but someone will learn something from this .

select top 90%...

The actual name that makes sens. Here's an article on this matter :

Worst Practices - Part 1 of a Very Long Series!

You mean this ???

You typed :0p.

Anyways now you know that you can't do it... and it might help someone else along the way.

Do you see me guessing?? I'm sick of it, now I just wait for the right informatin before trying to help the guy.

Can you post some sample data with the expected results... I'm not sure I understand what you want.

Just personal opinion.. I find it easy to miss if you put the =1 at the end. I like this syntaxe better (maybe a few c++ guys will agree on...

The big optimization idea was to do something like this :

Select * from dbo.TableName where col1 like '%Servername%' or col2 like '%Servername%' or col3 like '%Servername%'.

Makes only 1 clustered...

Of anyone's stupidity actually...

Not to mention the time it takes to track down the bugs...

Really not a good idea to use this syntaxe in production.

It's cool when you develop to do it once...