June 21, 2012 at 12:35 pm
Hey How are you there ?
I have to create stored procedure , i can do that but the difficult part is i have to add INVOICE and the INVOICE FORMAT is like this:
SSSSDDMMY-C
123415062-C ( C- MEANS Correction)
And i have to Create invoice By Day And By Store
Any idea out there ?
June 21, 2012 at 12:40 pm
3935 (6/21/2012)
Any idea out there ?
Heya there, and welcome to the forums. If you'll take a look at the first link in my signature below, you'll see a recommendation on how to help you post things so we can help you figure out what you need, in particular when you're asking for coding assistance.
As your question stands right now... not a single clue. We don't know what you started with so we can't help you get there.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 21, 2012 at 12:55 pm
3935 (6/21/2012)
Hey How are you there ?I have to create stored procedure , i can do that but the difficult part is i have to add INVOICE and the INVOICE FORMAT is like this:
SSSSDDMMY-C
123415062-C ( C- MEANS Correction)
And i have to Create invoice By Day And By Store, I just want to know what could be the syntax to add Invoice in stored procedure ?
Any idea out there ?
June 21, 2012 at 12:57 pm
Right, because quoting yourself and bolding your own statements is really going to answer my questions.
Let's try this again; since we haven't seen your schema nor your stored procedure, the answer is: "No, we haven't a clue, we can't see your code." In theory, type it into the column list and let 'er rip. That's the best anyone here can offer without a lot more specifics.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 21, 2012 at 12:57 pm
I have to agree with Craig. There isn't enough information to even give you a shot in the dark. Please read the article that he suggested, it will help us help you if you follow the instructions in that article.
June 21, 2012 at 1:14 pm
remember, we are on the other side of the interwebz here, and not looking over your shoulder. you've been looking at the issue for hours, and we onyl see three sentences you wrote.
what does "create an invoice' mean to you?
for Craig, it might mean a row in a specific table;
for Lynn, it might mean a suite of information in related tables;
for me, it might mean a physical pieceof paper on "Barbara's" desk.
if you provide details, the volunteers here can offer suggestions.
Lowell
June 21, 2012 at 1:20 pm
3935 (6/21/2012)
Hey How are you there ?I have to create stored procedure , i can do that but the difficult part is i have to add INVOICE and the INVOICE FORMAT is like this:
SSSSDDMMY-C
123415062-C ( C- MEANS Correction)
And i have to Create invoice By Day And By Store
Any idea out there ?
Sorry about thats guys , Let me work on that. Thank you for replies
June 21, 2012 at 2:22 pm
Are you just asking how to create the invoice number? What are the arguments to the proc going to be? Are you passing it the store and the date or will it read the store number and date from tables? If the latter, what are the definitions for those tables?
If you can post the table definitions, some sample data, the output expected from the sample data and the arguments you'd be passing in to the proc, the folks here can offer better assistance.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply