Lynn Pettis (8/3/2010)

---

dant12 (8/3/2010)

---

Jeff Moden (8/3/2010)

---

dant12 (8/2/2010)

---

yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me...

Jeff Moden (8/3/2010)

---

dant12 (8/2/2010)

---

yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me lots of ideas...

yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me lots of ideas with both ur...

dunno whats wrong with your function but it performed way slower than the old one

DECLARE @A DATETIME = GETDATE() -- CLR

SELECT DBO.UF_TRATASTRING(NOME_DEV) FROM TB_DEVEDOR

SELECT DATEDIFF(MS,@A,GETDATE())

GO

DECLARE @A DATETIME = GETDATE() --...

Jeff Moden (8/1/2010)

---

dant12 (7/31/2010)

---

wow Jeff, thats a nice load of replaces lol. ill test it first thing on monday and post the results against the old T-SQL and the CLR...

wow Jeff, thats a nice load of replaces lol. ill test it first thing on monday and post the results against the old T-SQL and the CLR functions. Thanks for...

alright, here it goes.

T-SQL code (var names and common words are in portuguese)

CREATE FUNCTION [dbo].[UF_TRATASTRING]

(

@PALAVRA NVARCHAR(3000)

)

RETURNS...

i agree with ken. we have a similar requirement and we use this inside our proc

put this in the beginning of the proc

DECLARE @PROC VARCHAR(20)

DECLARE @SUCESS AS INT

SET @PROC =...

Ok, ill explain further

We have a stored procedure that gathers information on incosistencies from the ETL process on a #temp table and exports a csv file via BCP

each of the...

I mean a third-party application creating a new thread using the same sql server SPID

as far as I know you can't "SELECT * INTO TABLE" into an already created table, so I don't think the problem is the target table definition as it doesn't...

Thanks alot Peter, thats exactly what I was looking for.

I tried achieving this with CROSS JOINS but got very very far away from expected results

there are 10 parameters now, this can change but not much, should be around 6-12 tops.

I used 8, this could be 6-9 but I prefer to do it with a...

that is what i was thinking, but they must have changed it from 2005 to 2008 and im pissed that microsoft doesnt even mention it anywhere

yes, but REPLACE should convert it to nvarchar data-type and get rid of the extra spaces, right?