Dun

Declare

Zone

Good. Glad you got it sorted.

I meant to suggest using a CTE like this to get the base data using your original query:

;WITH CTE_Base_Data AS

(

Select S.number,

SStatus.name stat,

Sshis.StartDate

From supportcall S

JOIN...

Try this:

--== TEST DATA ==--

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

CREATE TABLE #TEMP (Number Int, Stat Varchar(10), StartDate DateTime);

INSERT #TEMP VALUES (17061, 'New', '2015-01-06 09:01:48.843');

INSERT #TEMP VALUES (17061, 'Assigned',...

Try this:

--== TEST DATA ==--

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

CREATE TABLE #Temp (SRC Int, IP_REF Int);

INSERT #Temp VALUES (1, 1);

INSERT #Temp VALUES (1, 1);

INSERT #Temp VALUES (1, 1);

INSERT...

Another possibility....

USE [tempdb]

GO

-- We have a sample gender data, with personid,firstname,lastname, gender etc. before creating a view we should consider,

-- if the gender doesn't exists, we have...

If you're using the sys tables (i.e. views) as source of the table names, use the columns view to identify the required column name & store this along with the...

What do you mean by "other Columns of the months "?

What is the problem exactly?

Can you move the calculations for the asterisk into the dataset, i.e. into the SQL? If so, you could perhaps create a second dataset sharing the logic to hold only...

If you post some sample data & expected results you'll likely get more response.

You can use recursive CTEs to show hierarchies.

For example:

http://blogs.msdn.com/b/simonince/archive/2007/10/17/hierarchies-with-common-table-expressions.aspx

It is a standard feature:

Properties window / Alignment / Text Align =...

You could truncate the table first, then load the data.

Alternatively

;WITH CTE AS

(

SELECT *

,RN = DENSE_RANK() OVER (ORDER BY FileID DESC)

FROM [dbo].[forecast_data]

)

DELETE CTE

WHERE RN > 1

(This actually...

Yes - I was wondering...

Can you post your real code?