vijayarani87.s (7/6/2012)

---

Hi I know what is happening, but i need to update fields in MEAS table based on Metric ID, the update statement which i have provided is not updating...

Execute the below mentioned query

I had created a SELECT query from your UPDATE query

This results should give you an idea of what is happening

SELECTLEAN.METRICSID, MCD.PERFORMANCE, MEAS.*

FROM schemamanlog.trnleanmetricsperformance "MEAS"

INNER JOIN @METRICCOLORDETAILS...

Any specific reason for this preference?

Also check the...

You can use the INTERSECT and EXCEPT operators

SELECTAN.artist_name, G.Genre_name

FROM#Artist AS A

INNER JOIN#artist_name AS AN ON A.art_id = AN.art_id

INNER JOIN(

SELECTA.mid

FROM#Artist AS A

WHEREA.art_id IN ( 'art1' )

INTERSECT

SELECTA.mid

FROM#Artist AS A

WHEREA.art_id IN ( 'art3'...

The sample data provided is not that extensive

Consider the below scenario

DECLARE @tbl_Student TABLE

(

StudentID INT,

FavoriteSubject VARCHAR(50)

)

INSERT @tbl_Student( StudentID, FavoriteSubject )

SELECT 1, 'Subject1' UNION ALL

SELECT 1, 'Subject2' UNION ALL

SELECT 2, 'Subject3' UNION...

You will probably need a CURSOR then to check all possible combinations and select the minimum one

I am unable think of a set-based solution right away, will let you know...

What is the maximum number of subjects that will be passed in the 'INPUT_SET_AS_LIST_OF_VALUES'

Will it be always 2 or can it be more than 2 ?

You will probably need an IF..ELSE block to achieve this

IF EXISTS(

SELECTStudentId

FROMStudentTopTwoChoices

WHEREFavoriteSubject IN ('INPUT_SET_AS_LIST_OF_VALUES')

GROUP BY StudentId

HAVING COUNT(*) > 1

)

BEGIN

SELECT*

FROMStudents

WHEREStudentID IN (

SELECTStudentId

FROMStudentTopTwoChoices

WHEREFavoriteSubject IN ('INPUT_SET_AS_LIST_OF_VALUES')

GROUP BY StudentId...

Good work with the test data

I hope the below query helps

DECLARE @Checkin date = '20120703'

DECLARE @Checkout date = '20120705'

DECLARE @diff tinyint

SELECT @diff = DATEDIFF(DAY,@Checkin,@Checkout)--+ 1

SELECT @diff As datedifference

; WITH cte_Rooms...

dilipd006 (7/3/2012)

---

I haad written a query using dense_rank() it returns the following table

HotelID RoomID AgencyID ...

The explanation given is not very clear

If you can explain more about your problem, we can even suggest you better solutions

Scorpion_66 (6/29/2012)

---

You can delete as many rows from the table as you like. The trigger fires FOR EACH ROW, so is fine handling one record. Test it, you'll see. Just...

Welcome to SQL Server Central

Please check the link in my signature on how post your questions for faster and better replies

Since this is your first post, I have done some...

eagb (6/28/2012)

---

Yes you are correct it's part of the trigger. Thank you for helping me see that! Unfortunately I can only suggest they change the linked database so most likely...

Edit: Removed the solution as it was incorrect for some cases on a larger data set