Viewing 15 posts - 55,831 through 55,845 (of 59,072 total)
Heh... that'll teach me to read the question correctly
I labled the nodes 180 out ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 10:13 pm
Generous but I'm curious... why would you pay someone $100 to write code and post it on a public/free forum? Hate to look a gift horse in the mouth, but...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 9:39 pm
They also allow user name and password in clear text... a security risk, for sure. ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 9:03 pm
Sorry... got carried away having fun ![]()
For the format similar to what you ultimately requested... feel free to tweek it... includes a column with...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 8:59 pm
Heh... see what happens when you provide just the right amount of data and a table definition to go along with a good description ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:50 pm
Just about perfect... I'll be back in a few...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 5:55 pm
Look at it this way... they're all flaming one thread and leaving the others alone ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 5:39 pm
That's referred to as a "sequence table" and it one of the things that was suggested. But, you must be VERY careful how you do the update to it or...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 5:37 pm
Can you get them to reverse the process? Seems to me that the data table should be there completely befor the trigger table that says it is.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 5:34 pm
You're welcome...
Not sure what it is but being called "dear" instead of "Jeff" kinda bugs me, especially if you're a guy... must be a language barrier thing 
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:42 am
So... post the actual name of the column that identifies individuals along with a bit of sample data for those, the actual names of the other two columns, the datatypes...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:38 am
<Psssst! Bulk Insert...>
BULK INSERT dbname.dbowner.tablename
FROM '\\machinename\path\Sample.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 2,
ROWS_PER_BATCH = 50000
)
No need for format files or anything else...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:33 am
PLEASE, don't double post...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=380596
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:10 am
Lookup "Expanding Hierarchies" in Books Online.
And, if you search this site for "Hierarchy", you'll also find some pretty decent procs/functions for this. If you come across any that use recurrsion,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:08 am
Heh... I think lots of folks, including me, have made that error at least once ![]()
Just a bit of an edge for performance...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 11, 2007 at 7:02 am
Viewing 15 posts - 55,831 through 55,845 (of 59,072 total)