The table in question contains detail records for a master which need a custom sort order determined by the user. Regardless of the specific physical order of the records, the...

Looks like @@RowCount is what I was looking for thanks.

Oh yeah, that's fine. I won't complain. But you do have to admit that it will significantly contribute to the general knowledge base.

Table Structure. Note the default.

[Code]

CREATE TABLE [dbo].[Delegates](

[Id] [int] IDENTITY(1000,1) NOT NULL,

[ContactId] [int] NOT NULL,

[DelegateContactId] [int] NOT NULL,

[ExpirationDate] [date] NULL,

[Priority] [decimal](7, 1) NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Delegates] ADD CONSTRAINT...

Uhh....CTE?

Also, I replaced the INDEX hint with an ORDER BY but it didn't work properly.

BEGIN

DECLARE @id_start decimal(7,1)

SET @id_start = .1

BEGIN

WITH RecordSet AS (Select TOP 100 Percent Row_number() Over(Order By ContactId,...

So other than switching the INDEX to an ORDER BY, things look pretty on target? My experience with SQLServer is along the lines of advanced beginner.

The fields in the parent table will be in the partent Repeater or Gridview with the childs nested if that's not obvious. It also lays the groundwork for the user...

For the record, while the project got shelved temporarily, once it starts up we'll be using a asp:repeater nested within another control to generate CSS which pivots the data as...

Been busy...

For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not. Within...

If I could write the T-SQL then I'd post it. I am presented the data as it exists in the tables and as I need it displayed. Either help or...

My bad. Let's just pretend that that post was never posted as I now realize that it was way screwed up.

The Vertical table is

100001 ...

Looks like that did it, I just kicked it off. Seems to easy that MS would actually add text to the window to enter the name of a new database...

So how do I do a restore if the database doesn't exist already exist on the server? When I right click on the Database parent node and select 'RESTORE', the...