Viewing 9 posts - 1 through 10 (of 10 total)
I am trying to create a procedure to pull the ID information based on LocationName from a view.
It is just the procedure I want to have the vaiables - the...
February 23, 2009 at 12:10 pm
No, that's my whole problem. the columns that appear in the view are what @IDs is set to. what I am attempting to do is have the values...
February 23, 2009 at 9:18 am
Here is the stored Procedure
CREATE PROCEDURE .[ACTIVE_IDs_LOCATION] (@LocationName varchar(30), @IDs varchar(500)) AS
-- Generally a good idea to have this in procs
set nocount on;
-- Final select
SELECT
LOCATION,
LOB,
TT_INFO,
Right('0' + Convert(VarChar(2), Month(START_DATE)), 2)...
February 23, 2009 at 8:48 am
That takes care of the Replace error. I have renamed dbo.numbers to user.numbers, as I have not been able to crated dbo.numbers. Now I am getting Error 207:...
February 23, 2009 at 7:44 am
I now get: Error 174: The replace function requires 3 arguments.
Note: I have created a user.NUMBERS table
Dan
February 20, 2009 at 7:51 am
When I add the code:
And @IDs in
-- string parser
...
February 19, 2009 at 7:42 am
My mistake - it is SQL 2000 - I do not have access to create dbo.numbers. is this a requred table? can it be any name?
dan = noob
February 18, 2009 at 1:26 pm
When I check the code syntax in Enterprise Manager I get the following error: Error 170: Line 48: Incorrect syntax near '.'.
Line 48 is
(select x.y.query('.').value('(/row/@x)[1]', 'int')
is x.y.query...
February 18, 2009 at 1:05 pm
GSquared - over my head. :crying:
February 17, 2009 at 1:37 pm
Viewing 9 posts - 1 through 10 (of 10 total)