Can you post ddl and sample data so we don't have to guess on what your tables look like? Please take a few minutes and read the first article in...

This produces the same output as your example.

if OBJECT_ID('MyResult') is not null

drop table MyResult

create table MyResult

(

TBLID int identity(1,1),

ID int,

patientName varchar(10),

age int,

city varchar(100),

Mobile int

)

insert MyResult(ID, patientName, age, city, Mobile)

select 1,'Ramesh',20,'HYD',12345678...

So you want to get the lowest of each value as the NewValue and the largest of each value as OldValue and then unpivot those results? Assuming that is what...

saravanan.kuttyy (3/18/2013)

---

I want to improve my DB Knowledge , i have experience in MS-SQL and ORACLE.

My Problem is when i face any interview i couldn't write query very fast .i...

steven.n.rhodes (3/15/2013)

---

Hi. Thank you so much for your effort.

I was trying to rush things before getting removed from my office, Fridays tend to be nuts at knock off...

jfogel (3/15/2013)

---

You can't control yourself can you? If you are so professional, why are you bickering on a message board? You keep talking about how professional you are but you...

You got the basic gist of what we need but you certainly didn't test it. There were a lot of issues here.

WorkflowId defined a uniqueidentifier but the values are...

I see that you are pretty new around here. It is recommended that you post ddl and sample data in a consumable format so the people helping can get right...

This sounds a little bit like a "catch-all" query and little bit like a "one proc to rule them all".

For catch-all queries you should read this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

For the one...

L' Eomot Inversé (3/15/2013)

---

SQLRNNR (3/15/2013)

---

Lynn Pettis (3/15/2013)

---

Stefan Krzywicki (3/15/2013)

---

Isn't 39,153 to 40,000 a count...

It would be great if you could share the steps you took so that others coming along here in the future can learn from all of you hard work. 😛

It is pretty tough to offer much help because the details are not very clear. It would help greatly if you could post ddl (create table scripts), sample data (insert...

It is like I always tell me wife...

"If there are...

sankar.nandakumaran (3/15/2013)

---

Hi......

I have one table in my database say for example "TableA" and the data is...

That is what Entity Frameworks seems to do most of the time. It generates hugely complicated queries...