I totally agree; however, this is a vendor txt file that is being dropped on our FTP and I have no control over how it is formatted or built.:crazy:

Does anyone...

Well at least there is a work around 😀

I look forward to the day I can copy well formatted code from this site.

Thanks.

I was able to do a small scale insert using xquery. You should be able to mold the methodology to fit your needs. Note: the xml tags were messing...

Yes you can remove any of the reporting service instances at your leisure.

The reason your nt login cannot delete reports is because you have not given your login access to...

sr,

If I were you I would not just delete things but rather go to add/remove programs and uninstall unnecessary instances of reporting services.

I am not quite sure what you mean...

Wow its that easy :blink: Live and learn.

Thanks for your help Lowell, and Jason!

Jeff your method is equisite as usual 😉

Luissantos, if you just want to get it working with the cursor you can make the following modifications.

code below

--------------

DECLARE RunningTotalCursor

CURSOR LOCAL FAST_FORWARD FOR

SELECT...

How did you setup security for the web service identity and reporting services database? It sounds like you are using windows credentials.

When you deploy a report it must add...

If you need automation, you can choose either openrowset or SSIS. If you choose to do SSIS you can create a package and schedule it. If you choose...

luissantos,

Against my normal practices I have written a cursor that will perform the same calculation :crazy:. The cursor should perform better, if there are lots of rows involved. ...

Run the query, with the data you need,in SSMS and send results to file. Name the file: "filename.txt" and make sure to click "All File Types" or it will put...

luissantos,

You should be able to do something like:

min(a.Debit) as [Debit Amount],

min(a.Credit) as [Credit Amount],

sum(b.Credit-b.Debit) AS [RunningTotal]

And In the From clause add the table aliases

FROM ...

The SQL 2005 instance already has a database named test2. Delete the database and then restore or rename the restored database something other than test2.

The link below will give...

luissantos,

you can use a statement like below.

declare @MyTable table

(

RowID int IDENTITY,

dt varchar(10),

doc varchar(20),

DEBamt smallmoney,

CREamt smallmoney

)

--date | document | debit | credit | balance

insert into @MyTable values ('16-10-2007', 'inv.111',0,100.00)

insert...

The only way I can think of is to use dynamic sql, but there may be a better way. Below is a sample.

declare @var table

(

var_name varchar(20),

var_datatype varchar(20)

)

insert into @var...