eh? :ermm:

lol...........ok, do you have any idea why it is complaining then mate?

Its distinct [ReviewID]'s im looking for. I should also point out that [feManagedReview] is a view.

Hi, thanks for the reply. Not sure what you mean though........im not using a group by at all.

Its fine, Got it:

SELECT TOP (@TOP)

cheers

bump

Hi mate.

Yes ive broken it down and ran the indivdual elements and they all run correctly. This one really has got me stumped!

Hmmm im now wondering if it is something to do with putting an ALTER command within a BEGIN......END.

Im getting similar weird errors when trying to alter views and stored procs!

Hi.

Yeah 100% sure...

Hey dude.

OK ive removed the line and my code is such:

?IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tblProductStockNote_tblLookup]') AND parent_object_id = OBJECT_ID(N'[dbo].[tblProductStock]'))

BEGIN

PRINT N'Adding foreign keys to [dbo].[tblProductStock]'

ALTER...

Hi im not sure why the ? appeared there. In the error message it just ''.

Anyway, i ran the following:

SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tblProductStockNote_tblLookup]') AND parent_object_id =...

Brilliant.

Thanks again Noel..........much appreciated.

Noooooo the saga continues!

OK........ive made the changes and have ended up with the following:

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'

AND...

Aaaaaaarrrrrgghh!!! :blush:

Thank you very much noel. Much appreciated!

Hello noel..........again many thanks. However it would appear the error is definately in the first few lines. I stripped it back to the following:

IF NOT EXITS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS...

Hi. Once again thanks for your swift response 🙂

OK..........i removed the 'GO's and the code i am left with is:

IF NOT EXITS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE =...