You could also calculate this in an aggregated table that way there's no calculations in the report

I've used this technique a number of times in the past and it works...

Thanks for the responses

Just about to try the SP with OUTPUT method

Both parameter based suggestions seem to continue to return the same error

hmm, looks like output doesn't work either

Bit frustrating...

Perfect, pointed me in the right direction and now working

Also found this useful link as a result

https://www.simple-talk.com/sql/database-administration/setting-up-your-sql-server-agent-correctly/

Thanks

This might help:

https://technet.microsoft.com/en-us/library/ms190421(v=sql.105).aspx

bcp will attempt to load in one transaction so use bcp -b <transactions> e.g. 10000

Thanks Phil, on with your suggestion now

Thanks for the response

How would I use a foreach Loop if the files are structurally different?

I tend to do all my merging via T-SQL as it's much more efficient (certainly for what I want to do)

There's a very good tutorial here (with all 4 SCD...

Agree

I've done this sort of thing using the BI tool (for me, Cognos or SSRS)

Add a prompt for what you want to sort it by and present accordingly

It's not that...

Using your suggestion sergiy, I've managed to get it working

One question

You have:

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

This returns NULL

I've amended it to (changed + for =)

declare @MaxID...

Thanks for the advice

Unfortunately, it is 2008 so SEQUENCE is not an option

I'm going to look into the proposal by sergiy

For my purposes, I think I can remove all the...

I've just mocked up a quick report (in report builder)

Picked a column and set hidden to =IIF(Globals!RenderFormat.Name="EXCELOPENXML",True,False)

Now exported to Excel and the column is missing as expected

Is there something else...

Think you need to be looking at the hidden property

=IIF(Globals!RenderFormat.Name="EXCELOPENXML",True,False)

or EXCEL in 2008 R2

Stairway tutorials are great

Also look on youtube there's loads of tutorials on there

I quite like the wiseowl videos

You could use Generate Scripts

In SSMS, right click on the database

Select Tasks -> Generate Scripts

From here you can select specific database objects

User-Defined Data Types is an option

Does that help?

Thanks Eirikur

I basically get 3 tables that are fed from our source system and have no control over these

all_rating_notes contains an attribute (full_description) that is actually varchar(max) when it's written...