Good feedback Jeff.

Probably not random enough, but I changed the 5 initial rows (abc xxxxx, etc.) to be:

1st row: abc 1,

2nd row: zyx 100,

3rd row: def 10000,

4th row: ghi 1000000,

5th...

Okay, after playing around with this for a bit, I came up with a solution that does just a single scan.

Part 1: build the test environment. This builds a test...

lmu92 (1/11/2010)

---

It's always awesome to see the alternatives being shared on this community! By no means I'm going to disrespect Wanes solution! Not at all!! It's just interesting that there...

WHOOPS! You are exactly right about that! Good catch. I have...

CirquedeSQLeil (1/11/2010)

---

Heh, started testing it after my last post. Still need to look at exec plans. From 2 records...

Well, the concept comes from Jeff. 'nuf said. 😉

Try this.

-- if temp table already exists (failed previous run), drop it

if OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE #test

-- simulate the table with the data in it.

-- NOTE how your...

Thanks Gus.

I saw that, and I'm sure that I fixed it before posting.... 😉

Can I blame in on the way things get quoted 'round here?

... and PATINDEX.

You might want to check out the article by Phil Factor on http://www.simple-talk.com dealing with the "quirky update". It shows an excellent example of splitting up a line...

rnikandrov (1/11/2010)

---

Thank you for your suggestion,

the plan is to:

#1 import file into single array

#2 parse the right line into temp table, so that i can work with it

can you...

This might help you out.

declare @proc sysname

set @proc = '<Your Procedure Name here>'

SELECT schema_name(sp.schema_id) [Schema], object_name(sasm.object_id) [Procedure]

FROM sys.all_sql_modules sasm

INNER JOIN sys.procedures...

Maybe I'm chiming in maybe a bit...

clive-421796 (1/1/2010)

---

How can I automate this so that I dont have to edit the Script Task every day and specify the date of previous days files to include, in this...

Anyone that wants to review an article of fixing Msg 8992 DBCC CHECKDB errors after upgrading from sql 2000, please PM me with how to send it to you. It's...

Guess who to call after hours? 😀