Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhiram_414
Starting Member
14 Posts |
 Posted - 2008-10-06 : 02:36:45
|
| Hi, I have an application where I need to change a cell value dynamically. That is once the query is executed the column value shound change dynamically to 1 (initialy it is 0 , bit data type) so that I can put a condition there according to my requirement. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 02:49:36
|
| can you give an example of how the value changes? based on what factor? |
 |
|
|
abhiram_414
Starting Member
14 Posts |
Posted - 2008-10-06 : 02:59:17
|
| Actually, I am writting code for birthday remainder in Asp.Net. There I wrote a query for getting all the mail ids of those, whose birth day date matches with today's date and then I wrote the code for mail sending. But the problem is as it have to be done automatically I write it in the page load so every time I execute it a mail is sent. So, I want to add one column for the table and it's value should be changed dynamically so, that for the first time when it is 0 mail will be sent and later on it won't on that day..... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 03:03:37
|
| on page load check if birthday is today and sent email and clear bit field tp 0 (let default value be 1). so that it will only send mails if bit is 1 (include this check in your send mail logic) |
|
|
|
|
|
|
To dynamically change a column value in SQL