Viewing 4 posts - 1 through 4 (of 4 total)
Tommy,
I apologize for cross posting.
Can you please explain me about this particular area of a solution? I like to know the process.
--------------------------------------------------------------------------------------
DECLARE @XML XML;
SELECT @XML = '<r>'+REPLACE(@Code_String, ',', '</r><r>')+'</r>';
INSERT...
September 24, 2010 at 6:07 am
Hi Tommy,
The solution worked for me. You saved my day. Thanks a lot. 🙂
September 24, 2010 at 6:03 am
Function simplified further.
ALTER function [dbo].[GetEloquaColumn]
(@Code_String varchar(200)) returns varchar(300)
as ...
September 24, 2010 at 12:28 am
Hi
ALTER function [dbo].[GetEloquaColumn]
(@Code_String varchar(200)) returns varchar(300)
Here the value passed looks like [dbo].[GetEloquaColumn] ('HC01,HC02')
as
begin
declare @code varchar(200)
set @code =replace(@Code_String,',',''',''')
set @code=''''+@code+''''
DECLARE @CodeList varchar(250)
SELECT...
September 24, 2010 at 12:20 am
Viewing 4 posts - 1 through 4 (of 4 total)