DECLARE @table TABLE (stateName varchar(20), Count1 int, TotalChargeOffAmount int);

INSERT @table

VALUES

('Alabama',5,1000),

('Arizona',2,4000),

('Arkansas',3,5000);

SELECT

stateName,

Count1,

TotalChargeOffAmount,

[% of Total Count] = ((Count1*1.)/CountTotal)*100

FROM @table t1

CROSS...

Phil Parkin (9/15/2016)

---

Steven.Grzybowski (9/15/2016)

---

I wish I could....

Alternatively, you could create a specialized version of DelimitedSplit8K_LEAD[/url] that handles this (I'll let you come up with a better name;-)). My modification is bold/underlined.

CREATE FUNCTION [dbo].[DelimitedSplit8K_LEAD_XX]

--===== Define I/O...

What lptech posted may help. This is a pretty simple task. The way I would approach it is to:

1. Create a script task (whatever language works for you) that compares...

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,

...