Viewing 15 posts - 1,426 through 1,440 (of 3,221 total)
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...
February 19, 2011 at 4:17 pm
Post removed . misunderstood the question
February 19, 2011 at 1:18 pm
graham.hilton23 (2/19/2011)
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...
February 19, 2011 at 7:23 am
You might also want to read this blog posting:
Kimberly Tripp’s blog posting
http://sqlskills.com/BLOGS/KIMBERLY/category/SQL-Server-2005.aspx
February 18, 2011 at 8:34 am
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...
February 18, 2011 at 8:21 am
CirquedeSQLeil (2/17/2011)
TheSQLGuru (2/17/2011)
2) Duplicate indexes can...
February 17, 2011 at 9:49 am
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',...
February 16, 2011 at 12:18 pm
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...
February 16, 2011 at 9:31 am
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...
February 15, 2011 at 4:08 pm
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...
February 15, 2011 at 3:46 pm
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:
February 15, 2011 at 2:08 pm
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/
February 15, 2011 at 1:20 pm
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()...
February 15, 2011 at 10:31 am
also heard that Microsoft should stop the usage of SET QUOTED_IDENTIFIER OFF while creating any objects.
Regards,
Hardik Doshi
Out of curiosity in 2008 I checked for depreciated items with...
February 15, 2011 at 8:02 am
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...
February 14, 2011 at 2:52 pm
Viewing 15 posts - 1,426 through 1,440 (of 3,221 total)