I don't think so. I'm pretty sure the FOR XML..., ROOT command is brand new with SQL 2005.

Sorry.

I'm not sure I understand the problem. Are you saying you want to load nulls but can't or that the data doesn't appear to be loading at all?

ucbus 92278 (10/20/2009)I have tried to use "FOR XML" tag by creating a view of the data, However this resulted in multiple rows in a FLAT structure. To get the...

Have you tried googling for XML escape characters?

How are you importing the XML into SQL Server? Via SSIS or another method?

Sunil,

In the future, please start a new topic with your question rather than piggy-backing off another thread.

SSIS is the best way to load an XML file into SQL server in...

If there's a way to do that, yes.

But if another of the SQL Tools does Gantt Charts (besides Project), I'd like to do that too.

Ahh. I think everyone misunderstands my problem. I have my code. I also have job duration from a JobsMonitoring job we have. Now, I just need to translate my code...

Thanks, Everyone. Sorry I couldn't reply sooner. I was out on vacation.

What I'm working on is a Weekly chart that shows what day of the week & time that the...

Lowell had it right. Apparently, way back when I was switching contract jobs on almost a daily basis, I must have registered and totally forgotten about it.

Steve is frying...

Interestingly enough, not a single other "Brandie" member account has a single post to their names. Most don't even have visits recorded. 3 have points to their names.

The other...

Thanks, Silverfox. Though my bet is that someone has a bot that's going around spoofing people. I know of no other person with my first name that spells it the...

FYI: It's common courtesy to start a new thread when you have question that is different from the intent of the original thread. Please don't piggy back.

You do understand the...

I guess we'll just have to agree to disagree on this particular topic, then.

Gail,

You're hired! Come on over to Florida and we'll discuss your exhorbitant salary that is totally off the scale compared to the DBAs we currently have now who foolishly assumed...

BTW, I should mention that I work in the insurance industry and have worked in the records management industry. I have actually seen things like this happen in both. A...