ramos.ferdinand (10/16/2013)

---

Hi guys,

I'm trying to create an hierarchy using tsql. Below is a sample data:

Column 1 Column2 ...

Bit difficult to see exactly what you want to do, so I'm going to take a stab in the dark.

First, it's always a good idea to set up readily consumable...

emdavies82 (10/15/2013)

---

I am new to sql and would like your help. I have a table that lists an payroll reference number for all the workers in the business. for example...

Learner1 (10/15/2013)

---

Thanks a lot..

but If I had to add CTE and temp table I could have done this ,Can you suggest any simple way to just add a third...

Take a look at the 8K Splitter[/url].

IF @Division = 'All'

BEGIN;

SELECT DISTINCT C.COMPANY_SK, C.COMPANY_DESC

FROM DIVISIONMAPPING D

INNER JOIN VW_DIM_COMPANY C ON C.COMPANYID = D.COMPANYID

...

abhas (10/15/2013)

---

Thanks HB,

But i need to display data for prev 5 months, current month and next 6 months. along with year.for example for example, current month is Oct, then I...

easy_goer (10/14/2013)

---

Hello. I apologize that my original post was a bit unclear. Based on the table in my original post, I am able to pull the following

2689222701Extra18106

2689322701Extra28106

with...

Thanks for the sample data Dwain.

Another option: -

SELECT *

FROM @T

EXCEPT

SELECT TOP 2 *

FROM @T

ORDER BY Column1;

In SQL Server 2012, you could use the OFFSET command, which I think is like...

dwain.c (10/13/2013)

---

Not that it means much until you upgrade, but you may want to consider avoiding these 2 because they seem to fail in SQL 2012 using Cadavre's test harness:

SELECT...

I know it is irrelevant, as you're not going to be doing this over a lot of rows of data but in the interest of completeness, here's a performance comparison...

Loads of ways. What have...

Junglee_George (10/10/2013)

---

This is the query part:

; with BaseProjects (

materialItemCode,

hazardCode)

as (

select

Mi.materialItemCode,

CAST(H.hazardCode as NVARCHAR(1000)) as hazardCode

...

This is to do with how a query is executed. I'll try and explain but I've never tried to put this into words so forgive me if it's odd.

Logically,...

-- CREATE SOME SAMPLE DATA TO USE TO TEST THE SOLUTION

IF object_id('tempdb..#temp') IS NOT NULL

BEGIN;

DROP TABLE #temp;

END;

SELECT ID, VAL

INTO #temp

FROM (VALUES(1,'ABC DEF GHI JKL'),

...