I am familiar with the row number function and can see how that would help when there are instances of 3 or more insurances.

But how would you account for the...

Thanks for the direction...

create table #Orders

(

OrderID int,

...

Thanks again for the replies....

Here's what I did (that worked) in case anyone searches on this and needs to find an answer:

First, the query I need to return as a...

Thanks for the reply.

Any documentation (links) on how to create the batch file? I've never done that. I searched Google, but that wasn't much help. Also, the...

Hi guys,

Thanks for all the replies. Those links certainly did help. I have a few scripts that were helpful as well. But basically I had to go...

I just wanted to thank you guys for all your input. I added "optimize for unknown" to the sproc and the site is currently responding well.

I believe...

Thank you so much to all that have replied. I can't tell you how much I appreciate it.

What are atypical parameters (sorry, I'm kind of a junior DBA)? ...

Thanks for the info guys. I'll follow your advice and let you know if it works. I don't think the user works until next week so it may...

Nevermind. I used minimum and it worked.

Thanks so much for your replies. This really helped me!!!

Thanks again.

Do you know what I need to choose in the "usage" drop down so that the cube returns the sum of the billed by month (per my SQL) instead...

Thanks for your help with this....

HistDateKey InvDateKeyBilledPayments

1 1 ...

Thanks for replying. I can't post any data due to HIPPA, but here is a sample of what it looks like:

HistDateKey InvDateKey Billed ...

Thanks. I'll try selecting the max date. And I'll change the data access mode to table or view fast load.

I actually found a better solution to my issue (converting dashboard to 2008)

http://blogs.technet.com/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx

I think I found the answer:

http://blogs.msdn.com/vascov/archive/2008/09/30/using-performance-dashboard-with-sql-server-2008.aspx

create procedure MS_PerfDashboard.usp_Main_GetCPUHistory

as

begin

declare @ts_now bigint

select @ts_now = ms_ticks from sys.dm_os_sys_info