soniccrackerjack
Last Activity: May 1 '07, 07:48 PM
Joined: Mar 27 '07
Location:
-
Excel Query to SQL Server and data type manipulation on SELECT
I need to query my SQL Server 2000 database from within MS Excel 2003. One of the table columns is a date-time stamp in milliseconds (NUMERIC) and I want my query to return a human-readable date value (VARCHAR or NVARCHAR) on the SELECT statement. Is this possible without using either a View and/or a Stored Procedure? How?Last edited by soniccrackerjack; Mar 27 '07, 02:40 PM. Reason: Title didn't accurately reflect the problem
No activity results to display