Unless I missed it earlier in the thread, has anyone wondered why the text is "DW.DimClass"?

Is this data coming out of a Data Warehouse?

If so, would you not be...

Glad you got it working.

I am not an expert on XML Namespaces in SQL server, so I could be off the mark, but it seems like there is an issue with the nodes that...

It would help if you provided information about what you have tried....

however this might steer you in the right direction:

;with xmlnamespaces(

DEFAULT 'http://www.lpsvcs.com/DataStream',

'http://www.lpsvcs.com/DataStream/DataDictionary/Document' as ns24

)

select @x.query('//ns24:Document')

This does not...

Have you checked the Schema Changes History Report?

Have you considered writing a database trigger to log the procedure drops?

Something along the lines of....

CREATE TRIGGER log_procedure_drops ON DATABASE

FOR drop_procedure

AS

DECLARE @msg...

@jeff 😀

(I have seen that format quite often in data interface files - as it avoids the issue of different locales/regions using different decimal seperators e.g. "." and...

I've got to ask because I am always looking for the simple solution to things....

If trailing "0"s are allowed, why bother with all that?

Why not just (based on the column...

Is your application using SQL Authentication while SQL Agent is using Windows Authentication?

I like Jeff's solution, but just wanted to offer an alternative that requires no user input beyond the initial running of the script....(I like not having to think)

Firstly, here is...

Reason: By including NULLS in your SELECTS, you are sort of adding extra NULL values to the sets Nb and Nc...

You can achieve the same by doing this:

SELECT Na.Number [Ball...

Hi, can I suggest that you do not use a trigger as there is no immediate need.

You said yourself...

sorry - posted about the comma without seeing all the other posts - dunno whats wrong with this browser of mine...

I agree about normalising.:)

However if you have to do it this way, you can:

Use Unpivot

Or

Use a where clause like:

WHERE 'CODING' IN (skill1,skill2,skill3 etc...)

I make no claims for performance or...

I do apologise - it's such a long...

Sorry!

The...