I used table areas just as an example the actual table is Clusters and the structure of the table if as follows:

CREATE TABLE [dbo].[Clusters](

[ClusterID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT...

hi I have the same problem except my case statement should look something like this:

Select distinct staffno

from dtiheadcount dt inner join reportingstructure re

on dt.costcenter = re.costcenter

Where period = 201002

and...

thank you member that solves it.

kind regards

doesn't give an error and doesnt' give results.

this is all I get "Command(s) completed successfully."

You could also try something like

Select *

From Computer_lists

where list_type = 'software'

and value not in (Select Distinct Product_name from Software)

Hi Vishal

Thsnks for the feedback, I tried it like you suggested but I'm still getting an error.

=IIF(Parameters!Consolidate.Value = "CONSOLIDATE", "Retail HeadCount : "& Cstr(Parameters!EndPeriod.Value) ,

strConv(Parameters!Consolidate.Value,3) & " HeadCount...

Sorry about that

Staffno name position posid headcount period

123 john developer ...

Yes that was the problem, you'll notice on my second post that I have removed it.

Thanks for feedback

It's Ok I fixed it

Declare

@EndPeriod Numeric,

@Consolidate Varchar(200),

@Level3 Varchar(200),

@Division Varchar(200)

Set @EndPeriod = 200912

Set @Consolidate = '(Retail Consolidate)'

Set @Level3 = '(LEVEL3)'

--Set @Division is null

IF @Consolidate = '(Retail Consolidate)'

Begin

SELECT ...

Hi There

I use a udf I found on the net a while ago and it has been working wonders for me with any form of date.

CREATE FUNCTION [dbo].[fnFormatDate] (@Datetime DATETIME,...

Well this code is for a report in ssrs.

the variable @TranferType will only have 1 value at a time, so the = is still ok in that instance. The problem...

Thanks for the feedback guys

What i was trying to achieve is:

Evaluate the contents of variable @Consolidate, if = (Retail Consolidate) then headcount = transfercluster else headcount In...

I got the solution guys. A collegue of mine help.

Declare

@Var1 Varchar(200)

set @Var1 = 'Area'

exec('select Distinct '+@Var1 +'

...

Yes along those lines but I want to use that variable as a place holder in a select statement where the first step would be to populate the variable then...

You are talking about the scale. I am talking about format code where you choose show label of the value axis