need help - SP to move data

Hello
I am trying to create a stored procedure to move a ROW from Table1 to Table
based on a coditon.
Eg. I want to transfer an item with ITEMNO = '001202' FROM currentstock TO
old_stock table.
I want to be able to pass the value for ITEMNO from my code which calls the
SP.
Please help me
TIA
Mackok, I have done myself.
Thanks
"MackS" <mackS@.yahooa.com> wrote in message
news:OWiNi8H$FHA.228@.TK2MSFTNGP12.phx.gbl...
> Hello
> I am trying to create a stored procedure to move a ROW from Table1 to
> Table based on a coditon.
> Eg. I want to transfer an item with ITEMNO = '001202' FROM currentstock TO
> old_stock table.
> I want to be able to pass the value for ITEMNO from my code which calls
> the SP.
> Please help me
> TIA
> Mack
>

Need basic help with deployment

Hello

I feel like an idiot here, but I cannot figure out how to get Reporting Services to work outside of Visual Studio. I have everything installed (using SQL Server 2005 Express), I have a report, it deploys but when I go to view it, I'm asked for a username and password. I found out how to allow annymous login, but when I do that it says I do not have permissions to access the report on the localhost server.

I can view the report through Visual Studio just fine, but not outside of it.

How can I get it to just allow me to view the report without logging in?

Any help would be greatly appreciated.

Thanks
-JimWell it turns out the problem was that my default browser is firefox, and so it would deploy and try to open it that way and it wouldnt work. If I open it in IE its just fine, go figure :-\sql

Need advice re: SQL 2K + ColdFusion MX 6.1

Hello!

I recently upgraded my server from ColdFusion 5 to ColdFusion MX, and now I find I am unable to connect to my SQL 2000 datasources.

I am using Windows 2000 Server, latest service pack.

Now, I am a newbie when it comes to defining SQL users, so if anyone can walk/talk me through that process, including defining what my local SQL server is called, it may help.

Everything is running local on one machine...

Thanks!

RichardYou can name your datasource whatever you want. You define it in the windows ODBC setup. IE administrative tools -> ODBC. Then just set up the sql datasource in coldfusion using the SQL driver.

Navigation from the header

Hello

I have a link on the header to jump to another report. It was working fine on test server but when deployed to production, is giving the followin error. Any suggestions
Thanks

Inder

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

Hi Innder,

Check out the following posts they should help you.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=88770&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193096&SiteID=1

Hope this helps.

|||

Make sure to install SP2 of SSRS 2005 on the server (http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx) and drillthrough links in page header/footer should work.

-- Robert