yeah, that was easier, works perfect thank you so much

This is the result set it presented and I don't understand....  I am running a summary on activity for the year...my columns being the different activities and the months -...

This is what I got to work.....in case anyone was interested

SELECT     COUNT(*) AS Total

FROM         records

WHERE     (DATEPART(year, reportsentdate) = @year) AND (DATEPART(month, reportsentdate) = '01')...

Maybe I should have been more specific  Ignore Column_b and Column_c - as they are values derived in a completely different way.  All I...

Exactly it, thanks!

right....the query I have listed above gave me all the records that were "lost" or or did not have a value that could reference  my primary key table, center.

Once I...

ok, think I got it....did this:

SELECT center.clinicname, center.clinicphone, records.recordnum

FROM records

LEFT JOIN center on

 center.clinicphone = records.clinicphone

WHERE center.clinicphone is null

then it executed successfully.

thanks for your help!!!!!

kristin

hahahah!  you lost me  how do I do that?

sorry!!!!!

This is the error I get...what do you make of it??

Server: Msg 547, Level 16, State 1, Line 1

ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_records_center_FKNAME'. The conflict...

Yeah!  EM boots me, and also makes the Database Hang on all my users.  Can you help with the script I would need to run in Query Analyzer?

And as for...

right....but if I try to change the length of some of my fields in the design view, I get booted. 

Another strange thing is this.  I copied the table and...

Thanks for all your help guys, worked like a charm  I went with the simpler alter table route:

ALTER TABLE TableName

ALTER COLUMN ColName bigint

really appreciate...

hahahah, touche! And quick question, as long as I have your

In your first code example, can I use a variable like that in...

nice hat paul, thanks  did you give me that nice rookie pic? hahahah!

wow, super sorry if I offended anyone by posting in the wrong forum, my mistake, won't happen again. 

Thanks for the help anyway!  I'll post in the other forum.

regards