Will this do what you need ?

SELECT CAST(DATEPART(mm, GETDATE()) AS VARCHAR(2)) + '/' +

CAST(DATEPART(dd, GETDATE()) AS VARCHAR(2)) + '/' +

...

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...

You might try:

declare @dob datetime,

@age int,

@day datetime

set @day = GETDATE()

set...

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...

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...

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...

Why thank you for the compliment. And when you try my next QOD...

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 ....

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/

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),...

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...

A nice, complex question, but a darn good one.

Kevin Drysdale (12/5/2011)

---

Pretty sure I checked thoroughly and it looks clean. The last column did contain data with commas, and the delimiter was a comma. I requested they send a...

Are you aware of SQL Server's Full...

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...