J Livingston SQL (2/3/2016)

---

ChrisM@Work (2/3/2016)

---

silverbullettruck (2/3/2016)

---

Yes, it would be ok to switch values for the values that exist multiple times for the same LOB with different values, but the values...

silverbullettruck (2/3/2016)

---

Yes, it would be ok to switch values for the values that exist multiple times for the same LOB with different values, but the values that only exist once...

So it's okay to switch values between rows of the same LOB? That makes it easier - but it's still quite fiddly coding. One way...

sql.queries (2/3/2016)

---

Hi!

I have a query which needs to filter table according provided filters.

I need to filter just by the provided filters.

Example:

SELECT

Col1,

Col2,

Col3,

Col4

FROM

MyTable

WHERE

((@FilterCol1 IS NULL) OR (Col1 like @FilterCol1))

AND

((@FilterCol2 IS NULL) OR...

silverbullettruck (2/3/2016)

---

MNS has two XLOC's so it makes it necessary to have both an 'MS' and 'ML' that is what is keeping the 'ML' from being an 'MS' or vice...

silverbullettruck (2/3/2016)

---

The uniqueness is across all of the attributes as a set. So in the example, there is a unique combination for MNS across XLOC, BPL, CRE, and ARA....

huasoBruto (2/3/2016)

---

Thanks for your replies... I'm thinking, its also sort of like the same, isnt it? I mean, you'll need to repeat each year as a new line... But next...

SELECT

Employee2006 = SUM(CASE WHEN [Year] = 2006 THEN EmployeePaid*2 ELSE 0 END),

Employee2015 = SUM(CASE WHEN [Year] = 2015 THEN EmployeePaid*2 ELSE 0 END)

FROM TblRecords

WHERE...

SQL006 (2/3/2016)

---

Thank you guys for your valuable inputs. I checked the execution plan for the UNION and the CROSS APPLY query, i am surprised that the UNION query is still...

msh083 (2/3/2016)

---

i have a view:

SELECT id_reg, name_reg, id_card, name_card, SUM(Expr1) AS Expr1

FROM ...

ROW_NUMBER() tricks with a CROSSTAB:

CREATE TABLE #PatientAppointmentDetails (Sno INT, PatID CHAR(2), Appoiintment_Date DATETIME)

INSERT INTO #PatientAppointmentDetails (Sno, PatID, Appoiintment_Date) VALUES

(1 , 'P1' , '01-01-2016'),

(2 , 'P1' , '02-01-2016'),

(3 , 'P1' ,...

SELECT *

FROM crpt_Test

WHERE batch_Id = '76D79E5E-07A6-4B8E-964F-6287DC4873F9'

AND chart_code BETWEEN '10000' AND '13000'

AND chart_code NOT IN ('12101','12110','12116')

eobiki10 (2/2/2016)

---

This seems to work for me in another way. I now have ALL in the parameter select box which shows everything .

AND

(

(NULLIF(isnull(d.dw_ac_approval_date,''),'') IS NOT NULL and @approval_date = 'YES')

OR...

Cadavre (2/2/2016)

---

Sorry, I...

Ahah! A bogstandard cross-tab. This article by Jeff [/url]explains how it works and how to extend the functionality:

SELECT

LOB,

[XLO] = MAX(CASE WHEN Attribute = 'XLO' THEN Value ELSE ''...