to quote from a previous post:

...there are situations...

Trust me,they have. 😉

Would it be possible for you to provide two files and the final table structure ( = expected result)?

If...

Cross-posting. I'm sorry.

But I just checked over at beyondrelational. The challenge is over. Winners are announced. All codes are available.

In general, I don't consider it as a good idea to...

It looks like you're dealing with exactly the same scenario as described in one of the

T-SQL challenges over at beyondrelational.

You might want to have a look at the solutions...

I'm sorry if it comes across brutal. It was...

Roy, what's that magic "twitter handle" stuff about?

I sometimes have a hard time following Dave, especially if he...

kevin4u06 (1/4/2011)

---

Hi Lutz,

I created a function by slightly modifying your query

CREATE FUNCTION [dbo].[udf_TEST_EMAIL] (@String VARCHAR(MAX))

RETURNS @Email TABLE (Email VARCHAR(MAX))

AS

BEGIN

DECLARE @E_mailID VARCHAR(MAX), @delimiter CHAR(1), @sub varchar(max)

SET @delimiter ='@'

WHILE...

First of all: EXCELLENT way to provide sample data!! VERY GOOD JOB!!

Now to your questions:

1. Need to display CheckList Name instead of ID

2. want to display 'Sunday' in output column...

hoanglong88i (1/3/2011)

---

In my view, the perfect answer here is based on most requests that want to know all the missing codes. Like Harin's solution or this article:

http://www.sqlservercentral.com/articles/SQL+Puzzles/findinggapsinasequentialnumbersequence/2336/

But Lutz, your solution...

I'm not sure if SSIS is the right tool for it...

Why not load and process the file using T-SQL? It's kinda old-fashioned, but I'm confident much less painful than trying...

kurniawan.kumala (1/3/2011)

---

hi dave,

would you answer this question , please......

when i try to create Index [kur_items] at temp_stok (i use sql server 2005)

-------------------------------------------

CREATE NONCLUSTERED INDEX [kur_items]

ON [dbo].[temp_Stok]

...

Then we'd need the split string, I guess.

I'd probably use the method stated above...

The key information in your reply is NHibernate and most probably a misuse of it.

Check your app while a trace is running and check the values needed for functionality vs....

Something like this?

DECLARE @string VARCHAR(MAX)

SET @string = '...the email ids abs@yahoo.co.uk and also cds@gmail.com are my mails ids...'

DECLARE @sub VARCHAR(MAX)

SELECT @sub = LEFT(@string,CHARINDEX(' ',@string,CHARINDEX('@',@string,1))-1)

SELECT RIGHT(@sub,LEN(@sub)-CHARINDEX(' ',REVERSE(@sub))-1)

I think this method...