rschaeferhig (1/21/2009)

---

I got it working with Ragged Right. Since there are no files in the target directory I have to set the columns up individually in Advanced, but it works....

Now, that's exactly what Gus (GSquared) and I...

As a side bar, 16 alpha-numeric combinations (26 letters, 10 digits = 26 different characters) would be many more combinations than most people would ever be able to use in...

Crud... sorry Barry... I've been drinking hot cocoa instead of coffee. I see where you said you'd write to a temp table.

RBarryYoung (1/21/2009)

---

Well @@DBTS can technically do what the OP asked. Of course that is only within the scope of a single database (no mention of scope in the original...

RBarryYoung (1/21/2009)

---

toniupstny (1/21/2009)

---

The ms_foreach.. proc is an unofficial method and can be removed at the will of Bill et al. There are also cursors in the ms_foreach... ...

amartha_dutta (1/21/2009)

---

Dear Friend,

How about looking into manipulating the current system date & Time.

Use GetDate(), Remove the spaces and append with some other characters / digits of your choice (Based upon...

So, Kit... can I see your code like I asked, please?

Matt Miller (1/20/2009)

---

The only way you're going to ENSURE that it's unique is to keep track of all of the ones previously generated. Use whatever methodology you like to...

GROUP BY ..... WITH ROLLUP

Only thing is, it's gonna be a pain to add things that are a mix of datatypes like "Cost $5%'.

Just as a suggestion to get away from kludge code, take a look at BCP with a format file... it'll do just what you want.

Lynn, you have the patience of a saint. Yoda be da man!

agh100 (1/21/2009)

---

Hi GSquared,

I have been sick for some days now, so I haven't been able to try your script until now.. And thanks very much, it works splendidly on SQL...

munishprathap (1/20/2009)

---

Thanks friends for all your support

i can achieve this task by the following Query,please let me know your feedback

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Note'

AND...

Not sure what you mean by that, Michael...