Change the word "select" to "delete".

jbm6401 (11/15/2012)

---

In my select @sql statement, I needed to put extra single quotes around the variable name. In this case: '''+@tablename+'''

Now my problem is I cannot select from...

Excellent job posting ddl and sample data!!! I am a bit confused on what you are trying to do here though. I know you posted your desired output (another huge...

When there are multiples which one do you want? It be far more helpful if you could post ddl and sample data with your problem. See the first link in...

Is OrderingAccount a foreign key in another table?

Be very careful about using the default lengths for datatypes. When you...

jmceuin (11/14/2012)

---

Ok. The end result is of this query is to be used in SQL server. I need to group records for "Bin" and present them per line as a...

jrichards54 (11/14/2012)

---

I have a database that I attached to SQL Server 2005 from the book "Microsoft ADO.NET 2.0 Step by Step authored by Rebecca Riordan. This database has two tables...

SQL Mad Rafi (11/12/2012)

---

Dear All,

I have a Prod table with a million on rows having an ntext column to store XML.

I need to process something from that XML, but...

dwilliscp (11/14/2012)

---

Hmm thought it would do a line by line check.. turns out that my thought process was off anyway. Given that we have data here that is not in...

worker bee (11/14/2012)

---

I updated with no results that are different. I still get two rows, 26 is the TAXABLE, TAX-DEF and the other is 27 SOLE, JOINT, OTHER. I had...

I am a bit late to the game on this one and my comment is a little off topic but...you should not use ordinal position in an order by. You...

shahgols (11/14/2012)

---

Hi all,

I have the pleasure of inheriting a select statement that has multiple subqueries and unions in subqueries, and all sorts of logic to the tune of 400 lines....

Hi and welcome to SSC.

The reason you are having such a hard time with this is because you have broken the rule of normalization where we only store a...

worker bee (11/14/2012)

---

Okay, I have a CASE stmt that is in the SELECT clause. I basically want to get rid of the CASE stmt and place the information in the...