Thanks for the info..

Ok I created a table called User_Zips.

The DB has a table called Zip

I want to know which ones are on User_zips that are NOT on Zip?

Thx

Evil,

This works great and I even understand it!! lol

Thanks

Joe

Sorry Lynn,

I'm new at this...

Wow not only doi need a SQL class..

I need a Forum Class!!! lol

Sorry Im fairly new and as u can tell didnt write what I showed..

Im trying to incorporate the second snippet into the first..

so if the person has an alias of...

sorry....

So I have the following to add client name

with tage_name = 'CUST_CLIENTNAME'

INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)

SELECT TAG_NAME = 'CUST_CLIENTNAME', TAG_DATA = (SELECT C.FNAME + CASE WHEN C.MNAME IS NULL THEN ''...

Hi Derek..

Still lost on this..

thanks Derek,

Im going to experiment

in the meatime

Hi,

Ok so I did this:

DECLARE @TEMPTABLE TABLE (

[ID] INT IDENTITY(1,1),

TAG_NAME varchar(255),

TAG_DATA image)

INSERT INTO @TEMPTABLE (TAG_NAME,tag_data)

select TAG_NAME = 'CUST_Photo', TAG_data =

(sELECT BLOB.BLOBASIMAGE

FROM Client

LEFT OUTER JOIN...

-- Declare @TEMPTABLE to hold values to be returned to HTML Form

DECLARE @TEMPTABLE TABLE (

[ID] INT IDENTITY(1,1),

TAG_NAME varchar(255),tag_image image,

TAG_DATA varchar(8000))

I added the tag_image

I should explain better sorry..

OK blobimage is an image field on a table

the SP is used to put data on HTML forms.

Here is a better snippet...

first this gets denist

INSERT INTO...

thanks..

I got a new one Im tottaly confused about stay tuned!!! lol

Wow never picked it up!!

WOW i NEVER PICKED THAT UP!!

thats a good explaination..

Im putting it on my Fridge!!

thanks that works great...

hate to be a pain I really am new, can u explain why that is, just so I know?

Thanks