Using the data type TIME(4) test this code to determine if it is what you need.

/*Using your input format think the following will work

to reformat the text field to...

Post removed . misunderstood the question

graham.hilton23 (2/19/2011)

---

Hi

Did you find a solution to this? All the examples I have seen are taken the system time where as all I need to do is input an event...

You might also want to read this blog posting:

Kimberly Tripp’s blog posting

http://sqlskills.com/BLOGS/KIMBERLY/category/SQL-Server-2005.aspx

eoghanmaths

To help those who wish to help you, please, please post the table definition, some sample data and required results, following the samples and methods given by the article...

CirquedeSQLeil (2/17/2011)

---

TheSQLGuru (2/17/2011)

---

1) That's an interesting script for dupe index checking Jason. Haven't seen one like that before. I need to give it a try.

2) Duplicate indexes can...

Try this

CREATE TABLE #T(B INT,network VARCHAR(20),DateLoaded DATETIME)

INSERT INTO #T

SELECT 11, 'c net', '2011-01-01' UNION ALL

SELECT 12, 'c net', '2011-01-01' UNION ALL

SELECT 12, 'c net', '2011-02-01' UNION ALL

SELECT 13, 'e net',...

nevrstp

If you would post the table definitions, some sample data and desired results, using the procedures and sample code, contained in the first link of my signature block I...

nadarajan_v

You more than likely will get a tested T-SQL block of code if you posted your table definitions, some sample data following the instructions and using the T-SQL given in...

snoop123

Did you read the articles by Gale Shaw other wise known as GilaMonster?

If you have, try using this snippet of code to get a better idea of what indexes...

The best I can advise is to begin reading Gail Shaw's series of articles on Indexing the first one of which is at:

http://www.sqlservercentral.com/articles/Indexing/68439/

Then read

http://www.sqlservercentral.com/articles/Indexing/68563/

Go on to part 3 at:

http://www.sqlservercentral.com/articles/Indexing/68636/

Before making your decision you might want to read these 2 articles on SSC.

http://www.sqlservercentral.com/articles/SQL+Server+2008/64601/

http://www.sqlservercentral.com/articles/Spatial+Data/64734/

I have taken the liberty of adding an entry to your table:

SELECT 10, N'USER1', N'L', '20110201 08:00:00.000' UNION ALL

with that entry I then executed the following:

;with numbered as (Select rowno=row_number()...

Out of curiosity in 2008 I checked for depreciated items with...

In answer to your question .. Yes there is ... here is an example posted the other day here on SSC at:

http://www.sqlservercentral.com/Forums/Topic1062357-338-1.aspx#bm1063021

by the user with the name of: mister.magoo

CREATE FUNCTION...