SWITCH should stop processing once it has found the first true value, hence why I put the Expr.Value = 0, 0 as the first value to check to stop running...

Open up BIDS, select a New Integration Services solution, then you will see the tasks in the toolbox.

Duplicate post

Replies here please http://www.sqlservercentral.com/Forums/Topic1363376-391-1.aspx

Can you elaborate a bit further?

Do you mean what tasks are avialable in SQL Server Integration Services (SSIS)?

Table is to small for it to be reorganized, typically anything less than 1000 pages should be excluded from rebuilds/reorganizations.

ramachandran narayanan (9/24/2012)

---

Dear Sir,

I have a query

there is only one field 'datetime' in the table.I have to calculate shifts ,intime and outtime is needed.

how to calculate intime and outtime?

Thanks and...

ReportServer is the webservice side of the application, you shouldnt point users to that address unless they use Chrome or Safari as that is the only way I know of...

Please do not cross post.

Replies here please http://www.sqlservercentral.com/Forums/Topic1363325-391-1.aspx

In that case there must only be that one login on the server.

Can you attach a screen shot of the security --> logins area in Enterprise Manager.

If the indicator is embedded inside the table then you dont need the "DataSet" tags as the tablix takes care of which data set to use.

=SWITCH

(

Fields!Expr2.Value = 0, 0,

Fields!Value.Value >=...

Yes you will be able to recover to a point in time.

I would strongly recommend moving into the old way that your used to in creating seperate files for each...

Yep, it looks like you can rule reports out of the offending TempDB growth then based on that information.

Are you embedding the indicator inside a table as a column object like I did in my sample report?

Only thing I can suggest is to attach the RDL file along with some sample data and I will give it a go here.

Unsure, looks right, only thing I can think of is to enclose the last two in brackets, so the division is done before the evaluation

=SWITCH

(

(Fields!Expr2.Value, "DataSet1") = 0, 0,

(Fields!Value.Value, "DataSet1")...