derek.colley (9/6/2012)

---

Point taken, it's a join, not processed row-by-row, so not subject to overhead of 'decoding' the date functions then comparing, then doing over again in a loop. So...

I'm not much of a dev guru so can't test this from an external application call, but I reckon it would be possible to fool a call to the SP...

Actually the functions in your where clause should not render nonSARGable as Derek suggested because it is not a row based call.

It is pretty hard to tell why the...

derek.colley (9/6/2012)

---

Good point. You'd merely get the string inserted...

derek.colley (9/6/2012)

---

Surely there's an argument here that string validation (to take one example) should be handled app-side anyway, so that your table only ever receives clean data?

If not,...

ScottPletcher (9/5/2012)

---

But the trigger DOES the clean up, which guarantees that (1) it occurs...

ariel_mlk (9/5/2012)

---

Sean,

Thanks for the input ! i'll get that done by tomorrow and come back to buzz you guys again =)

hopefully i'll improve the procedure more than i expect it...

ScottPletcher (9/5/2012)

---

Sean Lange (9/5/2012)

---

You certainly have a valid point. Not sure that adding an insert/update trigger on every...

ariel_mlk (9/5/2012)

---

Sean,

No offense taken at all ! right now the procedure that i copied here is the only one that uses it, i just did some copy paste of existing...

L' Eomot Inversé (9/5/2012)

---

Lynn Pettis (9/5/2012)

---

Brandie Tarvin (9/5/2012)

---

Lynn Pettis (9/5/2012)

---

Brandie Tarvin (9/5/2012)

---

Have...

You certainly have a valid point. Not sure that adding an insert/update trigger on every table is the...

ariel_mlk (9/5/2012)

---

ALTER FUNCTION [dbo].[SplitString]

(

@String VARCHAR(MAX),

@Delimeter Char(1)

)

RETURNS @RtnValue TABLE

(

Value VARCHAR(100)

)

AS

BEGIN

DECLARE @Cnt INT

SET @Cnt = 1

WHILE (CHARINDEX(@Delimeter, @String) > 0)

BEGIN

INSERT INTO @RtnValue (Value)

SELECT

Data = ltrim(rtrim(Substring(@String,1,Charindex(@Delimeter,@String)-1)))...

ariel_mlk (9/5/2012)

---

Sean,

Sorry to not have posted that back in the first post, as i stated I though I was missing something obvious enough to discard ddl, i editted it...

It all comes down to want you want to do. You discussed a few things but never really said what you want to do. The best thing you can do...

RBarryYoung (9/5/2012)

---

Hmm, I just noticed what this is trying to do (thanks, Lowell!).

Why on earth would you even want to do this? If a #temp still exists, it's because...