Looks like a bug to me.

No, SQL Server Browser is a service that tells clients what instances are available and where they are.

I think that you might also be missing a plus sign ("+") between these two lines:

'and'+ '('+ 't.trantype=''T'''+ 'or t.trantype=''D'''+')'

'and(t.trandate>='+@@FortnightEndDate-13+'and t.trandate=' + @@FortnightEndDate +')'

Lynn Pettis (3/18/2008)

---

Here is my thoughts. If it is for school, the OP should do as much of the work as possible. If they get stuck, ask for...

Wow, that's an awful lot of heat for giving a one line answer to 2 or 3 day old question.

Seriously though, I cannot see why I should judge a whole...

Sorry, I haven't done SMO as CLR yet, just as a client call from a regular .net program.

Ah well, if you're sure you've got all of the transaction history, then I guess I could add a few lines to give you Closing_Balance:

With DailyTrans( TransDate, TotalDeposits, TotalWithdrawls...

Check out this query/view: http://www.sqlservercentral.com/scripts/tables/62545/

I'd recommend showing the query plan before execution.

You cannot calculate a Closing_Balance without an Opening_Balance, only a Net_total.

Try this:

Select TransDate,

Sum( Case TransName When 'Deposit' Then amount Else 0.0 End ) as TotalDeposits,

Sum( Case TransName When...

It's called "SQL Server Books Online".

I agree with you Matt, that's why the code changes that I posted report the actuall data-type of the Program parameter whenever anything goes wrong.

This is probably using the wrong (non-optimal) query plan because your parameters are changing.

Two ways to fix this as far as I know:

1) Add WITH RECOMPILE to the stored procedure.

2)...

Like this:

Select SUM(

DATALENGTH(col1)

+ DATALENGTH(col2)

+ ...) As [TotalBytes]

From order

Where order_id = @customer_order_id

Repeat for all relevant tables and add them up.

Error-handling I can do, however, Error-Reporting I do not know how to do within Reporting Services.

Here is your code rewritten with error-handling and standard WinForms error-reporting. You should have...

Question (for anyone):

What does the colon (":") on these names (":end_date") mean? They generate a...