Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to get for your free account now!
SQL2005 stored procedure question
Name: byrnesit Date: April 13, 2007 at 04:54:27 Pacific OS: SQL Server 2005 Express CPU/Ram: PM1.7 1024mb Manufacturer/Model: Dell
Comment:
Hi people,
I have a question about SQL 2005 stored procedures. I have a stored procedure that determins the current price of a stock item and I want to be able to 'select' the value when querying the stock table. IE: (in the form of a chunk of my main stored procedure)
SELECT description, ***, ***, ***, <result of stored procedure with 3 parameters passed to it>, FROM tblStock WHERE stockID = @stockID
Summary: I will first off admit - this is for school. I cannot figure out for the life of me why it won't work. I'm not expecting anyone to give me the answer (but would gladly take it!) but rather am lookin...
Summary: i have made a stored procedure in which two tables and ID field is provided as input and the result is used to fill a combo in a form .when i execute it i get the follwing error: Incorrect syntax near...
Summary: dear all, i have made a stored procedure to generate auto id . when iexecute the pro i get folowing error: Incorrect syntax near '0'. at the highlighted line .if i comment this line then i get this ...
