Craig Farrell (10/8/2010)

---

--Quirky Update here. It SHOULD be ran with OPTION( MAXDOP 1). Only needs it for this query (...)

UPDATE p

SET

@Series = Series = CASE WHEN p.StartNum...

Stefan Krzywicki (10/13/2010)

---

Oh, it bugs the hell out of me. I wouldn't presume to try to answer the question once I deciphered it because I wouldn't believe they could understand...

Joe, you're not helping.

craig-404139 (10/13/2010)

---

Depending on the database the column name could be different, hence why I need to be able to pass a parameter into the code depending on the database (which...

craig-404139 (10/13/2010)

---

Sorry didn't know you wanted to see the code. The problem I have is depending on the database the column 'controlnumber' can be called 'begno' or a different name....

With the exchange rate the way it is, I could buy...

craig-404139 (10/13/2010)

---

I have some code that finds sequences of numbers contained in 2 columns in a database. But these 2 columns can be named differently depending on the database it...

Don't make me come over there, Chris 😛

sachinsoni84 (10/13/2010)

---

i have taken a backup of database, backup size around 112 gb, when i archived it as a .RAR file it reduced upto 5.5 GB only, how did it...

craig-404139 (10/12/2010)

---

I have a large chunk of code that can be run on different columns. Is there any way to do something like this:

select @col1,@col2

from blahblah

Using a stored procedure with...

sivaj2k (10/13/2010)

---

Yes, definetly. You have to use dynamic query. First frame a query using the variables supplied to the procedure. Store query to a variable and then execute that using...

The Dixie Flatline (10/13/2010)

---

Paul, I think you missed something in the midgame posts. His question is really why it didn't throw a syntax error when he used...

You can't...

The documentation could be better,...

Tom.Thomson (10/12/2010)

---

It's SARGable if the optimizer can use an index seek to speed up the check. So this one is twice SARGable, since the optimiser uses two index seeks...