create table #temp (ID int, Name varchar(20))

insert into #temp

values

(10, 'Helen'),

(20, 'Joe'),

(30, 'Blake');

;WITH OnlyHelen AS (

SELECT CTE = 1, *

FROM #temp

WHERE Name = 'Helen'

),

ExceptHelen AS (

SELECT CTE = 2,...

chadmack (4/30/2013)

---

Thanks to everyone so far, Code is over 9000 lines in its entirety.

This appears to be a data issue. The data in moveitems.description is getting tuncated, this is...

BRO?!!! Are you an old git too?

SELECT

d.Example,

[Output] = SUBSTRING(d.Example, 2,

NULLIF(CHARINDEX('/',d.Example,2),0)-2)

FROM ( -- sample data

SELECT Example = '/IT/Management' UNION ALL

SELECT '/PRODUCTION/Name' UNION ALL

SELECT 'Nothing'

) d

Sorry, I can only guarantee that it will run in SQL Server 2008 - this is, after all,...

Not really. The connect item refers to a bug which can only be observed if a very specific set of conditions are met.

Copy the lot, paste it into an SSMS window and execute it.

You're welcome 😉

todd.ayers (4/30/2013)

---

I am trying to create a random number generator that would populate a number between 8-48 to 9 different lanes with the only criteria being that each lane number...

issa269 (4/30/2013)

---

Thanks ChrisM@Work for the help, it removed the duplicates as i had asked but the total cost for the added column displayed value for only dollars(id for dollar is...

You need the ORDER BY, otherwise what TOP returns is unpredictable.

You also need the reference to table trans in the subselect because the [order] table is filtered by a different...

The subquery (inner query) you added isn't correlated to the outer (main) query. Since all of the tables in the inner query are already referenced by the outer query, do...

mister.magoo (4/30/2013)

---

Evil Kraig F (4/29/2013)

---

Because of Mr. Magoo's confusion as to my use case, I want to present an idea of the use case. It's not the one in...

@DJ (4/30/2013)

---

ChrisM@Work: I have never used cross apply before. Will have to study that one.

I see you placed an group by...

Is this needed or optional.

I am trying your version now,...

SteveEClarke (4/30/2013)

---

Hi All,

I am currently looking at a project that requires acounter table - I have done this very easilly in Excel with a VBScript - but want to do...