Okay the first solution assumed you had no records with the correct model try this:

[font="Courier New"]-- create test tables

CREATE TABLE #source

   (

   client INT,

   model INT

   )

CREATE UNIQUE INDEX ux_source...

When you change the port in SQL 2005 you have to start the SQL Server Browser Service or you need to specify the port in your application's connection string.

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')...