mjh 45389 (7/19/2016)

---

Sadly I have encountered one to many people who believe knowledge is power and keep things to themselves. If they do not end up leaving they often morph...

I have been working from home part of, or most of the time, since 2009. First as a DBA for remote clients and since 2011 as a BI Person. I...

Thank you, thank you! I thought you might like that ;-).

+1

[Quote]Jeff Moden (7/13/2016)

---

Alan.B (7/13/2016)

---

CELKO (7/13/2016)

---

-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always inefficient and a nightmare for anyone to...

Note that Jeff's second solution will sort the results in the order you demonstrated in your original post. The NTILE solution would not. If you need the numbers in that...

Alternatively you can do it like this:

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

E2(n) AS(

SELECT a.n FROM E a, E b

),

E4(n) AS(

...

Start with: Querying Microsoft SQL Server 2012/2014.

Buy the exam book. Study it and practice the coding related to the subject matter one chapter at a time. Once you feel that...

CELKO (7/13/2016)

---

-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always inefficient and a nightmare for anyone to read or maintain....

To what? Who are you trying to communicate with here?

Mixed systems (those with more than one language embedded in each other) are always in...

Solomon Rutzky (7/9/2016)

---

Alan.B (7/7/2016)

---

Ok Solomon, I tried to figure this out and failed. Forgive my CLR noobness (I create about 1 CLR/year) and I'm sure this is simple but I'm...

Taxation

Easy one (but I still ran this in SSMS to be safe 😛 : EXECUTE('SELECT 1');)

I'm pretty confident that what I posted would do the trick provided the OP has or can add a datetime column.

shogunSQL (7/12/2016)

---

Hi,

I have a table like this:

Create table Tbl_Test01

(

Name nvarchar(20),

Item nvarchar(30)

)

;

insert into Tbl_Test01

values

('Car','Honda2016'),

('Car','Honda2017'),

('Car','Honda2018'),

('Tool','Dwwalt2016'),

('Tool','Dwwalt2017'),

('Tool','Dwwalt2018'),

('Tool','Dwwalt2019')

select *

from Tbl_Test01

I'd like to have the value of the column Name show up once and the...