Viewing 15 posts - 57,511 through 57,525 (of 59,059 total)
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...
September 30, 2006 at 10:13 am
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...
September 30, 2006 at 9:30 am
Jun,
Crud... Dan's right... sorry we got off track...
To reiterate Dan's question, what should the output look like?
September 30, 2006 at 5:50 am
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......
September 29, 2006 at 7:56 am
That's why "trick" was in quotes ![]()
September 29, 2006 at 7:50 am
Unorthodox? If you think about it, the table structure is similar to that which XML offers (thought everyone but me loved XML
) but...
September 29, 2006 at 7:48 am
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...
September 28, 2006 at 11:00 pm
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...
September 28, 2006 at 10:53 pm
Warning: Recursion is good only to 32 levels and then BOOM!!! ![]()
September 28, 2006 at 7:23 pm
Then, simply change the English days of the week to something the non-English speaking server understands. ![]()
September 28, 2006 at 6:53 pm
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...
September 28, 2006 at 12:02 am
If the Boss wants it real bad... he/she can have it that way (real bad)
Good luck.
September 27, 2006 at 1:37 pm
Does anyone out there use schema binding for a function? I'd be real interested in knowing any performance benfit you may have seen...
September 27, 2006 at 1:08 pm
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...
September 27, 2006 at 1:02 pm
BCP to native format... BCP or Bulk Insert from native format... only requires BULK ADMIN role privs... not SA. Nasty fast...
September 27, 2006 at 1:00 pm
Viewing 15 posts - 57,511 through 57,525 (of 59,059 total)