This is a very rough first attempt. Ran out of time to clean it up today (and as a result it's pretty messy with bad aliases and data types...

JustMarie (6/17/2011)

---

Phil Parkin (6/17/2011)

---

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and...

Sorry, It doesn't need to uniquely identify rows in the table, just the items on the order.

I'm assuming the real table is more complex, perhaps with an ItemNumber,...

Here's one way. This is assuming that ItemName can uniquely identify the items.

DECLARE @NewSNnvarchar(50),

@OldSalesOrderIDint,

@NewSalesOrderIDint

SELECT@OldSalesOrderID = 1,-- Order to be Copied

@NewSN = 'AFFI'-- SN for the new Order (May not...

I tend to use tabs to line things up in cases where I've got a lot of field names that are all aliased. If the vast majority of fields...

Awesome! Congrats Lynn!

WayneS (6/3/2011)

---

Well, while being an MVP is a pretty big deal, it does not mean you have a higher knowledge. It's really more of an evangelistic award for promoting the...

Oh, and you forgot MCP! :hehe:

Heh. I'm surprised at 2 things.

1. They all fit on one line (On my screen anyways).

2. I actually know what they all are!

Very nice list though.

Is it...

I saw the big bowl of alphabet soup get added onto Gus' signature and figured this would be the place to figure out what led up to it. Only...

peter.row (5/19/2011)

---

You are right of course, I apologise for my harshness. :blush:

I guess in my career dynamic SQL has been a last resort kind of thing in an attempt to...

Could be. That's why I said "depending on...

No, to replace his empty strings with NULLS. Most of the time you wouldn't really want to insert empty strings into fields. As you said though, it depends.

You can also use dynamic SQL to create the index. It is not parsed during sp compilation and would not throw the errors.

Yeah, you'd probably want to throw a NULLIF('<data>' ,'') in the replace as well.