Will this help

Declare @date Char(10)

set @date = convert(char(10),'2010-09-02 14:56:09.840',101)

PRINT @date

Using GETDATE()

Declare @date Char(10)

set @date = convert(char(10),GETDATE(),101)

SELECT @date

Result will be 09/02/2010 in either case, or can convert to VARCHAR and...

By some strange coincidence as I was reaing this forum, my door bell rang and there was the FedX truck with a package from CDW with my order which was...

Question .. when executing your stored procedure ... using SSMS ... select ... "Show execution plan". Clear CACHE between executions.

Examine and compae the plans. This will assist you...

After following the suggestion by PaulB-TheOneAndOnly

You can use a CTE something like:

;with numbered as(SELECT rowno=row_number() over

...

Here is an example, (Which I copied, more than likely from a posting by Jeff Moden on SSC)

SELECT *

INTO #TestData

FROM (SELECT 'malli','o2o2020' ...

Nice to be reminded of the basics - hence a good question

espanolanthony

Is the statistic you are attempting to drop the statistic maintained on an Index, that appears to be the problem ?

The DROP STATISTICS command is used to drop statistics,...

Jayraj.Todkar

Thanks for your compliment ... glad to be of assistance.

I took the liberty of attempting to convert your table definition and actual results and post those per instructions contained in the first link in my signature block. That...

These links may help you.

http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-More-on-the-circular-nature-of-the-log.aspx

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

To begin to obtain an understanding of log files may I suggest you read this excellent article by Gail Shaw

http://www.sqlservercentral.com/articles/64582/

Then progress to these:

http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-More-on-the-circular-nature-of-the-log.aspx

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

Using Books On Line - "sys.sql_expression_dependencies (Transact-SQL) "

Here is a sample T-SQL statement that will return the "Referenced Schema Name" and "Referended entity name" (table name)

USE AdventureWorks2008;

GO

SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name,...

Luke L (8/18/2010)

---

Jeff, one of the best parts of your articles are the clear concise, well formatted/documented real world code examples that can be easily understood and implemented. There's...

Review the effect of your "SELECT INTO"

From BOL:

Note that your last posting of the T-SQL that works:

The SELECT INTO statement creates a new table and populates it with the result...

gspeedtech

To assist you in understanding the problem (Or at least I hope this help)

Execute this command

SET SHOWPLAN_ALL ON

GO

1. Execute your query

2. Examine the execution plan....