It sounds like you're looking for books, videos or online content. If so disregard the rest of this message.

In the event that you're looking for training by a person,...

I did not look...

lmu92 (3/5/2010)

---

You might want to use ROW_NUMBER() together with a CrossTab query as described in the related link in my signature.

If you need further assistance please provide table structure and...

Phil Parkin (12/31/2009)

---

Trick? 🙂

Why not use Windows Authentication - as desired - but have a File System task that runs first to copy the file to the local server? Then...

dugsmith (12/31/2009)

---

I've used an expression to set the connection property and I've hardcoded it.

I've changed it at runtime too. Perhaps it's the '$' in the path? How do I "escape"...

I'm just taking a shot in the dark with this but does this link help you?

http://blogs.perkinsconsulting.com/?tag=/cannot-open-the-datafile

Phil Parkin (12/31/2009)

---

It seems that you are not alone in having this problem. One solution might be first to copy the text file to a local drive on the server...

One other thing...before we upgraded to 2005, my bulk insert scripts in Enterprise Manager worked fine on SQL Server 2000. It was only after that we upgraded to 2005...

Mike01 (12/23/2009)

---

It's got to do with trying to convert decimal values to integers. Using Nabha's example, try running the following. The Round is performing an implicit conversion for...

Lynn Pettis (12/9/2009)

---

New code, does this help?

select

AcctNum,

ChargeCode,

ROW_NUMBER() over (partition by AcctNum order by ChargeDate) as ItemNum

from

...

Lynn Pettis (12/9/2009)

---

Answering my own questions (Only part of the output, order of charge code immaterial), here is some code:

create table dbo.Charges (

AcctNum int,

...

itemnumber is...

Oh and each record on the subquery will contain a whole number (basically number of days) that I'd like to keep there and then do a compute sum(days) at the...

I've never had this problem you're describing but I did find some information that may help you...

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e86bff38-6883-449d-befb-bf097000f29f

Thanks Jack. Your answer got me started. You lost me on what you said after the corrected code. I'm new to SSRS and I wasn't sure how...