ETL Developer roles is another way to get into MS BI arena.

Come on.. let's have one massive group hug, even uncle Bill Gates is invited 😛

Waiting for the pros to offer their solution but this is my attempt:

with cte AS (

select quoteid, requestid, createdat,

ISNULL((select top 1 datediff(dd, b.createdat, a.createdat)

from...

OnlyOneRJ (9/5/2013)

---

Nothing like that..

Customer just want a Project plan on existing environment we have..

and have asked us to come up with do & dont's on DB server..

Like following standards, what...

Could you please supply the CREATE TABLE statement and some sample data please?

This is a great read if you have the time:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

The function is below:

Example of how to use:

select Item from [DelimitedSplit8K]('6000, 7000, 600000, 3393043, 274878423, 2837423', ',')

DROP FUNCTION [dbo].[DelimitedSplit8K]

go

CREATE FUNCTION...

That's not what Koen meant but never mind it appears that you're choosing the name based on descending alphabetical order.

Try the below:

SELECT

A.[ITEMID]

, A.[LabelCode]

,(select top 1 NAME

from...

....so true, I'd be shovelling poop for a living if it wasn't for Google :hehe:

p.s.

No disrespect to those...

I profusely apologise your almightiness!

No seriously, I empathise but don't let the prawn sandwich...

They can take away the title but they can't take away your knowledge.

You'll still be earning plenty of $$$$$ 😉

Sweet.

One thing I should have mentioned is that its best to specify a length when casting/converting to VARCHAR. But I suppose it doesn't matter in your case as you're casting...

What's funnier is that once you get through this book + plenty of practice, you'll start to see these joins in...

Select orderid, orderdate, empid, custid,

(Select MAX(O2.orderid)

FROM Sales.Orders AS O2

WHERE O2.orderid < O1.orderid) AS...

Anytime 😀

Maybe you need to change the primary column to something like this?

( SELECT [Name] + ',' + [State]

...