Click here to Skip to main content
15,901,426 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

select p.purchaseBillId,p.Accountid,a.accountname,p.Netamount,
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]
Updated 28-Jan-11 18:50pm

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