Why use substring and LTRIM? Shouldn't STR give you the string representation you need?

Even with the backup and restore the execution plans could be different as the plans are cached in memory not in the database, so you should compare execution plans.

Are the...

Well, if there is a cursor I would always try to remove it if there is a set-based solution which there usually is. As far as the why there...

Great, I love learning something new. I would suggest creating the control and then submit the instructions to SSC as a How To article, then we all benefit. ...

Matt Miller (5/14/2008)

---

Jack Corbett (5/14/2008)

---

SQL Server does not have before triggers. In SQL Server you would use an after trigger and then use the virtual inserted and deleted tables. I...

I use the SQL Prettifier. Someone mentioned it in another forum thread and I have used it since. It is an extra step, but I find it makes...

Here are 3 options. Option 1 is simpler, but it will create rows even if you do Update TicketCallMain set AgrPKey = AgrPKey, while Options 2 is not complex...

SQL Server does not have before triggers. In SQL Server you would use an after trigger and then use the virtual inserted and deleted tables. I will post an example...

You may have missed my first post on the forum as it was prior to yours,...

webrunner (5/14/2008)

---

ezlikesundaymorning (5/14/2008)

---

Excellent. I guess that I can just sit here and bitch or start contributing myself when it all boils down to it. Thanks for the reply. I am...

ezlikesundaymorning (5/14/2008)

---

OK, just plain and simple, I am going to give my 2 cents worth here. This question is pure BS. I mean has anyone here ever seen a query...

I agree with your other 2 points,...

riga1966 (5/14/2008)

---

select * from scan

where boxid = 'RET0018438'

and

(((client in ('MCP','JNJ','PCP','PCR','HOS')) and

(client in (select clientcode from policy where deduct_ship = 'N')...

I got it wrong as well, which, unfortunately, seems to be happening a lot lately. My only comment is that I would prefer that database context be given something...

KC (5/14/2008)

---

We do full backup every night and a log backup the log once a night then shrink the file. i have doubled the size of the log to see...