CREATE TABLE <YourTableName> (Your Column list);

ALTER TABLE to show PK/FK/UQ constraints.

CREATE INDEX to show any indexes on the...

pwalter83 (12/22/2010)

---

Thanks a lot for your answer Rashmi, but now I am stuck with 15 nested case statements (and increasing) which exceed the total 10 allowed in SQL....as there is...

This is incomplete, and not quite right, but hopefully it will fire off someone's neurons to get it finished. I remember seeing something here (article or thread) dealing with just...

Really? With an INSERT statement that has a VALUES clause like that?

BTW, it would be really, really nice if the code you supplied could actually...

I take it that you're using SQL 2008 - R1 or R2?

SSMS 2008 actually modifies...

For your permanent and temporary tables (not table variables), you can wrap all of this up with a begin transaction statement, and with the use of try/catch you can decide...

For most DOS commands, a single greater-than sign followed by a filename...

Congrats Paul! And I have to agree with Kendra - whenever you have...

I'm seeing two problems:

SET ''' + @production_date_time +''' = DATEADD(SECOND,3, ''' + @production_date_time +''' )

First, assuming that @production_date_time = '20101221' (today's date), if this succeeded you would end up with:

SET...

ALZDBA (12/20/2010)

---

Apparently, on a side by side client install it breaks SQL2008 SSMS project stuff.

- New project on a new folder generates "creating project failed"

- opening an existing sql2008 project...

And maybe relate this coding style to yee ole punch cards?

Are you asking about how to have repeated groupings, or how to send a multi-valued parameter to sql to get all of the data for the program.

SanDroid (12/20/2010)

---

I know XML is not realy a table, but it can be used...

SQLkiwi (12/20/2010)

---

Both have their strengths and weaknesses, and the more rounded approach is to use each where it is suited. Table variables have many advantages aside from passing TVPs...