You have an...

Having 4 billion ID's to choose from (-2147483648 to 2147483647), you can insert 10 records per second, every second around the clock, for the next 13.6 years.

Will INT not do?

IDENTITY(-2147483648, 1)

will give you 4 billion numbers to choose from.

SELECTCASE

WHEN Pos = '19000101' AND Neg = '19000101' THEN 0

WHEN Pos = '19000101' THEN Neg

WHEN Neg = '19000101' THEN Pos

WHEN Pos < Neg THEN Pos

ELSE Neg

END

FROM(

SELECTMAX(CASE WHEN Qty > 0...

I just clicked OP's "all post" to see if I didn't invent the wheel again.

If I hadn't, both you and me would present a working solution. What a waste of...

ALTER PROCEDURE dbo.uspMyProcedure

(

@Today DATETIME = NULL

)

AS

SET NOCOUNT ON

IF @Today IS NULL

SET@Today = DATEDIFF(DAY, '19000101', GETDATE())

ELSE

SET@Today = DATEDIFF(DAY, '19000101', @Today)

;WITH Yak (ProcessID, theDate, thePath, dc)

AS (

SELECTProcessID,

DATEADD(DAY, DayCount, @Today),

'/' + CAST(ProcessID AS...

I see that now.

I responded to a PM and saw that OP posted same question on the forums.

Didn't notice the version.

DECLARE@ProcessTest TABLE

(

ProcessID CHAR(3),

ProcessName VARCHAR(50),

FabricType CHAR(1),

ProductType INT,

ProductStyle CHAR(1),

StockType INT,

ProductLine CHAR(1),

DayCount INT,

OverlappedTo CHAR(3),

OverlapDayCount INT,

ProcessAfter CHAR(3)

)

INSERT@ProcessTest

SELECT'001', 'Process1', 'D', 1, 'T', 2, 'W', 12, NULL, NULL, NULL UNION ALL

SELECT'002', 'Process2', 'D', 1,...

Did you try my latest suggestion then?

I understand that, BUT WHICH MATCHING preference do you want?

ID = @ID AND pF = @pF AND ClassID = @ClassID

or this

ID = @ID OR pF = @pF OR ClassID =...

Which is it?

You can't have both.

Yes, because I don't know your business rules.

Please read my previous response carefully and to the very end.

Your DELETE #temp1 statements are dangerous.

If a record does not equal to #ID it still might equal #ClassID or sP column.

So you have two diffferents sets of business rules here.

1)...

karthikeyan (5/29/2008)

---

My questions are,

1) Whether my way of approach to split the comma seperated value is correct or not.

2) is there any other way to check the splitted values in...

You can with dynamic SQL. but the real question is WHY?