that has saved me so much time. Thanks.

😀

Hi

it's a strange one.

I have a 64 bit VM (Server 2012) with 32 bit Sage ODBC which isn't working in SSIS. I can see the data in preview but...

hmm, i did add myself (current user) when i did the install. I have resoved it by getting one of the domain admin guys to login into the VM under...

That's kind of what i thought. Problem is i can't even access the report manager page due to permissions. Do i need to get the admin account to give me...

i think so? 😐

I really want to be able to pivot the data in excel so i can see ytd by

week

week - product

week - customer

week - customer - product

Hi, thanks for the replies

I have attached some script which creates a couple of simple tables/data and then create the data set i have.

I'm still not getting the correct result...

what i'm trying to do is a year on year comparison

so the first thing i did was to create 2 data sets, one for current year - week and and...

I'm hoping that they can save the file somewhere then run a job/tasks/process/file? that will import it into the db.

Thanks

Thanks for the replies..

perhaps i should have given my final expectations...

i have 2 tables which i'm trying to join. I know the lot exists under the conditions in the subquery...

and just to expand on this a little further, here's the calculation to do the YTD for the same period the previous year....

=CALCULATE(SUM('Fact Proteus Sales'[InvoiceValue]), DATESYTD(SAMEPERIODLASTYEAR('Dim Dates'[Date])),ALL('Dim Dates'))

solved it....

many thanks to this vid...

https://www.youtube.com/watch?v=E-3TST8uLSk

🙂

a media event is created which has accountId, stockId, startDate, endDate. (it also has some other details about the event).

after insert, delete, update i need

1) to calculate a %...

i'm relatively new to t-sql and i've written it as it works so please don't ban me from the forum based on this. It's also quite lengthy.....

first the trigger. It's...

exactly correct ChrisM@Work. i had a trigger which was a single row update on the table i was trying to delete from. I disabled the trigger and my t-sql ran...

thanks for the replies, still not working.

annoyingly this test code seems to work....

-- create the test tables

create table test1(

MediaDetailId int identity (1,1) not null,

Qty int null

)

create table test2(

MediaDetailId int

)

-- insert...