fireblues
asked on
Create Stored Procedure from a table and add an extra column using join
I have a table. I want to develop a report that requires an additional column in that table. The additional column comes from another table.
I am planning to create a stored procedure from that original table and then to add an extra column from the other table using join.
To be informed that the data is updated regularly so I cannot use SELECT INTO kind of query.
How can I do this?
Does any one have idea or better suggestion to accomplish this?
Thanks in advance.
I am planning to create a stored procedure from that original table and then to add an extra column from the other table using join.
To be informed that the data is updated regularly so I cannot use SELECT INTO kind of query.
How can I do this?
Does any one have idea or better suggestion to accomplish this?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for guiding me the way for the solution.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for fireblues's comment #a39854353
for the following reason:
I solved it using different way.
Accepted answer: 0 points for fireblues's comment #a39854353
for the following reason:
I solved it using different way.
In comment #a39854353 you stated the following: "Thanks for guiding me the way for the solution." That's a strong indication that the earlier posts have helped you to get to your solution, even if you "solved it using different way". So those posts should get accepted as solution, not your own comment. For that reason I'll object once more... (previous objection was because you closed with a C-grade without any further interaction with us, read through the links posted by Netminder to get an understanding why that's not a good idea)
ASKER
Since, I am new to this portal, I didn't know about the grades A, B and C.
Now that I have read, I know what they mean.
My apologies.
Of course the link helped me to go in certain direction.
I'll definitely reward points for that. :)
Now that I have read, I know what they mean.
My apologies.
Of course the link helped me to go in certain direction.
I'll definitely reward points for that. :)
ASKER
Thanks.
Open in new window