Stefan Krzywicki (12/6/2012)

---

L' Eomot Inversé (12/6/2012)

---

Brandie Tarvin (12/6/2012)

---

Hey, all. I don't know if I posted this before or not. If you're interested in writing, I have a special call that...

You're not doing yourself any favors by denormalizing the data. It makes the query reasonably tortured. Should look something like:

;with

t1 as (select distinct cn from @t),

t2 as...

Sean Lange (11/7/2012)

---

Matt Miller (#4) (11/7/2012)

---

Sean Lange (11/5/2012)

---

yogi123 (11/5/2012)

---

Hello

I need to delete 1000 rows from table and it should do it batch wise.

means

i need to loop delete statement that delete...

Sean Lange (11/5/2012)

---

Why...

Brandie Tarvin (11/6/2012)

---

For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

Anyone have any suggestions for me to...

Hans MZ (10/26/2012)

---

Mikael,

Son cientos de tablas pero cada una se manejará por separado. Una tabla a la vez.

Lo que no quiero es tener que personalizar la consulta para cada una...

Different task over here, but "Buried" is a good way...

TravisDBA (10/22/2012)

---

Then if that is the case, then just say that. "He moved on for personal reasons" and leave it at that. I would immediately understand that, but just to...

Steve Jones - SSC Editor (10/22/2012)

---

L' Eomot Inversé (10/21/2012)

---

I suspect you are making the same mistake as one of the commenters on the original post, and treating the "you" in...

L' Eomot Inversé (10/19/2012)

---

Sean Lange (10/19/2012)

---

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple...

Sorry about that, I was reformatting the XML after I pasted it in, and screwed up the stuff I posted as a result.

the corrected XML is

declare @x...

dwain.c (10/19/2012)

---

Another article I'm looking forward to reading.

Wish I'd seen this thread sooner as I might have been able to help. Not that I claim to know that much...

Yup.. the nskf: represents a namespace alias. You should find more info as to what it actually is in the header of the schema file.

<xs:schema xmlns:nskf="http://SomeUri.com">

<xs:import namespace="http://SomeUri.com" schemalocation="some XSD...

Try it this way:

with bob as (

select studentid, year, semester,

'Status1' StatName,

status1 as StatValue

from studstat

union

select studentid, year, semester,

'Status2' StatName,

status2 as StatValue

from studstat

union

select studentid, year, semester,

'Status3' StatName,

status3...

Resender (10/11/2012)

---

Matt Miller (#4) (10/10/2012)

---

If I may ask - why is there a hangup about making a connection to the server?

If you can dynamically build the connection string to...