How, through what program are the users connecting? SSMS / Web application or?

mike 97607

You might want to read these 2 articles, starting with Jeff Moden's

http://www.sqlservercentral.com/articles/T-SQL/68467/

and then going on to Lynn Pettis's article

http://www.sqlservercentral.com/articles/T-SQL/65522/

Both are excellent explanations and contain sample code. Combined, these...

This answer my question#2.

These 2 questions you have not answered

3. Are you...

If you elect to follow Steve's forume posting (above this one)

use this link to watch a video that shows you how to use the sp_Sp_MSforeachtable undoucumented procedure

Using SP_MSForEachDB and SP_MSForEachTable...

I would suggest you use Technet

http://technet.microsoft.com/en-us/default.aspx

and search for "sql server odbc connection" and then further refine the seach to "SQL 2005".

May I ask:

1. The purpose of gathering this information?

2. Is all...

I would strongly suggest you read this article by Jeff Moden and see if it is applicable to your situation

http://www.sqlservercentral.com/articles/T-SQL/63003/

Need a little more information in order to even start assisting you.

Is it a single dimension array or a multiple dimension array?

Also .. some sample data (Items) the array will...

Using Books On Line

Lool at the ISNULL function:

ISNULL ( check_expression , replacement_value )

check_expression

Is the expression to be checked for NULL. check_expression can be of any type.

replacement_value

Is the...

Suggest that you go to

http://technet.microsoft.com/en-us/default.aspx and in the search window input "SQL Server 2008 new features"

To add emphasis to Paul White's comment:

I have to say though, that this is usually a poor design idea - storing more than one attribute in a single column using...

Is this something even remotely like you need?

CREATE TABLE #bitwise

( a_int_value int NOT NULL,

Hours INT NOT NULL);

INSERT #bitwise --VALUES (1);

SELECT 1,8 UNION ALL --Prime shift

SELECT 2,6 UNION...

Done - RELAXING

Having said what I said in my post above and having some free time ... will this be what you want?

Note you have not defined what you consider the...

If you would provide the table definition ... some sample data, required results formatted as described in the first link in my signature block you will vastly increase your...