IF condition how to use it for two times in stored procedure

Posted by Vijay.Kumar under Sql Server on 10/9/2012 | Points: 10 | Views : 1869 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to use if condition in sql server

in this my table having two columns where column1 is in and column2 is out

i want write condition using ifpls help me

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Pandians on: 10/9/2012 [Member] [MVP] Silver | Points: 25

0	I could not follow your requirement... Can you please explain more ? Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Vijay.Kumar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Kanje_Ravi on: 10/9/2012 [Member] Starter | Points: 25

0	Hi Vijay.Kumar , from you are query i understood that you have a table of 2 columns ..i assume you want to apply if condition twice on your table of two columns TABLE IN OUT here i can understand columns will take in time and out time value and you want to check in and out time using if .. Please come up with your clear requirement with sample record..? Thanks & Regards, Ravindra M (Success Always Depends on Dedication & Commitment) Vijay.Kumar, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Vijay.Kumar ,

from you are query i understood that you have a table of 2 columns ..i assume you want to apply if condition twice on your table of two columns
TABLE
IN OUT

here i can understand columns will take in time and out time value and you want to check in and out time using if ..

Please come up with your clear requirement with sample record..?

Thanks & Regards,
Ravindra M
(Success Always Depends on Dedication & Commitment)

Vijay.Kumar, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts