Viewing 15 posts - 10,051 through 10,065 (of 15,374 total)
dwilliscp (11/15/2012)
Ok.. but how do you put that select logic into a delete statement?
Change the word "select" to "delete".
November 15, 2012 at 8:36 am
jbm6401 (11/15/2012)
Now my problem is I cannot select from...
November 15, 2012 at 8:06 am
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...
November 15, 2012 at 7:48 am
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...
November 15, 2012 at 7:28 am
Is OrderingAccount a foreign key in another table?
November 14, 2012 at 3:01 pm
jbalbo (11/14/2012)
ThanksSO this works!!!
Client.LName + ', ' + Client.FName + ' -' + cast(client.ID as nvarchar) as ClientName
Be very careful about using the default lengths for datatypes. When you...
November 14, 2012 at 2:58 pm
jmceuin (11/14/2012)
November 14, 2012 at 2:49 pm
jrichards54 (11/14/2012)
November 14, 2012 at 12:56 pm
SQL Mad Rafi (11/12/2012)
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...
November 14, 2012 at 12:43 pm
dwilliscp (11/14/2012)
November 14, 2012 at 12:37 pm
worker bee (11/14/2012)
November 14, 2012 at 12:21 pm
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...
November 14, 2012 at 12:15 pm
shahgols (11/14/2012)
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....
November 14, 2012 at 12:08 pm
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...
November 14, 2012 at 12:05 pm
worker bee (11/14/2012)
November 14, 2012 at 11:35 am
Viewing 15 posts - 10,051 through 10,065 (of 15,374 total)