as far as i know, this is a limitation in SQL for the try catch; you can only catch one error, regardless of the number of errors actually thrown.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3476a931-3db7-4017-9fbe-e082f2de2cb0/sql-server-trycatch-inner-exception-message-conundrum?forum=transactsql

---

....Yes, this...

i can't help with the nolock, but i bought a plugin for SSMS called SQL Enlight, which does check scripts for semi colons,fully qualified schema names, aliases and more; this...

the decision on needing some format was made above your head, but the implementation is where you have some flexibility.

you can still use a foreign key to a parent table,...

i'm thinking the issue here is what account is running SQL when you drop to xp_cmdShell; you are choosing trusted connection,w hcih means if the user running the services is...

are you having troulbe using XQuery?

here's an example based on your data, with that you can format it into columns or whatever.

/*--Results

SSN ...

great glad i could point you in the right direction then.

what's the query you would use to get tat same data from a single database? if you have that, you can automate it across all databases.

you just need to wrap...

/*--Results

ServiceTypeWebQtyTelQty

Cleaning600200

Support900400

*/

;WITH MyCTE([ServiceType],[CommunicationType],[CustomerQty])

AS

(

SELECT 'ICT','Telephone',500 UNION ALL

SELECT 'Cleaning','Web form',600 UNION ALL

SELECT 'Support','On site',35 UNION ALL

SELECT 'ICT','Web form',300 UNION ALL

SELECT 'Cleaning','On site',40 UNION ALL

SELECT 'Support','Telephone',400 UNION ALL

SELECT 'ICT','On site','100' UNION ALL

SELECT 'Cleaning','Telephone',200 UNION...

glad i could help!

post your new error if you think a little peer review might help you get past that one as well..

seen that one before! there's a secret switch in there that lets you install; i've had to do the opposite...install the 64 bit verison wher ethe 32 bit office was...

i was unclear on the requirements, myself....i thought this was a visualization of a hierarchy, so he'd want whale--shark--pirana--octopus

his sample table is a varchar(1), also, which would probably be an...

modify your table to have the database name in it.

explicitly name your columns in the insert statement.

since this is in a cursor/loop, just udate the database name where it is...

yeah nvarchar uses twice the memory to store the data, that can be confusing.

that's because nvarchar can store character sets that varchar can't.

select N'??? / ??? huìyìzì','??? / ??? huìyìzì'

/*

(No...

data length returns the length of the string, not the memory required to store the string itself.

so the data_length really is five, but yes, sql uses at least seven...

don't be ridiculous. you can run it on production. it's doing what your server is already doing; in this case it creates a four gig file and tests how fast...