|
I a project we are having following tables -
Branch
BCode
BName
Vendor
VCode
VName
VendorPaymentHistory
VCode
PaymentDate
CashAMount
VendorCouponHistory
VCode
SCode
Date
Quantity
Price
Sale
SaleCode
VCode
SaleDate
SalesLine
SaleCode
PCode = Product Code
Price
Quantity
Now I am trying to write a query which will return following, -
For any date -
VendorCode(VCode) - Sum(Qty) Product Wise - Total Value of Coupons - Total Cash Paid - Day Balance - Previous Outstanding - Net Balance
I am not able to complete this? Any Help?
|
|
|
|
|
Have you tried using sub-select statements? For example:
select Vendor.VCode,
(select sum(SalesLine.Quantity) from SalesLine
inner join SalesLine
on SalesLine.SaleCode = Sale.SaleCode
where Sale.VCode = Vendor.Vcode) as SumProductQty
--other sub-selects go here
from Vendor
order by Vendor.VCode The sub-selects are allowed to reference fields within the Vendor table.
Regards
Andy
|
|
|
|
|
I am using MS Access 2003, I think it doesnot supports this.
Thanks
|
|
|
|
|
The only way to find out is to try it. Saying that, I do believe that Access supports this because this is a standard SQL technique and not a vendor/tool specific one.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello
How can i use ado.net to send multiple queries to database and perform them. Example, I need to create a stored procedure programatically from my application. any way to do that. or is it possible to execute some transact sql statements like
declare @value as money
select @value = 10
How can i display the messages send by SQL server after executing queries in my application ?
Please help
Cheers
Navaneeth!!
|
|
|
|
|
You can put just about any SQL you like in a SqlCommand. So, yes, you can create stored procedures from your application.
Navaneethkn wrote: How can i display the messages send by SQL server after executing queries in my application ?
I've never needed to do this, so I don't know. However, if the SQL causes an exception to be thrown the messages will be in the exception message.
What's in the messages that you want back?
|
|
|
|
|
I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem.
Give me an instant solution to rectify this problem
regards,
Tech_spidy
|
|
|
|
|
Hi
Replace single quotation with double quotation before sending to database.
it will be like this
comment's will be comment''s
Cheers
Navaneeth!!
|
|
|
|
|
hi Navaneeth,
thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this.
thanks for ur temprory solution. if you/anyone know the exact solution please reply..
regards,
Tech_spidy
|
|
|
|
|
Hi,
I think Navaneeth mend to say: Replace the single quotation by two single quotations.
Wout Louwers
|
|
|
|
|
Hi Tech_Spidy
Don't worry. In database only single quote will be stored. It won't store '' in table.
Cheers
Navaneeth!!
|
|
|
|
|
Thank you so much navaneeth..
wht u suggested is exactly working..
regards
Tech_spidy
|
|
|
|
|
Use parameters to insert strings in to the database. That way you don't have to escape quotation marks. And you improve the security of your application.
|
|
|
|
|
ok.. i will try tht.
thanks for ur response.
regards
Tech_spidy
|
|
|
|
|
In SQL 2000 there is some thing called
SET QUOTEDIDENTIFIER ON/OFF
Pls check this. would help you.
|
|
|
|
|
thanks for ur response krish. but i m using sql server for this wat navaneeth suggested is working exactly .
regards
Tech_spidy
|
|
|
|
|
Hello all
am creating simple application in vb.net 2005 sql server 2000 as my back end,
My problem is for gender identification am creating Radio buttons in the Frontend. How do I Specify data type (varchar/ navarchar/float) for that Radio buttons? How i store its value in the back End? Please help me
|
|
|
|
|
Hi
In my point of view, you can store the values as varchar. If it is male then store in table like M. When fetching the data, check if that is M.
Cheers
Navaneeth!!
|
|
|
|
|
Hello,
You can use bit data type if your gender is limited to male/female. If your gender is more than 2 types i.e. male/female/unknown then you can use tinyint or int.
Thanks
Mehedi Hasan
|
|
|
|
|
how i will do this in C#?
list all doctors whose birthday falls between the coming weeks Wednesday and next week Tuesday. The client will run this report every week. So say the client runs it on 12th February which is a Monday it will list all doctors whose birthday is between 14th-20th Feb.
|
|
|
|
|
try using these functions
getdate()
datepart()
dateadd()
|
|
|
|
|
Hi all,
How can I convert all the data that is present in SQL server in to XML format. If its big, then atleast provide me some link. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi
Fill a dataset with your data from SQL database. User dataset's write XML function to create XML file.
OR
Read the database row by row and write each row using xml text reader
Cheers
Navaneeth!!
|
|
|
|
|
Sorry for the late reply, but I need it without using the .Net coding. And from SQL server tools or from any other database tools. Please help me if you could. Thank you.
Regards,
Mohd. Abdul Aleem,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi ,
i've just started using slq server 2005 express. I know how to put a table into a dataset and then if i have two datasets i can make a relation between them via code[DataRelation].But why then , do we make relations in the database itself?
My scenario:
In my DB I have Three tables:
Persons : PID , Name
Items: ItID , Name
Purchases PID , ItID.
[there are 2 relations FK_Purchases_PID , FK_Purchases_ItID]
I have listboxes on my plain app , one of them is filled with the persons names. Now if i click a particular name i should get the corresponding purchases?
If i load each table into a dataset and then remake the relatioships via code it seems silly.
Would someone show me the best way to do the aforementioned?
I'm using C# 2.0 , .NET 2.0 and sql server 2005.
Thanks
Gideon
|
|
|
|