In Visual Studio:

1. Create an SSRS table with columns for surgical procedure & surgery date.

2. Click on that table then, under Row Groups, right-click on the "=(details)" group and...

Why not just create a table that contains the column names of <mytable> and their ordinal position. You could name it <mytable>_cols. Then use some logic in your dynamic SQL...

I think that this is what you are looking for:

-- Sample data

IF OBJECT_ID('tempdb..#YourData') IS NOT NULL DROP TABLE #YourData;

SELECT *

INTO #YourData

FROM

(VALUES

('162386-00','CHB',263,203,143,83,23,0,0),('162386-00','GRR',44,44,44,44,44,44,44),

('162386-00','MAR',0,0,0,0,0,0,0),('162387-00','CHB',83,83,83,83,83,83,83),

...

EasyBoy (9/13/2016)

---

We have one query which used by users to pull the report everyday in the morning. Which, i generally run through SQL and it takes only 1 to 2...

I don't know about ALWAYS. I said ROWS "often" (and could...

You beat me to it. Note that ROWS often performs better than range and can be used to calculate your HQuantity. Also note that the subquery is not required, you...

chris.evans 94907 (9/12/2016)

---

Hi Alan,

Thanks for the reply.

The script you provided returns the following results:

calDate ...

Since getting into technology in 1999 I've worked for two types of bosses:

1. Those...

You...

Ed Wagner (9/9/2016)

---

Touche, sir. I never thought to check the profile to see...

I just spent 5 minutes trying to figure out whey this INSERT statement was failing:

CREATE TABLE dbo.MyTable

(

SocialAdvertisingDimAdKey int IDENTITY(1,1) NOT NULL,

...

Post a sample of the XML you're working...

Ed Wagner (9/9/2016)

---

chris.evans 94907 (9/9/2016)

---

Hi Alan/Mike,

Following on from this, I'm looking to add a DATEDIFF calculation between today's date 'GETDATE()' and each individual date but only where the Working Day...

OPENXML should work just fine for this task.

Here's some sample data and an example of how to use LAG to get you started.

DECLARE @sometable table (ID int, DeviceID int, Value decimal(8,1), DT datetime);

INSERT @sometable

VALUES

(22, 4, 23.6,...