Viewing 15 posts - 481 through 495 (of 1,229 total)
vahid.arr (10/9/2012)
NO friendI want To Set Identity Off for All Tables not drop table.
You can - but sequentially, not all at the same time.
Why do you want to do...
October 9, 2012 at 3:23 am
djmason_2001 (10/9/2012)
thank you for your response
In your last part of the query i dont get what this is meant to do
I understand you want me to select...
October 9, 2012 at 3:20 am
Microsoft has a ton of relevant support articles:
Of those, this looks promising:
http://support.microsoft.com/kb/948525
Scanning through this lot, here's what I'd suggest:
List the version / SP / CU level etc of the instance....
October 9, 2012 at 2:47 am
chris.ross 34852 (10/9/2012)
October 9, 2012 at 1:55 am
djmason_2001 (10/9/2012)
heyHas anyone else got any ideas on how to solve this issue ?
CTE's are probably easiest for this, the two queries are I think may be too dissimilar...
October 9, 2012 at 1:46 am
What are the indexes on thoee tables, specifically mytree? Try running the results of the rCTE into a #temp table and joining the other tables to it.
October 4, 2012 at 10:37 am
Jeff Moden (10/1/2012)
Actually, I don't recommend handling this at all. It will break properly spelled names.
+1
October 1, 2012 at 1:01 pm
oscarooko (9/11/2012)
Lynn Pettis (9/11/2012)
ChrisM@Work (9/11/2012)
Lynn Pettis (9/11/2012)
ChrisM@Work (9/11/2012)
oscarooko (9/11/2012)
September 11, 2012 at 2:48 pm
jadelola (9/10/2012)
Thanks 🙂How do I calculate the AmountLeftWith field? I wrote it hardcoded now in the example but that is what the acutal result should be.
Thanks
I've no idea. Using your...
September 10, 2012 at 1:03 pm
jadelola (9/10/2012)
I hope I got it right this time 🙂
Here's your DDL and DML adjusted so it doesn't throw an error and doesn't implicitly convert numbers as text into decimal....
September 10, 2012 at 7:03 am
jadelola (9/10/2012)
Hi,It's not 250.00 but 250.000.
Your figures are not in a consistent format, you are interchanging '.' and ',' as the thousands separator. It's making this excercise confusing. Can I...
September 10, 2012 at 6:41 am
Customer 2 has 1300.00, which exceeds 250.00. I can't make any sense of your math.
September 10, 2012 at 6:05 am
Edit: sorry, wrong class.
August 28, 2012 at 10:54 am
Here's a method I've used with some success in the past. I've changed a few data elements in your sample set, so that the dupes no longer have the same...
July 30, 2012 at 2:45 pm
XMLSQLNinja (7/25/2012)
Gosh, that's quite confrontational.
My sincere apologies if I came off as confrontational; that was not my intent. ...
No offence taken Alan, and thanks for encouraging these tests...
July 25, 2012 at 3:38 pm
Viewing 15 posts - 481 through 495 (of 1,229 total)