Search results for query: *

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 <...

I'm sorry.. Ur Right.. it's col02+col03+col04

No, There are more records and some don't have 'A' ... some just might have gaps... but either way they need to have rows 0-9 for every combo of col02 & col03 but if it's missing there is normally an 'a' in its place

I did look at that article, however, I didn't think it worked for me (tried it, got errors) because some of my data has As. PLEASE SEE DATA Col02 Col02 Col03 Col04 Col05 Col06 566 210 478 0 6671 TX 566 210 478 1 6671 TX 566 210 478 2 6671 TX 566 210 478 3 9533 TX 566 210 478 4...

Can you break it down for me... I haven't ever used the WHERE NOT EXISTS **(yet)** Ie... select [block id]+1 from Table #TmpLergConvert where not exists (select 1 from Table t2 where t2.ID+1 = t1.ID) AND ID < (select max(ID) from Table) Where does the (1) come from in the...

I'm looking to find gaps in sequences.. Ie. DATA ID 1 2 3 4 6 7 8 9 A I have 10 lines, w/ the number 5 missing, so I want to find which is missing then replace the A w/ the missing number. Else Delete the A... Any Ideas??? THANKS ahead of time