I know the movie, Galaxy Quest....

KumarSQLDBA (9/14/2012)

---

I am trying to convert varchar data '27/04/2012'( dd/mm/yyyy) to date column as like below conversion

cast (Processing_Date as date).

But it giving error like 'Msg 241, Level...

ianderson 63159 (9/14/2012)

---

Thanks Lynn! In my first test, that is running great! Your suggestion seems to perform about the same for processing time but didn't experience the hiccups...

I...

Remembering that this discussion had occurred before, but not...

Professor Snape (sp?). ...

I had to give in. It hurt too much.

Hey, any comments on what is posted here?

Just curious.

ScottPletcher (9/14/2012)

---

Lynn Pettis (9/14/2012)

---

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN',...

I think I would go with something more like this:

INSERT INTO t15a_All

SELECT

t.*

FROM

t199815a t

inner join t15_All ta

...

Where do you think I have been getting my learning?

Be sure to read the discussion...

Glad I could help.

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN', N'IF', N'TF', N'FS',...

Actually, it's Jeff's (and the communities) function from his Tally Oh article. Hang on, I'll...

Would you please post the DDL (CREATE TABLE) statements and include the indexes defined.

How about this:

DECLARE @t TABLE (EMGID Varchar(7), Reference Varchar(8), Backscan Int);

INSERT INTO @t

SELECT '1267202', '32655185', 1

UNION ALL SELECT '1267202', '32655185', 0

UNION ALL SELECT '1239667', '33264522', 1

UNION ALL SELECT '1239667', '33264522',...