Requirement:

1. Check if there are records avaialble to be sent

SELECT

2.If there are not records

send an email notifying that there were no records

3. If there are records, run...

By the way I have that sp_senddbmail in sql statement too. I tried it. It's still not working

I have sql statement to run in OLEDB source, If record>0 then I want e-mail to be sent to me.

If record<1, I want couple store procs to run and...

need to export outcome in flat file and send it to e-mail. I don't see flat file in tools or is there different name for it? could you help me...

Thank you. I tried doing that but I still get an error. I think I didn't configure it correctly. Would you send me a link or any reference which will...

Thank you all for your input. I just had to update it which is done now.

Update the values with ABCD0123 if 3 digit

update the values with ABCD1234 IF 4 digit

for the same column now.

what would be sql statement?

Thanks

Thank you so much..

It worked.

sample rows as you requested

XYZ

ABCDEF1010

ABCDEF1012

ABCDEF102

ABCDEF1026

ABCDEF1030

ABCDEF1032

ABCDEF1044

sample rows as you requested

XYZ

ABCDEF1010

ABCDEF1012

ABCDEF102

ABCDEF1026

ABCDEF1030

ABCDEF1032

ABCDEF1044

Yes, I just have to remove ABCDEF and leave integer in that column. all records have ABCDEF.... ( similar values) in that table.

UPDATE TABLE

SET COLUMN = '0...' (THIS AREA)

WHERE COLUMN...

Thank you for your input.

I want to update in SQL. Your advice worked but only one row is affected from it. If I want to update all records in that...

Thank you for your reply. Per your advice,

I created

DELETE ABCDEF FROM dbo.XYZ

WHERE Column = 'ABCDEF100'

want to delete ABCDEF AND LEAVE 100 IN THAT COLUMN

Plz help me create statement for this...

DELETE ABCDEF FROM dbo.XYZ

WHERE Column = 'ABCDEF100'

This works now:-)

Thanks a bunch