Counties Table:

CREATE TABLE [dbo].[Counties](

[County_Id] [int] IDENTITY(1,1) NOT NULL,

[County_Name] [varchar](75) NOT NULL,

[County_Code] [int] NOT NULL,

[State_Code] [int] NOT NULL,

CONSTRAINT [PK_Counties] PRIMARY KEY CLUSTERED

(

[County_Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...

States Table:

CREATE TABLE [dbo].[States](

[State_Code] [int] NOT NULL,

[State_Name] [varchar](50) NOT NULL,

[State_Abbreviation] [varchar](2) NOT NULL,

CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED

(

[State_Code] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =...

LOL...

All of my mine say "Scan". 🙁

I have primary keys for my tables, I don't get it.

Yea, it may take me a bit to round it all up.

I also need to note that when running the query directly in ssms it returns the data in under...

Sweet! Thanks for your help.

Table B

1, 'david'

2, 'mike'

3, 'john'

4, 'joe'

Table C

1, '4405 W South'

2, 'test address'

3, 'address testing again'

4, '1 more time'

1, 'finally a different address'

Here goes:

DECLARE @TableA TABLE (RowID int, Name varchar(20), Address varchar(50))

DECLARE @TableB TABLE (RowID int, Name varchar(20))

DECLARE @TableC TABLE (RowID int, BRowID int, Address varchar(50))

INSERT INTO @TableA

SELECT 1, 'david', '4405 W...

I don't understand what your looking for. The example above is pretty much it. Do you want sample data or something? I'm just looking for a sample query and I...

This sounds close but I don't see the part where table c has a reference to table b...

Normally what I would do (Which I don't think is the best way)...

Thanks! I'm on the right track now.

I know this is completely wrong as it selects the assigned records (and sorta duplicates efforts) but just so you can have an example:

Select * From Properties INNER JOIN (Select...

Yelena Varshal (1/23/2008)

---

They will add documents to the projects and it will take a lot of space.

My recommedations will be to store attachments in the file system and path in...

Joe Barbian (12/28/2007)

---

I don't know where your reports are coming from but I would suggest contacting the person who is sending the report and ask that they export the data...

Due to the volume of reports I will be facing like this (pdf format included), I think I'm going to look into the Monarch software as it seems a lot...

haha! I was talking to the department manager about doing that yesterday. I really don't know what some people are thinking supplying their clients with such ill formatted documents.