Please check the latest MDAC installed in your machine if exists, then better install SQL Server client tools once again.

Try the following way:

INSERT

INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\DOWNLOADS\testing.xls;',

'SELECT Name, ID FROM [Sheet1$]'

)

SELECT top 10 [Name], Id FROM dbo.sysobjects with (nolock)

GO

For More Information navigate to URL: http://www.mssqltips.com/tip.asp?tip=1202

create one sp...

use inner join to get exact result.

Use Microsoft SQL Server Database Publishing Wizard, this tool may solve your problem.

Check the URL: http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

User DTS, to transfer the .txt file data into SQL Server.

SSMS -> SQL Server Management Studio

get the column name from this INFORMATION_SCHEMA.COLUMNS

Use Import & Export wizard you can transfer the NWind.mdb data into SQL Server.

Use shared datasource for all reports. For better organizing.

use sp_who2 and dbcc commands, to know the issue.

Code is working fine. No need for go global temp. table.

Very useful artical.

use the following way:

selectcaseIndex_Code

when'Default'then'Default123'

when'Int'then'International'

when'Bnk'then'BankDep'

when'Inv'then'Investment'

elseIndex_Code

end

fromTableTest

use sp_addlinkedserver command, for more information, see SQL BOL

Another approach, use the following:

createprocedure

(

@packageNamevarchar (100)

)

as

begin

Select ToEmailID

FROM dbo.Table1

WHERE PackageName = @packageName

end

go

exec @packageName= 'package1'

go