Viewing 15 posts - 53,161 through 53,175 (of 59,064 total)
Michael Valentine Jones (1/2/2008)
January 2, 2008 at 8:24 pm
Kenneth Fisher (1/2/2008)
Jeff Moden (12/28/2007)
This should do it, Mike...SELECT *
FROM yourtable
WHERE ISDATE(LEFT(yourcolumn,4))=1
AND yourcolumn LIKE '[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]'
Jeff,
Would this have been faster
SELECT *
FROM yourtable
WHERE yourcolumn LIKE '[12][089][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]'
AND ISDATE(LEFT(yourcolumn,4))=1
i.e. Restrict the 1st...
January 2, 2008 at 8:17 pm
Mike Levan (1/2/2008)
thanks jeff.How can i enter time in tenths of an hour or has to check if the time entered is in tenths of an hour
Instead of adding "1"...
January 2, 2008 at 7:44 pm
Heh... well done, Kenneth... that's one of my favorites, as well. The only time you really need a "split", is if you have to insert the rows into another...
January 2, 2008 at 7:22 pm
Ian Yates (1/2/2008)
January 2, 2008 at 6:59 pm
Eric Stimpson (1/2/2008)
January 2, 2008 at 6:54 pm
Eric Stimpson (1/2/2008)
My message would be to challenge any use of distinct...
January 2, 2008 at 6:47 pm
AlexT (1/2/2008)
Nice article.Just another way to do this in sql 2005
with h(SomeID) as (SELECT DISTINCT SomeID from dbo.TestData )
select h.SomeID, dbo.fnConcatTest(h.SomeID) from h
Cool... another bullet for the gunbelt....
January 2, 2008 at 6:04 pm
JJ B (1/2/2008)
January 2, 2008 at 6:02 pm
Michael Skinner (1/2/2008)
What drives me insane about issues like this one (and I have had to create comma delimited files far too often through SQL) is that...
January 2, 2008 at 5:49 pm
sushila (1/2/2008)
What an absolutely well-written and informative article - I totally agree with the earlier post that remarked on this being a great way to start the new year. I...
January 2, 2008 at 5:45 pm
Heh... thanks for the feedback, Donald. I'm right there with ya on the 10 tries. 😀
Like Colin was kind enough to point out, if folks think they can...
January 2, 2008 at 7:48 am
As long as database owner is a sysadmin all objects created by database owner will automatically be owned by dbo.
Now, there's a decent tip... 🙂
January 2, 2008 at 7:20 am
Viewing 15 posts - 53,161 through 53,175 (of 59,064 total)