Viewing 13 posts - 1 through 13 (of 13 total)
Hi Paul
Good advice from metawizard2. Using a "properjob" development environment is always going to be more scaleable and easier to debug, but there is a much steeper learnig curve!
I suspect...
June 2, 2008 at 3:23 am
Hi LittleSquall
Sorry for the delay.
[font="Courier New"]dim objConn, strConn, objRst, strSQL, strText
strConn="PROVIDER=SQLOLEDB;DATA SOURCE=SQL_SERVER_NAME;UID=USER_ID;PWD=PASSWORD;DATABASE=Northwind "
strSQL="SELECT CategoryID, CategoryName FROM Categories"
strText=""
If Not IsObject(objConn) Then
set objConn = createobject("ADODB.Connection")
objConn.open strConn
End If
If Not IsObject(objRst) then
...
November 30, 2007 at 2:12 am
Fair point Jeff!
So really it would depend on how many rows are returned?
I'm guessing the threshold would be around 200?
Mind you, if it's 150 columns and 200 rows that's one...
November 28, 2007 at 1:28 am
Hi
I thought I'd put my pennysworth in.
No-one has suggested writing a VBS file using ADO to loop through the recordset writing to a file at each iteration. This could be...
November 27, 2007 at 1:43 am
A well constructed article, but can someone explain to me why American database professionals continue to use the ambiguous and confusing mm/dd/yy date format? I can understand them using it...
August 15, 2007 at 1:28 am
Sorry, you wanted size aswell:
SELECT SERVER_NAME,
substring(max(right('00' + cast(DBSIZE as nvarchar(4)), 4) + DATABASE_NAME), 5, 3) DATABASE_NAME,
cast(max(right('00' + cast(DBSIZE as nvarchar(4)), 4)) as int)
FROM #TEST
GROUP BY SERVER_NAME
August 8, 2007 at 2:44 am
Using Lowell's temporary table (thankyou Lowell):
SELECT SERVER_NAME, substring(max(right('00' + cast(DBSIZE as nvarchar(4)), 4) + DATABASE_NAME), 5, 3)
FROM #TEST
GROUP BY SERVER_NAME
will work very efficiently.
You can't directly...
August 8, 2007 at 2:36 am
April 10, 2007 at 4:00 am
You are correct - I am using a backup device.
How do I check which members there are?
March 29, 2007 at 10:00 am
If you absolutely MUST have your date stored in YYYYMMDD format, then why not create another column in the table that simultaneously records the same date in the more traditional...
January 5, 2007 at 6:12 am
Thankyou all for replying, even Aaron who inadvertently missed the forum subject title!
Lynn...your solution was the one I first tried. However it doesn't guarantee to always bring back a max...
December 1, 2006 at 2:48 am
Thankyou for raising this very important topc.
Of most use to me would be an article that concentrates on how to convince the HR department that they must make the investment.
Most...
July 12, 2006 at 9:33 am
Sorry to be boring guys - but have we not strayed just a tad from the original question?
I'd like to know if we can assume that the initial state of...
May 12, 2006 at 1:49 am
Viewing 13 posts - 1 through 13 (of 13 total)