Viewing 15 posts - 811 through 825 (of 3,221 total)
Will this do what you need ?
SELECT CAST(DATEPART(mm, GETDATE()) AS VARCHAR(2)) + '/' +
CAST(DATEPART(dd, GETDATE()) AS VARCHAR(2)) + '/' +
...
December 8, 2011 at 9:54 pm
Steve - suprised at you for letting us off so easy at the end of the week - or was this a TGIF (Thank God Its Friday) to all of...
December 8, 2011 at 8:23 pm
You might try:
declare @dob datetime,
@age int,
@day datetime
set @day = GETDATE()
set...
December 8, 2011 at 7:59 pm
To help those who can help you please post table definition(s), sample data following the first link in my signature block, which article includes sample code to make the postings...
December 8, 2011 at 7:51 pm
Will this assist you?
CREATE TABLE #T(Name VARCHAR(10), Country VARCHAR(10),Date_Submitted DATE)
INSERT INTO #T
SELECT 'Mary','USA','Dec 20 2011'
SELECT 'Bill','USA','Mar 10 2010' UNION ALL
SELECT 'Bill','Canada','Feb 2 2009' UNION ALL
SELECT 'Mary','USA','Feb 20 2010'
;with numbered as(SELECT...
December 8, 2011 at 7:09 pm
For those objects within a single database ... check BOL (Books On Line) subject
SQL Server 2008 Books Online (July 2009)
sys.all_objects (Transact-SQL)
or on line at:
http://msdn.microsoft.com/en-us/library/ms178618.aspx
Then link...
December 8, 2011 at 6:08 pm
Revenant (12/6/2011)
bitbucket, you are thereby appointed an SQLServerCentral sneak in residence. 🙂Thanks for an interesting QotD!
Why thank you for the compliment. And when you try my next QOD...
December 6, 2011 at 10:30 pm
Another DB you must be concerned about is:
http://msdn.microsoft.com/en-us/library/ms190940.aspx
Now put the Model DB back in its original location ....
December 6, 2011 at 10:24 pm
When posting performance problems it helps those who want to help you if you follow the instructions in this article
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 6, 2011 at 1:48 pm
Do not know if this will truly assist you, it is long and cumbersome, but it might get started.
CREATE TABLE #T(field01 int, field02 VARCHAR(3), field03 VARCHAR(3), field04 VARCHAR(3)
, field05 VARCHAR(3),...
December 6, 2011 at 12:56 pm
In case Jeff Moden does not see your request, I believe this is the article he was referring to:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
The articles title is:
Tally OH! An Improved SQL 8K “CSV Splitter” Function
By...
December 6, 2011 at 7:24 am
Kevin Drysdale (12/5/2011)
December 5, 2011 at 3:18 pm
I searched the archives for this and could not find a solution.
I have a comment table and would like to get a word count.
Are you aware of SQL Server's Full...
December 4, 2011 at 8:00 am
Lynn Pettis
The occasional extra time is one thing, but constant is over the top. If you give us comp-time, give us time to use it, and also don't limit...
December 3, 2011 at 4:09 pm
Viewing 15 posts - 811 through 825 (of 3,221 total)