This might not be that fast, but there is no need for clustered index

--Prepare sample data

DECLARE@Sample TABLE

(

Widget TINYINT,

DT SMALLDATETIME

)

INSERT@Sample

SELECT1, 'Jan 16 2008 12:29AM' UNION ALL

SELECT1, 'Jan 17 2008 12:02AM'...

You can't have dynamic SQL in a function.

http://www.sommarskog.se/dynamic_sql.html

Drop the hyphens.

WHERE SomeCol >= '20080225' AND SomeCol < '20080226'

to get all records dated february 25, 2008.

Just in case there are more than piece of information of same type.

I suspect we haven't been told the full picture.

DECLARE@Sample TABLE (Data VARCHAR(100))

INSERT@Sample

SELECT'str001dt020208reg005trn0001'

SELECTs.Data,

t.*

FROM@Sample AS s

CROSS APPLY(

SELECTSUBSTRING(Data, 1, 6) AS Store,

SUBSTRING(Data, 7, 8) AS Date,

SUBSTRING(Data, 15, 6) AS RegisterNum,

SUBSTRING(Data, 21, 7) AS TransactionNum

) AS t

Begin with posting the connection string here.

Maybe there is something unusual in there?

This?

http://www.sqlservercentral.com/articles/Visual+Basic+6/trythesqlparserobjecttocolorizeyoursql!/422/

If the text file already exists, OPENROWSET.

Or you could give DTS a try.

This is off-topic but does anyone have time to test the use of CROSS APPLY for SQL Server 2005?

-- 2000

SELECTy.DocNo,

t.Number

FROM(

SELECTDocNo,

COUNT(*) AS N

FROM@YourTable

GROUP BYDocNo

) AS y

INNER JOINMaster.dbo.spt_Values AS t ON t.Type...

Msg 208, Level 16, State 1, Line 1

Invalid object name 'New.AddAnnex'.

UPDATEts

SETts.Current_Status = '1'

FROMTransaction_Status AS ts

WHEREts.Current_Status = '0'

AND EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'ADDANNEX' AND TABLE_SCHEMA = 'NEW')

Add APPLICATIONNAME column to your profiler.

Then you will know which application is running every 5 seconds.

Already asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97349

You can't do this in SQL Server 2000. It is with SQL Server 2005 you can use CROSS APPLY.

SELECT DISTINCT DATENAME(MONTH, SeqDate)

FROM dbo.fnSeqDates('20070901', '20080201')

http://www.sqlservercentral.com/articles/Advanced+Querying/howmanymoremondaysuntiliretire/2475/%5B/url%5D