Given that I'm not good at SSIS, I did this in Access, because it's what I know, and it works. (So it is good for some things!)

In my source...

So you're doing a self-join? Like in an Employee/Manager scenario?

See this article:

select *

from tablename

where deptnumber = &department_number;

Enter Value for department_number

if you do this in SQL Server...

SELECT *

FROM tableName

WHERE deptNumber = @DeptNumber

You will get a prompt in the GUI. If...

I'm queuing specific data from column called Node Alias, for example:

NodeAlias = '101.101.101.101' or NodeAlias = '102.102.102.102' etc.

So, my reporting works, but I want to rename what is viewed in...

Could you give an example of what you mean by "rename output data"? Do you mean aliasing column names so they display as something other than their original names...

Your table is really structured like that? What happens if you get more software packages? Does the table structure change? IF y

I think storing information using this structure/pattern...

You can import your reports into SSRS from Access, and as long as you're not using VBA functions in queries that your reports are based on, they should work. ...

How about:

SELECT x.Days, AVG(x.No_Of_IDs) As AvgCount

FROM

(SELECT Days,

count([ID]) as No_OF_IDS

FROM [Proddata]

LEFT OUTER JOIN SupplyData as S ON Proddata.Group = S.Group

GroupBy Days

) x

GROUP BY x.Days;

No CTE required.

What if you wrap the call inside a stored procedure or function and use EXECUTE AS to change the privileges the command is executed under?

My psychic abilities are failing me... could you explain what your goal is? Looks like you're trying to calculate a change in grades for a single (student,course) between two...

Kind of an old post, but this is how i did it.

1. Add a calculated field to the dataset.

2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)

3. Add a tablix to the report

4. 1st column:...

Kind of an old post, but this is how i did it.

1. Add a calculated field to the dataset.

2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)

3. Add a tablix to the report

4. 1st column:...

Open the report in design view.

Right-click a column, show properties.

Click on the Visibility tab.

When the report is initially run HIDE

Display can be toggled by this report item (choose a textbox)....

While you could certainly do it that way, I absolutely would not. If you concatenate everything and dump it into a new column or create a calculated column, you're...

Why do you need to create a table in SQL Server at all for this? You can base your report on a stored procedure and you're off to the...