Thank you for the quick response I will give this a go and let you know.

Cheers,

Oliver

Hi,

I like the idea of merge replication becuase there is going to be big gaps between sync's. From what I read merge replication can work essentially one way by selecting...

Hey thanks for the reply.

What transactions are applied. I dont wish to have the subscriber sending any data back to the publisher?

Thanks,

Oliver

Thanks for the reply much appreciated.

Many Thanks for the reply, I have used the rows to row code and then created views for each of the tables and brought this into a single view.

SELECT

...

Thanks i thought this might be the right way to go about it.

Much appreciated.

Oliver

brief thought could you use a view to pull in the dynamic data and run the pivot t-sql on the view - you would need to now what the data...

use the PIVOT T-SQL

http://www.tsqltutorials.com/pivot.php

Many Thanks,

Got this working as a sp without issue.

I understand now why the UDF wont let you run a sp inside it.

Many Thanks, you are a star.

Oliver

PS - I am not trying to change the stucture of the data but simply filter a UDF based on a sp.

Thanks!

Thanks for the reply.

Basically the requirement is to dynamically filter a set of abstracts based on the permissions associated with the login. Basically the website will request these results and...

Sorry,

I have now included this in a UDF and I get the error :

Invalid use of a side-effecting operator 'INSERT EXEC' within a function.

what can I do to resolve this...

Gail,

THANK YOU I understand what I did wrong now, many thanks for the help. I take your point over the length - however the variable table is going to be...

Hi,

OK I think I have tracke it down to refering to a table variable column as @tbl.column1

why is it not possible to do this

I would like to create an inner...

Many Thanks,

I have also discovered that UDF's might be a way forward, by passing the username of the user loggining in and finding out what group member that user has...