Viewing 15 posts - 3,166 through 3,180 (of 3,221 total)
Thank you Antares686 I stand corrected. Fishing for some goodness from my post ... I am guessing that it got you to post yours and yours does work...
November 29, 2007 at 7:55 am
Far from being an expert, but good at culling the best or what I believe are the best features from the experts input.
How about this for a start - I...
November 28, 2007 at 11:40 am
Working for a government contractor I have come to believe that the abbreviations, acronyms, jargon is a mechanism for some to hide what they do. Least you the outsider...
November 20, 2007 at 6:49 am
Gotten from someone who is smarter than I am and generously posted this to SQL Server Central
Run sp_who2 to obtain the user's SPID value
Then run DBCC INPUTBUFFER(55) ...
November 19, 2007 at 7:39 am
If my memory does not fail me, way way back in the early 80's the "Red Roof Inns" corporate hdqrs had outside tennis courts, a sauna room, and an exercise...
November 19, 2007 at 7:04 am
Wonderful to see an individual with your proven qualifications in SQL, having a life outside of technology. It should prompt all of us techies to widen our outlook of...
November 15, 2007 at 9:32 am
Attempted to run a modified sql1 (SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=c:\temp\items.xls', 'Select * from [items$]')
)
SELECT * FROM items
Ran using SQL 2000 Query Analyzer with the following results:
Server: Msg 7399,...
November 14, 2007 at 2:42 pm
As one who has learned a great deal from this site, and thirsts for more knowledge, the sponsored discussions sound like just what is needed. From those, we just...
November 12, 2007 at 8:49 am
Rough and crude but seems to answer the question:
SELECT Count(Code)AS 'Count of Code entries',Code, Max(Pri)AS 'Max Pri', Min(pri) AS 'Min Pri',
Cast(Max(Pri) AS Int) - CAST(Min(Pri)AS Int)+ 1 AS 'Diff'
FROM Table1
GROUP...
October 30, 2007 at 2:12 pm
From BOL
The SELECT subquery in the INSERT statement can be used to add values into a table from one or more other tables or views. Using a SELECT subquery also...
October 30, 2007 at 1:29 pm
Using VB 6
In Project References include:
Microsoft OLE DB Service Component 1.0 Type Library
Input the following code in the form open sub
Dim Cnn_String as String
Set objMSDAC = New MSDASC.DataLinks
Cnn_String = objMSDAC.PromptNew
...
August 18, 2007 at 7:36 pm
Not wanting to be a kill joy, but it is obvious that Bill Gates is vocalizing wishful thinking .... or Microsoft hires and continues to employ not so great programmers...
April 20, 2007 at 12:34 pm
May or may not be helpful .. assuming that you are exporting the data to a new Excel Workbook ... have you gone into Excel and set the value for...
April 16, 2007 at 9:18 am
Viewing 15 posts - 3,166 through 3,180 (of 3,221 total)