It would appear that Isa want's to manufacture data (for test or otherwise) with a random number generator for the "Aro_ID" column.

Isa, one question that remains is "Can there be...

OK, Bruce... here you go...

You were worried about the performance of a cross-tab (aggregate functions)... as some have suggested (especially Serqiy), that really shouldn't be a concern.  I know... you've...

Jun,

Crud... Dan's right... sorry we got off track...

To reiterate Dan's question, what should the output look like?

That'll do... I was just worried about the fact that you said it uses "recursive search on Customer table".  To me, recursion is when a proc or function calls itself......

That's why "trick" was in quotes

Unorthodox?  If you think about it, the table structure is similar to that which XML offers (thought everyone but me loved XML ) but...

You can have millions of recursive calls so long as you don't exceed 32 levels of nesting... same as number of nested triggers, nested stored procedures, etc.  Write a function...

It is if you make it table driven for the days of the week based on language...

But I get your point... to be portable, you would have to use one...

Warning:  Recursion is good only to 32 levels and then BOOM!!!

Then, simply change the English days of the week to something the non-English speaking server understands.

Another good reason for learning it is so you can "ban" it... I don't mean "not use it", either... I mean import the data into nice normailzed tables... storing the...

If the Boss wants it real bad... he/she can have it that way (real bad)   Good luck.

Does anyone out there use schema binding for a function?  I'd be real interested in knowing any performance benfit you may have seen...

Almost forgot... you can schedule a job to run every five minutes on the target server to look in the directory for where you place the file... when it sees...

BCP to native format... BCP or Bulk Insert from native format... only requires BULK ADMIN role privs... not SA.  Nasty fast...