Are you trying to add two columns to one table and one table to another table?

If so you wnat code like

ALTER Table1 add ColA type1 columnConstraints1, ColB type2 columnConstraints2;

ALTER...

Jeff Moden (10/12/2012)

---

Mahesh Bote (10/12/2012)

---

[font="Verdana"]Hi All,

I have one Stored Procedure which frequently gets executed. Though it is a straight forward Stored Procedure with one select statement and one delete statement,...

Luis Cazares (10/16/2012)

---

This might work, but an index might help even more (if you don't have one). I won't give my advice on the index because I'm learning as well...

Cadavre (10/16/2012)

---

Lowell (10/16/2012)

---

ok, adding WITH SCHEMABINDING to my scalar function cuts half a second off of my performance, so it goes to 7.5 seconds or so instead of over 8...

Marios Philippopoulos (10/16/2012)

---

Perry Whittle (10/16/2012)

---

Whats voodoo about creating a table, inserting...

Rich Weissler (10/16/2012)

---

okbangas (10/16/2012)

---

If it were different in two supported editions of SQL Server, I agree. However, SQL Server 2005 is not supported anymore, so this question is correct for...

mister.magoo (10/15/2012)

---

Yes it does...

Type conversion in expression (TRY_CAST([test].[field1] AS smallint)) may affect ...

That's still not going to work - a string like...

CELKO (10/14/2012)

---

Then try this query. The CTE can be changed quickly to other report periods. I like this because MIN() and MAX() can be optimized into the GROUP BY

WITH Year_Pairs...

deleted

Fun question.

I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not...

ChrisM@home (10/14/2012)

---

Fair point, Tom, but if you examine all of those "output example" figures and count the number of digits between the comma and the decimal point, this is what...

The whole computer industry has been badly damaged by patents granted on pure mathematics in the USA, which have severely damaged the development of secure encryption. The Onion story...

It strikes me that maybe everyone who has answered so far has been trying to return the records not wanted, rather than the records wanted. So perhaps something like

select...

This only works if there are no leading spaces. Leading zeroes are OK, and string comparison ignores trailing...