I have to agree with the others that adding a WHERE clause to all INSERT statements is not a good workaround, for the reasons already given (not robust, not possible...

I have some already seen several posts about how useless ISNUMERIC() is, and how SQL Server lacks a function that tests is a value can actually be cast to a...

Thanks! 😉

And no, I did not. But I did submit it...

An interesting question.

I will not debate the quality of the question, but I will debate the quality of the documentation. Not the documentation that is linked to (this is a...

Gopinath Srirangan (11/25/2010)

---

Hi,

How do we filter the result using WHERE and HAVING clause as used in group by

Say like...

select MAX(TaxRate) AS 'Tax Rate',StateProvinceID

from Sales.SalesTaxRate where Name <> 'Canadian GST'

group...

I do that all the time. I develop a...

richardd (11/24/2010)

---

Nice easy question? Unless I'm missing something, the CREATE TABLE, the first INSERT, the BEGIN TRAN and the ALTER TABLE statements are all inside a stored procedure which is...

Good question. Many people (24% at this time) tend to think that DDL is somehow excluded from rollbacks, so it's good to help educate them.

I was unaware of the issue...

bitbucket-25253 (11/23/2010)

---

Want some more ...

CREATE the temptable as ##

Run the insert code ... do NOT close that instance of SSMS.

Perform the SELECT * FROM ## statement .. right it returns...

bitbucket-25253 (11/23/2010)

---

Hugo Kornelis

The server does not matter, the client does. You need at least the SSMS version that ships with SQL Server 2005. It should work against any version...

Nice question, fairly basic. I agree that the # trickery is a bit unnecessary.

Minor bitching about the title and explanation:

1) GO is not a T-SQL statement. It's a batch seperator...

And a deprecated one to boot. New code should use the new system views....

amenjonathan (11/19/2010)

---

I guess I will concede to your view of cursors because I don't have time to take your challenge. I have read many articles on cursor vs set vs...

Sir? I'm not called a sir very often!

Thanks for offering those opportunities, but...

Good question. I tried to find the asnwer on the internet, but failed, then had to use my common sense to choose an answer.

Andy, is there any reference (other than...