I've stopped counting how many times I forgot that .

If you get an error near the order by, it means that you must give an alias name to the table :

WHERE m.fkCouncilID = @CouncilId

) dtYourNameOfChoice -- End of virtual...

If you can then normalize... it's always the best option on the long run. But that would also mean rebuilding everything in the application.

I think you'll be stuck with dynamic sql in this situation... unless you want to create one sp per linked server and then dynamic sql in each sp... I...

Maybe the webadmin is not using your login and that this login doesn't have access (I never used it so I'm just guesssing here).

Have you tried dynamic sql?

Is there a good reason why you don't want to hardcode the query?

You could pretty much use the same report.

You have 2 ways of doing this

1 - let access do the work (as it is best pratice)

just put a textbox and put...

Check this out : it lists the relation name along with the table names and columns of the pk and and fks

SELECT TOP 100 PERCENT ORelations.name...

Maybe you could load the data in a staging table. Then you could insert only the valid data in the production table. That would also give you a...

check out

SP_Rename 'OldTableName', 'NewTableName', 'OBJECT'

SP_Rename 'dbo.Table.ColName', 'NewName', 'COLUMN'

I already ran a test with this (don't have it anymore). Was checking to see if doing

IF EXISTS (Select 1 from long query)

would be faster than

IF EXISTS (Select...

There must be a faster way than this to generate the records.. but I don't have time to search for one. I would try to generate 1000 records in...

That's why I should start drinking coffee.. would give me an excuse for those kind of days...

why not use a bulk insert method... row by row is gonna take way more time than necessary... I often see inserts of 250 k lines that take 1-2 seconds......

Recursive algorithm or error in proc?