[font="Courier New"]

use PIVOT

example:

DECLARE @tbl TABLE (Country VARCHAR(10), Sales MONEY)

INSERT INTO @tbl (Country, Sales)

SELECT 'UK', 250 UNION ALL

SELECT 'USA', 400 UNION ALL

SELECT 'INDIA', 500

SELECT * FROM @tbl

PIVOT (

SUM(Sales)

FOR Country IN...

ah! my mistake.

something like this?

select pri.name, per.permission_name from sys.database_permissions per

INNER JOIN sys.database_principals pri

ON per.grantee_principal_id = pri.principal_id

I tried with a file having the folllowing content.

"Jacob","jacob"s" File", "Other File"

I get this file processed correctly (Jacob, Jacob"s" File, Other File) with the following settings (SSIS Flat File Connection...

global temp tables will be visible to all sessions. You might need global temp tables only when multiple sessions need to insert/update/delete data from the same temp teble.

Try the following:

go to the properties of the 'sysadmin' login and make sure that it has permissions to access your new database. I guess it mightnot have permissions. grant permissions...

Rame..,

From your first post, I understand that you are trying to read data from an excel sheet. But i did not find code which actually connects to the excel document...

Personally, I prefer to pass all the data to the stored procedure at once..instead of calling a stored procedure for each record. This will give better performance as well as...

Happy new year!

One option is to put the results of the SP to a temp table and read the desired value from it.

example:

CREATE TABLE #tmp (Value NVARCHAR(200), Data NVARCHAR(500))

INSERT INTO #tmp EXECUTE...

What is the TSQL statement that you are trying to execute? It looks like you are trying to read data from an excel sheet. But you have not posted the...

Something like this?

;WITH family1 AS (

SELECT DISTINCT InvoiceID

FROM invoiceDetails

WHERE ItemCode LIKE 'PMM1%'

), family2 AS (

SELECT DISTINCT InvoiceID

FROM invoiceDetails

WHERE ItemCode LIKE 'PMM2%'

), family3 AS (

SELECT DISTINCT InvoiceID

FROM invoiceDetails

WHERE...

I would suggest that you get away from the...

Jeff Moden (12/25/2007)

---

I know a lot of people hate the idea but this is where I'd say "enough is enough" and drop the proc into the Master database and be...

I agree with chirag and jeff. Probably you can look at a few examples that use XML:

http://www.sqlservercentral.com/articles/Miscellaneous/2908/

http://www.sqlservercentral.com/articles/Miscellaneous/2909/

http://www.sqlservercentral.com/articles/Miscellaneous/2911/

http://www.sqlservercentral.com/articles/Stored+Procedures/2912/