Thanks

But Raid5 takes a lot longer to rebuild after failure, no?

Thanks for the feedback!

Is running the o/s on SSD worth the money?

SQLKnowItAll (2/15/2012)

---

Evil Kraig F (2/15/2012)

---

SQLKnowItAll (2/15/2012)

---

I would actually structure the application to call separate stored procedures based on the parameters provided. This way you don't have this messy code;...

Thanks for the advice 🙂

Thanks for your feedback!

I thought that dynamic SQL was faster than 'normal' SQL, which was the reason for using it.

It seems to have made my queries faster!

Thanks for your advice!

I'm still learning all this dynamic SQL stuff 🙂

Seems to be working so far 🙂

Many Thanks!

Cute corgi ...... great dogs!

Fixed it 🙂

(select top 1 i.name from industries i where i.id = ' + CONVERT(varchar(15), @Industryid) + ' ) as Industryianname,

Thanks

This is the error:

Msg 245, Level 16, State 1, Line 2

Conversion failed when converting the varchar value '@Industryid' to data type int.

It works fine on @Industryid = 0, but not...

You guys are correct!

I removed a superfluous Join statement, ran an "Actual Execution Plan', it suggested adding a new index and voila...... one second query 🙂

Thanks

Jeff's parse code works great as a 'stand alone' query, but when it is part of another Stored Procedure, running dynamic SQL, it takes forever!

Is it not meant to work...

Thanks, that worked great!

Thanks!

Thanks for the feedback!