Answer Posted / sandipan sinha
if I am in need to see the data set in a tabular format
where for each column entry in primary key we can have more
than one entries in other columns,ssometimes they are
needed to be added and summed up together.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the example of procedure?
What is mdb stand for?
How would you convert date into julian date format?
what is log shipping? : Sql dba
Whis is not false in primary key?
what is normalization? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
what is sql server agent? : Sql dba
What is column?
What is union, minus and interact commands?
What is data type in sql?
How many types of relationship are there?
What is the maximum number of columns in sql table?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Define implicit and explicit cursors.