Click here to Skip to main content
15,893,508 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Shall I use Shape command in Sql server 2005 or sql server 2008?

I have following query

SQL
select p.purchaseBillId,p.Accountid,a.accountname,p.Netamount,
pd.ProductId,pr.productname,s.batchno,s.salerate,pd.TotalValue
from purchasebills p,purchasebillsdetails pd,accounts a,products pr,stockdetails s
where p.purchasebillid=pd.purchasebillid and
pd.productid=pr.productid and pd.productid=s.productid and pd.batchno=s.batchno
and p.accountid=a.accountid and p.purchasebillid=321


For this query I am trying to write shape command,how I can do this?
please help


[Edited]Code is Wrapped in "pre" tag[/Edited]
Posted
Updated 28-Jan-11 18:50pm
v2

1 solution

Check this[^] out.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900