Heh... not according to BOL which states (no sign of PATH anywhere)...

Basic Syntax of the FOR XML Clause

The basic syntax for specifying the XML mode in the FOR clause...

Surya,

Notice the following lines...

BULK INSERT dbname.dbowner.tablename  

FROM '\\machinename\path\Sample.csv'

Did you make the appropriate substitutions for the lower case items?

You bet... let us know if you need anything else...

I think the "hard part" isn't coming up with the fine code you guys already did, Brandi... the bugger is coming up with all future dates and times for a...

You're welcome... thank you for the feedback...

--Jeff Moden

I'm thinking you didn't read the original post and there's nothing wrong with shrinking Master when this type of mistake has been made.

If you really want a challenge in the best game of all... help some people out on posts in this forum.   Or, write...

Even more amazing is what folks think a DBA is supposed to do

On a slightly different subject, it saddens me to see yet another MCP/MCTS that doesn't know this type of stuff nor how to find the answers in Books Online.  What...

Surya,

You need to look at the file with a hex editor (maybe like TextPad in the Binary mode) and you need to know a bit about the ASCII character set.

0A...

No one mentioned the other important things...

1. UDF's are normally slower than direct code and the exceptions are fairly rare.  For example, a function to return a date sans time will...

Because it's 3/4 of a gig of disk space that will never ever be used again if things are done right.

Juanita,

You are correct in being nervous... As you know, if...

I don't know if Analysis Service will do it or not... but you can use a recursive CTE in 2005 to produce the result set you need.  I don't have...

Heh... I see what you're getting at and I agree...

I'd like to know why this particular method of "partioning" was selected...

...and with 11 tables, I'm thinking that an increment of only 8 is...