Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

sampath


{ City }
< Country > india
* Profession *
User No # 86041
Total Questions Posted # 1
Total Answers Posted # 3

Total Answers Posted for My Questions # 3
Total Views for My Questions # 4829

Users Marked my Answers as Correct # 10
Users Marked my Answers as Wrong # 7
Questions / { sampath }
Questions Answers Category Views Company eMail

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 SQL Server 4829




Answers / { sampath }

Question { 3374 }

What is a GAP analysis?


Answer

It involves determining,documenting and approving the
variance between business requirements and current capabilities.

Is This Answer Correct ?    0 Yes 0 No

Question { CTS, 9017 }

If i entered 2 columns and 4 rows inputs in DDT Like Mango
fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q
is How to get the 2nd column value for corresponding 1
column input in 3rd row ie, ( i need to get "veget" in
messge box @ run time


Answer

datatable.SetCurrentRow(3)
x=datatable.Value("A",1)
msgbox x
datatable.Value("c",1)=x
msgbox c

--------------------------------------
A c
mango
banana
brinjal
carrot

Is This Answer Correct ?    5 Yes 5 No


Question { Cap Gemini, 7973 }

In ordinal identifier there r 3 options available. Which one
will be enabled first when ordinal identifier is invoked.


Answer

Its Index

Is This Answer Correct ?    5 Yes 2 No