Like the majority of answers "It depends" I would suggest reading

1. http://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx

which discusses new features in SQL 2008. You can then select those features which directly...

Have you considered utilizing the T-SQL statement Execute AS ....?

From Books On Line

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/613b8271-7f7d-4378-b7a2-5a7698551dbd.htm

Sets the execution context...

Now now, having been born in 1932, I find longer...

This is a duplicate posting -- see

http://www.sqlservercentral.com/Forums/Topic748825-149-1.aspx

A payroll system (in the U.S.A.) would normally contain columns for an array of payroll deductions. For example

1. Number of dependents declared

2. Filing jointly or as...

I believe you might find the code, or something similiar enough to be adapted so that you can format the particular column as mumeric rather than text in this article.

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Try this and see if it works:

'In project references you MUST select

' Microsoft OLE DB Service Component 1.0 Type Library

' This in turn loads oledb32.dll into...

Is this what you are looking for:

SELECT XCUSNR,SDGAC,SUM(CAST(SDSVAL01 AS INT)) FROM supoff_gac_LY

GROUP BY XCUSNR,SDGAC

Which returns:

XCUSNR SDGAC Total...

douglascfast

Try executing this command:

SELECT ASCII(SUBSTRING(ColB,1,1))AS 'Character Code', DATALENGTH(ColB) AS 'Length' FROM #MyTable

The character code for a blank character is an integer 32. Note that what you are really...

shree dhavale

It would help those who will be attempting to help you if you provided the table structure, sample data and the T-SQL statement that you have attempted to utilize....

May I request someone to help this OP .. I do not have SQL 2000 on any machine that has Excel 2007 and having a devil of a time with...

If you have not yet discovered the reason for the reported error,

can you paste your connection string, and the exact error message and error number and I will attempt to...

Hope this might help.... Excel 2007 uses a different dll. I have used it in OPENROWSET to export data.. Can you search your export wizard for:

Microsoft.ACE.OLEDB.12.0

Also you...

Suggest you examine the T-SQL function DATEDIFF in Books On Line (BOL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5cb7105e-c68b-43c2-ab2d-80e525526e27.htm

Here is a very, very simple bit of T-SQL that will demonstrate the use of the function

DECLARE @StartDate as...

If you are using a stored procedure to input the data you could use:'INSERT INTO dbo.Patient(Patientid,fullname,flag)

VALUES(1002,'my full name is',UPPER('f'))

If using a stored procedure to extract the data and pass it...