 |
|
EXEC [dbo].[sp_getItemCount] Ncsk, NMT,RM ส่งParameter เพื่อไป Where in |
|
 |
|
|
 |
 |
|
ใช้สร้าง Function ในการ Split ก่อนครับ
Code (SQL)
CREATE FUNCTION [dbo].[fn_Split]
(
@text nvarchar(max), @delimiter nvarchar(5) = ' '
)
RETURNS @Strings TABLE
(
position int IDENTITY PRIMARY KEY,
value nvarchar(max)
)
AS
BEGIN
DECLARE @index int
SET @index = -1
WHILE (LEN(@text) > 0)
BEGIN
SET @index = CHARINDEX(@delimiter , @text)
IF (@index = 0) AND (LEN(@text) > 0)
BEGIN
INSERT INTO @Strings VALUES (@text)
BREAK
END
IF (@index > 1)
BEGIN
INSERT INTO @Strings VALUES (LEFT(@text, @index - 1))
SET @text = RIGHT(@text, (LEN(@text) - @index))
END
ELSE
SET @text = RIGHT(@text, (LEN(@text) - @index))
END
RETURN
END
Stored Procedure (SQL)
select where field in dbo.fn_Split(Parameter);
|
 |
 |
 |
 |
Date :
2018-04-30 09:36:06 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|