Viewing 15 posts - 1,321 through 1,335 (of 3,232 total)
Yes, but it is not really related to WMI or this thread. Can you start a new thread with your question and use a specific example of what you...
July 15, 2009 at 9:38 am
This will work as long as you always want to keep everything to the right of the first occurance of a space in the data:
DECLARE @TABLE TABLE(RowValue varchar(20))
INSERT INTO @Table
SELECT...
July 14, 2009 at 3:46 pm
DECLARE @Table TABLE (id3 int, email1 varchar(256))
INSERT INTO @Table
SELECT 454382, 'abc@hotmail.com' UNION ALL
SELECT 612832, 'john@global.net' UNION ALL
SELECT 612833, 'john@global.net' UNION ALL
SELECT 612834, 'john@global.net'
SELECT * FROM @Table
SELECT MAX(id3) as id3,...
July 14, 2009 at 1:43 pm
You can't get the SQL Agent to send you an e-mail that says tagcount=xx and tagcount=xx. You can, however, get SQL Agent to e-mail the script results as an...
July 14, 2009 at 1:40 pm
OK, what is TAGCOUNT's? What have you tried? What problems/errors are you getting?
Have you even attempted SQL_Locks suggestions? If so, what part are you stuck on, what...
July 14, 2009 at 1:21 pm
How about some sample data to show that your code does not work?
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 14, 2009 at 1:17 pm
You've asked the same question 3 different times, 3 different ways and you've stated that it is urgent, but you have not told us what your problem is. Are...
July 14, 2009 at 10:33 am
Using SQL_Lock's advice, you'd need to configure your output to create a new output file for the step and create a second step to e-mail that file out as an...
July 14, 2009 at 10:24 am
Man, there's bunch of info out there on the web on this error. Did you attempt to research this yourself or just post it for others to do the...
July 14, 2009 at 10:07 am
You can't really pass row counts back to the SQL Agent from a script. You may want to consider logging your row counts (and any other data) into a...
July 14, 2009 at 9:55 am
Michael Valentine Jones (7/10/2009)
Death by Delete
http://thedailywtf.com/Articles/Death-by-Delete.aspx
"...
One day, a developer was optimizing...
July 10, 2009 at 4:26 pm
cs_troyk (7/10/2009)
Michael Valentine Jones (7/10/2009)
John Rowan (7/10/2009)
cs_troyk (7/10/2009)
"Denormalize for performance" and its sibling "You only need to normalize to 3NF".😉
Ha! I'll have to second that one. Not just in...
July 10, 2009 at 3:14 pm
Peso (7/10/2009)
DECLARE@num NUMERIC(15, 0),
@dt DATETIME
SELECT@num = 20090616052600,
@dt = '20090316 22:27:20'
SELECTDATEDIFF(HOUR, '20090316 22:27:20', '20090616 05:26:00'),
@num,
@dt,
DATEDIFF(HOUR, @dt, STUFF(LEFT(@num, 10), 9, 0 ,' ') + ':0')
Yep, that'll do. I second Peso's solution....
July 10, 2009 at 3:10 pm
cs_troyk (7/10/2009)
"Denormalize for performance" and its sibling "You only need to normalize to 3NF".😉
Ha! I'll have to second that one. Not just in forums, but this one runs rampant...
July 10, 2009 at 2:52 pm
Viewing 15 posts - 1,321 through 1,335 (of 3,232 total)