dwilliscp (6/4/2015)

---

Is there a way to use a case statement after "SET"? I am currently getting the following..

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'case'.

My...

You can use CASE in the OVER clause:

OVER (ORDER BY CASE WHEN @var=1 THEN Orderno ELSE Invoiceno END)

Edit: typing on fone on train

The OP is confused by the location of the ON clauses. Since there are only INNER joins, I don't think it...

Only the developer who...

This should be straightforward - fetch the top row from the customer table (ordered by LastUpdated) and any row from MessageTypeTrack which matches the filter criteria. I think the optimiser...

If you look at nodes 15 and 16 the actual and expected rowcounts are very different. The plan doesn't appear to be a good fit for this costcentre as it...

Rowcounts in the actual and estimated plans are very different - do you know anything about statistics updates in the database?

brad.pears (4/2/2015)

---

I've never seen that particular SQL coding before and I will try to use that. I have seen tons of SP's and views here where I work with lots...

George Wei (3/28/2015)

---

Dear all,

Our system runs a SQL Server 2012 DB, it has a table (table_a) which has over 10M records. Our system have to receive data file from previous...

SELECT [Out] = t.n+h.n+d.n

FROM (VALUES (1000),(2000),(3000),(4000),(5000),(6000),(7000),(8000),(9000)) t (n)

CROSS JOIN (VALUES (100),(200),(300),(400),(500)) h (n)

CROSS JOIN (VALUES (10),(20),(30),(40),(50)) d (n)

ORDER BY [Out];

WITH rs AS (SELECT * FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9)) d (n))

SELECT [Out]...

Servername\instancename

Eirikur Eiriksson (2/18/2015)

---

ChrisM@Work (2/18/2015)

---

Here's another way:

SELECT

a.[Pax ID],

a.[Flight Date],

a.[Flight Number],

[Last Mod Date] = CASE WHEN x.[Pax ID] IS NULL THEN a.[Last Mod Date] ELSE x.[Last Mod Date] END,

[Status] = CASE...

You're welcome - and thanks for the updates. I won't get near...

Thanks for this - there are a few...

That's the one. The WHERE clause at the end of all the queries turns it into an inner join. You...