Recent content by Compkitty

Stsuing - THANKS!!! I did have it right; just needed to rebuild the solution to get it to take affect... THANKS to all of you who help us newbies...

Ok, This is giving me messages that MailAttachment is not defined... myMessage.Attachments.Add(New MailAttachment(fileName, MailEncoding.Base64))

stsuing - You said there was an attachment property...

Ok, Since I have never created a class w/ this before, can you tell me how I would call it from my button...?

Is there a way to email a file to someone w/in windows forms. the user would not input anything; just click a button so the To: & From: would be inputted already

You guys have been SOOOO helpful and i'm learning sooo much that I (obviously) didn't know or wasn't even thinking of...

SAMPLE DATA 460 561 522 A 7635 FL E 2005-05-13 00:00:0 460 561 522 A 7635 FL M 2005-05-14 00:00:00 SHOULD DELETE The (E) Record.. and leave 460 561 522 A 7635 FL M 2005-05-14 00:00:00 However, I have a table that has 51 records that are duped like this..

I want to be able to find which date is older between two rows w/ the same data.. Except the date(s).. One should be odler than the other and I want to be able to delete the one that is older... I'm not sure of a date function to do that...

Ok, I'm getting the same error again SELECT NPA , NXX, BlockId+1 AS BlockID INTO #tmp FROM #TmpLergConvert t1 WHERE not exists (SELECT 1 FROM #TmpLergConvert t2 WHERE t2.NPA = t1.NPA AND t2.NXX = t1.NXX AND t2.Blockid+1 = t1.Blockid) AND...

That's What I Have always thought, but started grabbing at straws when my UPDATES weren't working... THANKS

JAMESLEAN - THANKS!!! This is seeeming to work... I will reupdate this post when/after I run the next batch... THANKS so much guys....

Ok, I have a table that has 135 columns.. Well I am running stored Procedure that creates other tables and calculates my information.. Well both tables have PKs ( that are the same field/value) Well I want to update the table w/135 cols w/ this value into one of it's columns which currently is...

Why would I need to insert it??? OH... I see.. Well I'm not wanting ot (add rows) just update.. But I thought that I could INSERT Instead of UPDATE because my UPDATE was making all the other records NULL.... Is there another way to update one column w/ the data from another table...

HERE IS MY INSERT STATEMENT INSERT INTO Tbl_Temp_CDR(Bill_Duration) SELECT TmpEgress.Egress_Seconds FROM TmpEgress, Tbl_Temp_CDR T1 WHERE TmpEgress.Pkey = T1.CDR_Seq_Key HERE IS THE ERROR Server: Msg 515, Level 16, State 2, Line 1 Cannot insert the value NULL into column 'CDR_Seq_Key'...

Ok, working w/ the first part.. select Col02 , Col03, Col04+1 as Col04 into #tmp from #TmpLergConvert t1 where not exists (select 1 #TmpLergConvert t2 where t2.Col02 = t1.Col02 AND t2.Col03 = t1.Col03 AND t2.Col04+1 = t1.Col04) AND ID <...