Viewing 15 posts - 7,456 through 7,470 (of 7,631 total)
Sorry, I haven't done SMO as CLR yet, just as a client call from a regular .net program.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 18, 2008 at 6:38 am
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 9:54 pm
Check out this query/view: http://www.sqlservercentral.com/scripts/tables/62545/
I'd recommend showing the query plan before execution.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 9:03 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 8:53 pm
It's called "SQL Server Books Online".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 8:21 pm
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.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 4:11 pm
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)...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 3:11 pm
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.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 3:01 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 2:52 pm
Question (for anyone):
roy.tollison (3/17/2008)
select * from detailwhere date >= :start_date and date <= :end_date and
status <> 'Successful'
What does the colon (":") on these names (":end_date") mean? They generate a...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 2:30 pm
Well, there's not a lot that I can tell without the erro Message, however, it's an odds-on bet that you are getting data-type errors. In particular, that whatever is...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 2:15 pm
As I recall, you can be pretty specific about which local logins get mapped to which remote users. And you can set the default to deny access unless a...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 2:05 pm
What is the error that you are getting?
What version of VB & Visual Studio? You also might try declaring the datatype of your variables and parameters.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 1:18 pm
Grant Fritchey (3/17/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 1:10 pm
Not disagreeing either, but what aspects would you say were the "glaring hole" parts?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 17, 2008 at 1:03 pm
Viewing 15 posts - 7,456 through 7,470 (of 7,631 total)