Sagesh,

There is no MIDDLE JOIN. As MIDDLE is not a keyword or predicate and there is no alias already specified for tblCustomers, MIDDLE is taken as the alias.

Your queries do...

If I remember correctly the IMEX setting should be 1(one).

I've set up and ran a test on my dev machine here. When I've changed drive letters in the stored procedure, the correct value has been output to the global...

Is the K drive actually a mapped drive to a disk on another server? If so this won't show up on xp_fixeddrives.

How did you do this for the K drive? Did you recreate the procedure with a 'K' in the WHERE clause instead of a 'D'? Or something different?

You might also...

Bruce,

Congratulations on your retirement; something tells me this Christmas will be more relaxed than any you've ever had before!

Although it does sound as if you're going to busier, with...

Sometimes DTS can be a right pain in the a$$. :hehe:

What you can do to work around this is create the DiskSpace_size procedure with all of the lines involving the...

Loner,

I would be quite happy to look over your resume for you. I have completed a number of resumes for my friends (and friends of....) and family and have had...

NoYoBidnez, my apologies for the "book" suggestion in that the written word has always been my primary source of information; I was brought up with the "if you don't know...

That guy's going to be SO upset!

nunYoBidnez, offering advice that has been asked for is not "fixing"; if it were then consultants would put engineers out of a job?!? 😀

Advice is neither leading nor managing, it's...

Rudy, harsh words I think; you're opinion is important but may be misconstrued as not constructive. Communities are supposed to be built not destroyed; I think Loner's post are somewhat...

Apologies, I should preview before posting... The REPLACE statement didn't appear correctly and should have been:

SELECT REPLACE(@xml, '<root>', '<root timestamp="' + CONVERT(VARCHAR(11), GETDATE(), 113) + '">')

Hi,

It's a bit crude and not very pretty but it does the job!

DECLARE @xml VARCHAR(4000)

SELECT @xml = (SELECT name as '@name', xtype as 'data/@field1'

FROM sysobjects

FOR XML PATH('object'), ROOT('root'))

SELECT REPLACE(@xml, '...

Hi,

Have you got an example of the xml you're using to populate the table? :hehe: