I would advise strongly against creating a single procedure to retrieve all this data in a single step. As you stated, you will end up being forced to use dynamic...

vigneshkumart50 (6/6/2014)

---

Hi,

I have a table with a column which has list of ID in numbers. Any number can be master and child, but once an ID is mapped to child...

Myke85 (6/8/2014)

---

Yes, I understand that i don't get any rows for this query.

Yes, It is the really data and it is very strange for this that i have written for...

boks_18 (6/6/2014)

---

Hello.

I have removed the cursor and declare a temporary table where we perform data insert the deleted table and I make a while where I walk every record in...

Lynn Pettis (6/6/2014)

---

SwePeso (6/6/2014)

---

Naomi N (6/6/2014)

---

Peter,

I think we wanted customers who bought A and B but not C, so your query will be even simpler,

MIN(productID) = 'A' and MAX(productID) =...

Hi and welcome to the forums. What you have here is a performance timebomb. Cursors are notoriously bad for performance and inside a trigger it is a recipe for disaster....

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

The one that your supervisor does on you every year? To check if you are doing "Index Seeks" or just "scans" at your...

Here is a start.

create table scratch

(

Col1 bit

,Col2 int

,Col3 varchar

,Col4 varchar

,Col5 varchar

,Col6 varchar

,Col7...

Derp! I guess you did post in the 2005 forum. 😉

What about using MERGE?

Not big on providing details today I see. What does this query return?

select @@VERSION

The bottom line is that there are hotfixes out there to deal with this. You were...

fawad.majid (6/6/2014)

---

Hi there ...

I have two columns vital_bp_diastolic & systolic and the formula to calculate the MAP is [(2 * column) + column]/3 in SQL

i tried but...

The error you are seeing does not have to do with the order by. What version of sql are you running? There have been hotfixes for this issue depending on...

It works fine with intersect. Here is a full example to demonstrate it works just fine.

create table #tblLetterFlag

(

ClinicalReviewID int identity,

SomeValue varchar(10)

)

create...

It isn't a logic thing. The reason you sort by column name is because if you order by ordinal position and your query...