May 24, 2011 at 12:31 pm
look I need the output like this:
select grpnm,adeb,acrd,grpnm,adeb,acrd from grp
so it was not possible to create one view and display to outputs.
thats why i created two diffrent views and then combined them in another view.
quearys like :
for display assets side
select grpnm,adeb,acrd from grp
for disiplay liability side
select grpnm,adeb,acrd for grp
and then combined them in one view
select dbo.assets.grpnm,dbo.assets.adeb,dbo.assets.acrd,dbo.lia.grpnm,dbo.lia.adeb,dbo.liaacrd form assets cross join
liability.
but now the problem is it makes duplications. how can i avoid duplication to get output.
May 24, 2011 at 12:46 pm
prashantcomp90 (5/24/2011)
look I need the output like this:
:
Just because you want the output in a specified output does not mean that the solution is a view.:w00t:
Why not create a Stored Procedure with multiple Subqueries?
As Jeffrey stated Views are horrible with respect to performance.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2011 at 1:24 pm
could u give me the queary to do stored procedure. I have search on google but they are not working. can u give me the exact queary to do it please......
May 24, 2011 at 1:56 pm
prashantcomp90 (5/24/2011)
could u give me the queary to do stored procedure. I have search on google but they are not working. can u give me the exact queary to do it please......
What did you base your ten views on?
In my opinion more information is needed to solve this puzzle.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2011 at 2:16 pm
which information u need. u have the table details output details. other han this if u need information i will provide u please do some thing..
May 24, 2011 at 2:32 pm
prashantcomp90 (5/24/2011)
which information u need. u have the table details output details. other han this if u need information i will provide u please do some thing..
How about the DDL for the views and your code?
I have no clue what you want.:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2011 at 2:46 pm
I don't understand why you are making me so confuse when i have given you all the information about my table then which DDL u need. code. scripts for table u need. i have given u. please think some solution on it. Its too far we are having disscisions on the data tables and other thinks.
May 24, 2011 at 2:58 pm
prashantcomp90 (5/24/2011)
I don't understand why you are making me so confuse when i have given you all the information about my table then which DDL u need. code. scripts for table u need. i have given u. please think some solution on it. Its too far we are having disscisions on the data tables and other thinks.
We want to help you but you have to help us help you.
I don't think that you can honestly blame me for being confused.
You started out wanting one view and now you want to create ten views; where did that come from?
Your story keeps evolving...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 8 posts - 46 through 53 (of 53 total)
You must be logged in to reply to this topic. Login to reply