- take this to be a sort of select...

I would ask for comments (solicit) from those on the thread on the following suggestion for increasing the reception and improvement of the Question Of the Day (QOD).

http://www.sqlservercentral.com/Forums/Topic887478-4-1.aspx

It...

From previous posting in this forum

Local temporary tables are deleted after the user disconnects from the instance of SQL Server. Global temporary...

Start reading here:

http://msdn.microsoft.com/en-us/library/ms186986.aspx

There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of SQL...

Tom.Thomson Posted Today @ 7:47 PM

The ability to fix..with the click of a button: shouldn't that be qualified with "sometimes"? Without the qualification, does it mean "always"...

This code works in SQL 2000

SELECT 'Index Name' = i.name, OBJECT_NAME(i.id) AS 'Table Name',

Case Indid

WHEN 1 THEN 'Clustered'

...

Following GSquared's advice, and by some good fortune a major article in today's SSC (3/19/2010) Read this article and see if it helps.

http://www.databasejournal.com/features/mssql/article.php/3864246/SSIS-Packages---the-Simplest-Way-to-Create-Them.htm

Not let me...

Attach your jpg file ... scroll to bottom of this window, in the "Post Options" frame. click on the button labeled "Edit Attachments" browse to whatever drive on your...

By an "array", do you mean a list of items or a true multidimensional array?

GRE (Gethyn Ellis)

Again many thanks .... now I have learned more and I hope the person asking the original question has also learned something new.

You assistance in testing is...

GRE (Gethyn Ellis)

Thanks for the feed back. Edited my posting to add 2 additional scripts would you be so kind as to give them a test.

Again I thank...

Refer to:

Index Related Dynamic Management Views and Functions (Transact-SQL)

at:

http://technet.microsoft.com/en-us/library/ms187974.aspx

This code works in 2005, but I have not tested in 2008 ... give it a try if it does you have...

monzulu

--To make you data available for testing

CREATE TABLE #T(OrderDate DATETIME, Quantity INT )

INSERT INTO #T

SELECT '1/1/2009', 1 UNION ALL

SELECT '2/1/2009', 3 UNION ALL

SELECT '5/1/2009', 7 UNION ALL

SELECT '9/1/2009',...

Lynn Pettis (3/15/2010)

Grant Fritchey (3/15/2010)

Lynn Pettis (3/15/2010)

Grant Fritchey (3/15/2010)

GSquared (3/15/2010)

What year? (My birthday was yesterday, so I'm curious as to...

To alter a date so you have no time elements this will work

declare @date Char(10)

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

To keep it as DATETIME with zero time values use this:

@midnight DATETIME

SELECT @midnight...