If SessionID was a necessary part of the solution, you...

This should illustrate how to do it in SQL... (Since no one ever takes the "let the reporting software do it" advise.)

-- Test Data --

IF OBJECT_ID('tempdb..#Transfers') IS NOT NULL

DROP...

sharonmtowler (8/5/2015)

---

I want to know if it is possible to do the following;

I have patients that may have been transferred to different locations(see below)

location_name enter_time

4D04 2/9/15 2:35

4D14 2/9/15 8:44

RECOVERY 3...

newbieuser (8/4/2015)

---

Friends,

What are other causes that make check/FK constraints non trusted because we normally don't enable/disable constraints during loads or scripts or anything. We always drop and re-create...

The attached script should help you generate usable test data... Simply plug in the table name (line 12) and the number of rows you want (line 18)

If you need to...

There are a few way of doing this, depending on what you want to do.

If your SSRS parameter is single single valued parameter (the user can select only a single...

If you're trying to create a pick list for an SSRS parameter, you're going about it all wrong.

Each SSRS parameter (that you want to have a pick list) just needs...

You're welcome! Glad to help. 🙂

Yes. There are several ways to write this query.

This should give you what you're looking for...

-- Test data --

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

DROP TABLE #temp;

CREATE TABLE #temp (

FY INT,

REVCODE VARCHAR(3),

Jul INT,

Jun INT

);

INSERT #temp (FY,REVCODE,Jul,Jun) VALUES

(2015,'BNQ',1054839,2000000),

(2015,'FNB',89032,1000000),

(2015,'RS',1067299,3000000);

-- The solution --

SELECT

t.FY,

x.[Month],

SUM(CASE...

Try this...

UPDATE h SET

h.CHANNEL1 = vc.C1,

h.CHANNEL2 = vc.c2

FROM

#Hori h

JOIN (

SELECT

v.FILTER,

MAX(CASE WHEN v.CHANNEL = 1 THEN v.VALUE END) AS C1,

MAX(CASE WHEN v.CHANNEL = 2 THEN v.VALUE END) AS...

Have a look at the following... I included two different solutions... Either approach could be faster than the other depending on the...

Looks like an expensive attempt to get the...

tstagliano (7/30/2015)

---

Not sure I am following what you are asking. My current output would look something like this.

Country_code Local_client_code Local_client_name ...

Yea... I see what you did. Sounds like you're the one with the correct interpretation of the requirements. Nice solution BTW. With a couple of indexes it would be easy...

I read "Cumulative Average" to mean...