Here's my current SQL which I'm using in another section of the web system.
I think it just needs adapting to include the extra query? Maybe this is
where I'm going wrong - narrow minded?
DECLARE @userid AS int
SET @userid = 3
SELECT DISTINCT Adverts.Identifier
FROM Adverts
WHERE Adverts.FK_Users = @userid
UNION
SELECT DISTINCT Adverts.Identifier
FROM Groups
INNER JOIN Users_Groups_Link
ON Users_Groups_Link.FK_Groups = Groups.PK_ID
INNER JOIN Adverts
ON Adverts.FK_Users = Users_Groups_Link.FK_Users
WHERE Groups.Administrator = (SELECT Users.Forename FROM Users WHERE
Users.uID = @userid)
I forgot to give you this CREATE TABLE which is the additional table needed
in the newer query - described in the next email. :-)
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Advert_Fields]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[Advert_Fields]
GO
CREATE TABLE [dbo].[Advert_Fields] (
[PK_ID] [int] IDENTITY (1, 1) NOT NULL ,
[FK_Adverts] [int] NOT NULL ,
[fldOrder] [int] NULL ,
[Field_Name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Line_Count] [int] NULL ,
[Data] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Max_Characters] [int] NULL ,
[Demo_Text] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Export_To_Internet] [bit] NULL ,
[Heading_Sort] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Sort_Field_1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Sort_Field_2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Sort_Field_3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[fldUse] [bit] NULL ,
[MotorList] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
setuser
GO
EXEC sp_bindefault N'[dbo].[blankstring]', N'[Advert_Fields].[Data]'
GO
EXEC sp_bindefault N'[dbo].[blankstring]', N'[Advert_Fields].[Demo_Text]'
GO
EXEC sp_bindefault N'[dbo].[zeroNumber]',
N'[Advert_Fields].[Export_To_Internet]'
GO
EXEC sp_bindefault N'[dbo].[zeroNumber]', N'[Advert_Fields].[fldOrder]'
GO
EXEC sp_bindefault N'[dbo].[zeroNumber]', N'[Advert_Fields].[fldUse]'
GO
EXEC sp_bindefault N'[dbo].[blankstring]', N'[Advert_Fields].[Heading_Sort]'
GO
EXEC sp_bindefault N'[dbo].[zeroNumber]', N'[Advert_Fields].[Line_Count]'
GO
EXEC sp_bindefault N'[dbo].[zeroNumber]',
N'[Advert_Fields].[Max_Characters]'
GO
EXEC sp_bindefault N'[dbo].[zeroNumber]', N'[Advert_Fields].[MotorList]'
GO
EXEC sp_bindefault N'[dbo].[blankstring]', N'[Advert_Fields].[Sort_Field_1]'
GO
EXEC sp_bindefault N'[dbo].[blankstring]', N'[Advert_Fields].[Sort_Field_2]'
GO
EXEC sp_bindefault N'[dbo].[blankstring]', N'[Advert_Fields].[Sort_Field_3]'
GO
setuser
GO
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
