There is a table which contains all the employee details,
unfortunately there is mistake occured while entering the
data.
ex:
-------------------------------
empid empname gender address
-------------------------------
1 abcd f address1
2 defg m address2
3 ghth m address3
4 jkil f address4
write a update query that will change gender 'm' to 'f'
and 'f' to 'm'
What is the difference between WebIntelligence and Designer
in creating universes?
10
One boy has to climb steps. He can climb 1 or 2 steps at a time.
Write a function that will returns number of way a boy can
climb the steps.
Int WaytoSteps(int n)
(eg:- suppose number of steps is n=4 ,the function will
return 5
(one-one-one-one ,one-one-two, one-two-one-,two-one-one,
two-two)
hi all,
i need ur help in preparing a sql which performs scd2, i
mean i have a scd2 mapping i need a sql which can give me
same result as scd2 mapping,
SRC table:
cust_no, loc
01 abc
02 xyz
TGT table:
pm_ky cust_no loc current_flag
1 01 abc Y
2 02 xyz Y
cust 1 has changed his loc to xyz then it loads into TGT
table as below,
pm_ky cust_no loc current_flag
1 01 abc N
2 02 xyz Y
3 01 xyz Y
i need sql to get the above result, hope got me question,
Any suggestion will be appreciate..
thanks,
Vinod
When we delete logfiles such as screenshots how does it
affect the ldf file? Ive seen huge change while adding
screenshots in the ldf file but a very minor one deleting
them.Please Explain
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
