ma701ss (1/3/2017)

---

Forget returning the user id or data from any other columns, is it possible to amend the code to just return one value, i.e. either -2, -1 or 1?...

If you want results from either one table or the other, then use IF EXISTS()

Do you mean this?

SELECT Reference_No

FROM (

SELECT Reference_No

FROM dbo.tblOptionalRefNo

UNION ALL

SELECT...

Can you write a better description of what you are...

You too, Ed. Best wishes for 2017.

ma701ss (1/1/2017)

---

Hi, happy new year, been away and just coming back to this now.

What I'm not understanding is why the return value is not either -1, -2 or 1. Why...

It's shortened...but is it fastened too? :-))

"Twitter" wasn't one of the answers, so I used this clue instead.

drew.allen (12/19/2016)

---

Aggregate functions automatically exclude NULL values, so this can be simplified.

SELECT *

FROM (

SELECT

*,

rn = ROW_NUMBER() OVER(PARTITION BY ProductId, ObjectId ORDER BY CheckNumber DESC)

FROM EuroLuxProductBE.dbo.pdt_multidimensions m

CROSS APPLY (

SELECT...

SELECT

[Source],

[Target],

StartDate,

EndDate = ISNULL(EndDate,LEAD(StartDate,1) OVER(PARTITION BY Source, Target ORDER BY StartDate,EndDate) - 1)

FROM #TEMP

greeshatu (12/23/2016)

---

@thom-2 a:Thank you for formatting my question .

That is what I exactly want . Could pls help me out

Actually My data will be huge So When I use the...

The sample data set has a row where both columns have the same value which messes up rCTE's unless you remove it. Even then, some of the parent values have...

Hi Richard, how many rows are you expecting back from this query?

nadersam (12/22/2016)

---

Hi Guys,

I am trying to execute an array of comma delimited SQLs in a stored procedure.

I call it as below

declare @Parameter as nvarchar(max)

set @Parameter ='insert into Orderlog (trans_no)...

That's not bad, Joe - I think MOD is the way to go with this.

The code can be trimmed down and tuned a little:

SELECT ShiftLabel = CASE WHEN n...