User Profile

Collapse

Profile Sidebar

Collapse
asok
asok
Last Activity: Sep 25 '13, 05:06 PM
Joined: Sep 19 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • asok
    replied to function is not working 'in operator' method in stored procedure
    in SQL Server
    I will pass the value to function like 'abc,defd,ghjk' and function will return the value like 'abc','defd','g hjk' so that i can use 'IN' Operate to get the values from database.

    Here is the function which return the values

    Code:
    ALTER FUNCTION [dbo].[fnParseSplitString] 
( 
@InputString varchar(255) 
) 
RETURNS varchar(255) 
AS 
BEGIN 
    DECLARE @ParsedInputString varchar(255)
    ...
    See more | Go to post
    Last edited by Rabbit; Sep 20 '13, 04:56 PM. Reason: Please use code tags when posting code or formatted data. Second Warning.

      Leave a comment:

    • asok
      started a topic function is not working 'in operator' method in stored procedure
      in SQL Server

      function is not working 'in operator' method in stored procedure

      I am trying to execute below sp but i am unable to get the result.

      reasion is i am using function which is return string values like ('ab','df','dff f').when i use this function in operator it is not returning any value ..anybody help me why it is not returning ?.

      Code:
      function name ([dbo].fnParseSplitString(@stQueueName)))


ALTER PROCEDURE [Strategies_uspGetNoCreditBureauReview]
	-- Add the parameters
      ...
      See more | Go to post
      Last edited by Rabbit; Sep 19 '13, 10:46 PM. Reason: Please use code tags when posting code or formatted data.
      No activity results to display
      Show More
      Working...