Derek Dongray (2/11/2009)

---

carriem (2/11/2009)

---

I'm new to all this and I'm just beginning to learn how to create scripts for reports using SQL and Crystal reports. I found it interesting...

GilaMonster (2/10/2009)

---

Then tell them to do their bloody jobs and find out where the intrusion is coming...

And please, one far far away from me...

Bruce W Cassidy (2/10/2009)

---

[font="Verdana"]I suddenly got this mental image of a similar board for GPs, and the questions that get posted...

"Urgent! Urgent! Urgent! I have someone in my office...

perrydwill (2/10/2009)

---

Hello,

I am trying to write a query that will select a contacts name, contact type, anniversary date and group membership of certain individuals in a database. I also...

Not part of the question, but if needed it is probably better to add the primary key after...

binko (2/10/2009)

---

I understand. Makes you think you've accomplished something! 😀 At least I did when I finally got to the end of the thread. (Took me about 4...

Roy Ernest (2/10/2009)

---

Is this guy with the SQL Injection thread pulling our feet?

How could the Network guys just say that it is an external IP and not give anymore...

James Horsley (2/10/2009)

---

Actually original question (that I was answering) was

I have a table XYZ with 3 INT columns. There are 3000 records already in this table. Now I need a...

Thank you. Now it all makes sense and using @@nestlevel does look like the best option in this case.

Something new learned, good that is.

Although SQL Server Express is free, I'd actually spend the $50.00 USD and purchase SQL Server Developers Edition, either 2005 or 2008, for use at home. It gives you...

jgangemi (2/10/2009)

---

I encountered a similiar problem one rainy july evening while I was mercilessy beating my pet dog Jenkins. I found the best result was to physically threaten my neighbors...

And if you don't need those constraints and indexes for the temporary work, why go through the process of creating them when the SELECT INTO works just fine.

Question stated "Now I need a copy of this table with an identity column for some temporary work." This is the phrase that pointed me to select "Use an...

I find if you don't read too much into these questions that they are usually fairly easy to answer. Unfortunately it seems people add a lot of contraints and...