stored procedure HELP(IMP) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

stored procedure HELP(IMP)

Author

Topic

ri16
Yak Posting Veteran

64 Posts

Posted - 2008-01-30 : 16:05:55

i have to write store procedure for moving all those category codes (topic, audience,format, etc)...
Then instead of hard coding these codes
in the ASP page, the page will simply pass n number of
parameters to stored proc. and stored proc will
then return the codes. so moving away from
hard coding those codes in the programming by moving
them into tables. (i have given one asp script...& i don't know asp at all..)if anyone can help me to write store procedure..then it would be really appreciated..

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-01-30 : 17:45:54

It looks like your question has gotten a little more specific then from your first attempt:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96498

But you are going to need to be way more specific than this to get a helpful answer.
Creating a stored procedure is easy:

create procedure mySP
@myInput int
as

print @myInput

go

What parameters will be passed in?
What table(s) will the data be stored in?
What codes will be returned?

Help us Help you

Be One with the Optimizer
TG

ri16
Yak Posting Veteran

64 Posts

Posted - 2008-01-30 : 20:51:33

There r so many columns i can't wwrite all..so few of them r like these:

skru,
abbre_name,
pdf_url,
html_url,
topic,
format,

case when format in ('PU-DC','CL-ME') then title
else pub_name
end as pub_name,
source,
itemtype,
view_type,

case when @bolType = 'gen' then

replace(replace(pub_name,'<i>',''),'</i>','')

else

replace(replace(title ,'<i>',''),'</i>','')

end
as title,
Audience,
Web_format,
qtyavail,
fromqty,
toqty,
uomprice,
prclevel

from DataSettable

pass parameter : @boltype, indx

return codes all above col.name from datasettable

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources