June 10, 2009 at 9:39 am
Hi All,
I'm still strugling.
I have attached two documents that I need help with. The one is the script that I have written to access data and the other is the view structure that i want to access data from. The problem is that I'm working is SQL2000 and I want to print a card for the street trader. The street trader is selling more than one product, when I try to print the card for one trader it prints as many cards as the products that he's selling. What can I do, to make sure that it prints only one card.
June 10, 2009 at 10:19 pm
Nkagisang Bosaletse (6/10/2009)
when I try to print the card for one trader it prints as many cards as the products that he's selling. What can I do, to make sure that it prints only one card.
Hi,
Your print card stored procedure calls the ufn_Getdescription function? If so
Then why you Call SELECT [Description], [dbo].[ufn_Getdescription] ( [rentid] )
FROM [dbo].[findstandbyidno] in the SP,
Printing of the unique vendor card is possible, may be it’s not the issue with the UDF,
Post you’re printing SP will resolve this issue.
ARUN SAS
June 11, 2009 at 12:29 am
Which is the table that has product.
I think you have to make a sales table that contains soled product.
It should contain soled products along with the tenant idnumber.
Join sales table also along with the tenant table(table with tenant details).
include some where condition like "tenant.idnumber=sales.idnumber" in the select statement which has sales.product , tenant.Fristname etc.
That what i think...............
Tanx 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply