Tempdb, or some other safe, non-critical DB. Master is neither of those.

Have too many times connected to a server to run a bunch of DDL scripts, or compile a...

Damn! I want that on a sign above my desk. 😀 Guess I'll have to settle for a bookmark.

Peter Di (11/3/2012)

---

Jeff, This article is about calling a stored procedure with multiple parameters not for retrieving data from a column with values separated by comma. Do you really believe...

Great work.

Like many others, I had created reports for some of the admin issues covered here. Sadly (for my colleagues) my reports are not as nice as these.

I'll make...

Jeff: Neat. Whether it's the best on SQL Server or not is only partly the point (for me). I just like the different approach to the...

OK, here's one possible solution, but with a caveat. I'm not a fan of the

query('./../../{somenode}') syntax. Although it works, I've seen some awful performance with climbing...

At the risk of being redundant, excellent article, Gail. It should be compulsory "calm down and think" reading for any DBA facing an apparent catastrophe. Bookmarked and link...

I think the following will work for you (hard to check without real data)

select

Account.value('(./@Name) [1]' , 'varchar(100)') as accountName

,Account.value('(./../../@Name) [1]' , 'varchar(100)') as deploymentName -- in...

Outstanding. I'm on a project much like that one now.

Adriaan,

I'm rather surprised at the blow-out to ten minutes for that basic shred-the-tokenised-string-to-a-table approach.  I've done this several times as a way of dealing with SSRS multi-select, and found it...

OK, votes are in for "Rant of the decade".  Sorry, "Coherent, cogent rant of the decade".  Loved it.  Thanks Jeff

I was going to keep out of this until the statement about the design being crap. 

The clustered index is there - on that specific column - because it was...

I was giving up all hope, and now 2 responses in a day.

Thanks to both respondents.  Yeah, I'm having to do the CDATA wrap, but that now means more handling...

Your table definition is shown as:

Cia_Id           nvarchar 10 

Empleado_Id   int 4 

Ano_Vac        int 4 

Tipo_Mov       nvarchar 50 

Fecha_Inicial  smalldatetime 4 

Periodo_Ano   nvarchar 10 

Fecha_Final    smalldatetime 4 

Vac_Valor       real 4 

Date_Cre        smalldatetime 4 

Date_Mod       smalldatetime 4 

User_Id          nvarchar 10 

That number on the end looks like a data length - is that right? ...

Mike, not my post.  Judging from the tone of your reply you must be mistaking me for a previous poster.  Dunno who originated that script 'cos I don't have the energy to...