WinTechPost

Monday, January 31, 2005

Visual Studio .Net 2003 Error: "Refreshing the project failed. Unable to retrieve folder information from the server."

Denis Bauer's ASP.NET Version Switcher

Index Tuning Wizard problem - "An error occurred trying to execute a SQL statement."

Index Tuning Wizard problem: " 'An error occurred trying to execute a SQL statement.'"

Thanks to your suggestion, I was able to identify the problem -
it seems the ITW has a problem working with tables that have
fields that have a single quote in them. Bug for MS to fix,
I guess.

A Day in the Life of a Software Developer: Portlet Development & Enterprise Portals

Thursday, January 27, 2005

Working with SQL Server 2000 Management Tools and Utilities

Here's how to get a comma separated output from Sql Server. Use -s

Working with SQL Server 2000 Management Tools and Utilities

How To Get Output Into SQL Server Table

How To Get Output Into SQL Server Table: "xp_cmdshell"

Venkman JavaScript Debugger - Development Page

Remove Margins from the Browser

Tuesday, January 25, 2005

dynamically resize iframe

http://www.geeklog.net/article.php/20030213110315177

Friday, January 21, 2005

Protest to the Ebay Fee Structure Increase - Signatures

Protest to the Ebay Fee Structure Increase - Signatures: "OnlineAuction.com "

FeeBay EBAY

US Airlines Outsource Maintenance to Central America

KYW Newsradio 1060 - News

Download details: Migrating from Windows NT Server 4.0 to Windows Server 2003

Internet Telephony Product Reviews: Avaya's IP Office WHAT A JOKE!!!

Internet Telephony Product Reviews: Avaya's IP Office

Give me a break! A features rating of 5? This Avaya IP Office is a piece of junk. Our old Merlin legend had more useful features than this thing. Our old Merlin worked, which is not true of IP Office.

A voice mail system with no broadcast messaging? What are these guys thinking?

Thursday, January 20, 2005

Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats

http://www.databasejournal.com/features/mssql/article.php/2197931

Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats: "PRINT '1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>' +
CONVERT(CHAR(19),GETDATE())
PRINT '2) HERE IS MM-DD-YY FORMAT ==>' +
CONVERT(CHAR(8),GETDATE(),10)
PRINT '3) HERE IS MM-DD-YYYY FORMAT ==>' +
CONVERT(CHAR(10),GETDATE(),110)
PRINT '4) HERE IS DD MON YYYY FORMAT ==>' +
CONVERT(CHAR(11),GETDATE(),106)
PRINT '5) HERE IS DD MON YY FORMAT ==>' +
CONVERT(CHAR(9),GETDATE(),6)
PRINT '6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>' +
CONVERT(CHAR(24),GETDATE(),113)

Here is the output from the above script:
1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>Feb 5 2003 5:54AM
2) HERE IS MM-DD-YY FORMAT ==>02-05-03
3) HERE IS MM-DD-YYYY FORMAT ==>02-05-2003
4) HERE IS DD MON YYYY FORMAT ==>05 Feb 2003
5) HERE IS DD MON YY FORMAT ==>05 Feb 03
6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>05 Feb 2003 05:54:39:567"

Searching date, time data in SQL Server 2000 :

Searching date, time data in SQL Server 2000 : Narayana Vyas Kondreddi's home page

Wednesday, January 19, 2005

Sql Reporting services "report item expressions can only refer"

When you get the message "report item expressions can only refer ...", make sure the variables you are referrering to are the right CASE.

The case must match the output case from the sql output. Even in VB!!!