First, I'll give you the blanket warning that storing dates as varchars is just plain bad practice. I'm sure, just like anyone else, you're working with a design that...

That's what I've done to generate the file as well.

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...

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...

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,...

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...

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...

How about some sample data to show that your code does not work?

http://www.sqlservercentral.com/articles/Best+Practices/61537/

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...

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...

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...

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...

Michael Valentine Jones (7/10/2009)

---

Here is a great story about a "Spreadsheetized" design where all the companies data was stored in a single table.

Death by Delete

http://thedailywtf.com/Articles/Death-by-Delete.aspx

"...

One day, a developer was optimizing...

cs_troyk (7/10/2009)

---

Michael Valentine Jones (7/10/2009)

---

John Rowan (7/10/2009)

---

Ha! I'll have to second that one. Not just in...

Yep, that'll do. I second Peso's solution....