Viewing 15 posts - 2,896 through 2,910 (of 3,957 total)
Eugene Elutin (8/31/2012)
dwain.c (8/31/2012)
Thanks for the suggestions on the comments. I'll run them through and try to improve it (I have some other ideas for it anyway).
One question though....
August 31, 2012 at 4:54 am
Eugene,
Thanks for the suggestions on the comments. I'll run them through and try to improve it (I have some other ideas for it anyway).
One question though. If your...
August 31, 2012 at 3:50 am
You may also want to look into XACT_STATE(). You can call this function to determine whether COMMIT will run without throwing the particular error you posted.
August 30, 2012 at 11:03 pm
Shadab Shah (8/30/2012)
Basically indexes increases the performance will searching which is nullified while inserting . Now when the time required for inserting is large it means that the total turnaround...
August 30, 2012 at 10:53 pm
RBarryYoung (8/30/2012)
dwain.c (8/30/2012)
...I just hope I got the line terminator character (CHAR(13)?) right (didn't look it up).
The line terminator can be any of CHAR(13), or CHAR(10) or CHAR(13)+CHAR(10).
Ugh! Well...
August 30, 2012 at 9:32 pm
Jeff Moden (8/30/2012)
Please see the following. It's pretty simple to do once you know how...
I was initially expecting to have to use the standard rCTE adjacency list traversal, but...
August 30, 2012 at 9:23 pm
Jeff Moden (8/30/2012)
dwain.c (8/30/2012)
Jeff Moden (8/30/2012)
Like I said... serious problem.
Jeff - I don't get it (no coffee yet this morning).
If it starts at 23:59:00 and ends at 00:01:00 (120 seconds),...
August 30, 2012 at 8:38 pm
I don't want anyone to think I'm getting defensive about my approach - I am not.
But I've taken Eugene's comments about comments 🙂 into account and also eliminated VIEWs, SPs...
August 30, 2012 at 7:59 pm
Jeff Moden (8/30/2012)
Like I said... serious problem.
Jeff - I don't get it (no coffee yet this morning).
If it starts at 23:59:00 and ends at 00:01:00 (120 seconds), what is the...
August 30, 2012 at 6:55 pm
This is probably too simple, but maybe a start for you:
SELECT a.*
FROM #Orders a
INNER JOIN (
SELECT OrdNum, EmpID
FROM #Orders
...
August 30, 2012 at 6:52 pm
sjsubscribe (8/30/2012)
August 30, 2012 at 6:44 pm
Jeff Moden (8/30/2012)
Brandie Tarvin (8/29/2012)
dwain.c (8/29/2012)
Jo Pattyn (8/29/2012)
August 30, 2012 at 6:34 pm
ChrisM@Work (8/30/2012)
SELECTm.[Definition],
d.TABLE_NAME
FROM sys.sql_modules m
OUTER APPLY (
SELECT TABLE_NAME
FROM YourDatabase.INFORMATION_SCHEMA.TABLES t
WHERE m.definition LIKE '%'+t.TABLE_NAME+'%'
GROUP BY TABLE_NAME
) d
Edit: changed db name
A man of few words! I love...
August 30, 2012 at 8:01 am
Eugene Elutin (8/30/2012)
...
not to mention finding tables inside comments...you need to strip comments out too.
Dwain solution will also suffer from having comments and also heavily depends on statement formatting
Try:
create table...
August 30, 2012 at 7:21 am
RBarryYoung (8/30/2012)
Anyhoo...
dwain.c (8/29/2012)
RBarryYoung (8/29/2012)
August 30, 2012 at 7:18 am
Viewing 15 posts - 2,896 through 2,910 (of 3,957 total)