ScottPletcher (1/24/2013)

---

AFAIK there's no any accurate way to do that.

I guess IF every caller used a different login or sql user, you could tell from that, but overall I think...

Something like this might work too:

SELECT [Table]=CASE WHEN a.[iNumerator] IS NULL THEN 'Table2' ELSE 'Table1' END

,[iNumerator]=CASE WHEN a.[iNumerator] IS NULL THEN b.[iNumerator] ELSE a.[iNumerator] END

...

ChrisM@home (1/24/2013)

---

Try searching for dwainc's article CROSS APPLY VALUES, it's the simplest solution for this. If you can't find it, post up ddl and dml for your 50-row table. The...

Try this:

DECLARE @XML XML = CAST('<p2:patient-working p1:value="Y"></p2:patient-working>' AS XML)

You'll get:

Msg 9459, Level 16, State 1, Line 1

XML parsing: line 1, character 33, undeclared prefix

So I don't think you'll be able...

vinu512 (1/23/2013)

---

You're welcome Ram.

But just to keep you thinking.....how is your on performance??

The following is the edited version of my query which gets you the results :

Declare @table...

What Evil Kraig is trying to explain to you is that to get better, quicker help on this forum you need to provide DDL and sample data in consumable form,...

Steve Jones - SSC Editor (1/24/2013)

---

The Dixie Flatline (1/24/2013)

---

Koen Verbeeck (1/23/2013)

---

WayneS (1/23/2013)

---

Koen, I like your #SQLFamily icon in your signature. You ought to put it somewhere and tweet it so...

The Dixie Flatline (1/24/2013)

---

Koen Verbeeck (1/23/2013)

---

Actually,...

PaulB-TheOneAndOnly (1/23/2013)

---

dwain.c (1/22/2013)

---

m.rajesh.uk (1/22/2013)

---

In my test enviroment i found that out of 269 tables 99 tables does not have primary keys and 4 tables having 2 primary keys ....

Are you kidding? Ugly is my middle name... 😛

DataAnalyst011 (1/23/2013)

---

Year Median Max Min...

dwain.c (1/23/2013)

---

Hold on there one minute. If memory serves me (and I'm working without a net here so bear with me), if I recall all the QU caveats in...

It is a good suggestion to do a performance test. I like general...

Hold on there one minute. If memory serves me (and I'm working without a net here so bear with me), if I recall all the QU caveats in Jeff...

Thank you you dog you!

Speeding up my approach is cheating isn't...

Thank you sir, for the vote of confidence but in truth there's been enough times I've been wrong to keep my head out of...