Hi

King

I tried it but it did not update the rank at all!

Thanks

Suman

Here is the whole thing you can run along with your update statment

Drop table #Table

...

Hi

Flo

Thanks for response

if you read the requirment in detail, you will see its not so simple as incremental increasing the rank

field. It is increasing the rank to the...

i found my answer on my own

Under the Flat file connection manager, select the ragged right under format lookup and select option columns and it will give actually...

Hey

Lowell

Thanks for the input , but i was able to do it with the help of user defined function and if you would like to explore it is posted on...

Hey

Mahesh

you are the man, it gave me what i was looking for,perfectly.

I really appreciate it and thanks for the help

Thanks

simon

Thanks

Adam

But, even for me its not every mail that SQL procedure send , its just few of them. Where do i go from here?

Thanks

Simon

Hi

adam

I tried the test mail it worked just fine, just one mail at a time. It seems like exchange problem as you mentioned but do you know forum that i...

Hi

adam

i see only one time stamp for that particular mail

Thanks

simon

Hi

adam

First

it put the value into @tableHTML variable

SET @tableHTML =

N' ' +

N' '+

N' OPI - '+ convert(varchar(20), GetDate() -@Days, 1)

...

Hi

adam

Thanks for the quick response, but i dont think its stored procedure . I think it has to do with Queing of mail from database mail. The stored procedure...

Hi

Rog

I did it before you post this thread by creating some temp table, ( because of pressure of deadline). I used your script and it worked perfect too. I...

Hi

Jeff

i got it down twiking a little bit on your logic , the one problem that i was addresing about adding new SRID for all those existing IDs, i solved...

Hi

Jeff, Gus

I was not trying to mislead you guys by properly not explaining the whole scope at the begining. I thought giving the small portion of scope will help instead...

Hi

Jeff

In order to trap the first and last record of each sequence , the scenario we had was based on max(id) and min(id), now if there those id 1,2,3,4,5,6...

Hi

Jeff

Everything worked out perfect, exactly what i wanted. After a long time , i am going to have good night sleep. I am not scared of going to work on...