I'm able to access all non sharepoint databases on the SQL 2005 server, so its something sharepoint related, I'm off to the sharepoint world, which is like trying to find...

yeah its all set, but I don't see an [answered] option to "close" it out

INSANE, I got it somewhat working but its returning me [ 0]'s, but its running and returning me something. thanks for your help.

ARG! !

now when I do that, and try to execute the sp, i just get this {Command(s) completed successfully.} and no data is returned.

This thing is driving me...

here is the create statement

CREATE PROCEDURE dbo.sp_GetSalesData

@CurrentYear nvarchar(4),

@PrevYear nvarchar(4),

@Month nvarchar(2),

@SalesMan varchar(max)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering...

yeah, I'll post it in a few. This thing is driving me nuts because I have another proc in another DB and the proc is setup the sameway and works,...

the variables are being passed from a .net web app, but when the proc is called it looks like this when i ran SQL Profile:

exec sp_GetSalesData @CurrentYear=N'2009',@PrevYear=N'2008',@Salesmonth=2, @SalesPerson='Smith'

this is the query I'm running: its the sameone from my first post.

Declare @sql nvarchar(MAX)

set @sql = ' SELECT x.SaleYear, ...

I'm gettiing the same error as I was when I posted.

this thing is driving me nuts, i've changed and tried everything you have recommended and I still get

{' is...

I can run it with the values hard coded just fine, so could it be the way the data is being passed to the proc, or could it be something...

I tried that and still get the same error message.

here is the query and the print statement when I run it:

query:

Declare @sql nvarchar(MAX)

set @sql = ' SELECT x.SaleYear, x.TotalSales

...

How would I do that?

The data is being passed as such

@Region = NE, SE, NW, SW, MA and so on

@State = 1,2,3,4,5,6,7,8,9,10. . . . .

how could I do it...

I figured it out, I had to fix my quotes around my parameter.

I have that working, I'm trying to get it to work within my query that is doing a pivot.

here is my pivot query:

SELECT *

FROM (

'SELECT tblCustomer.CusterName, tblCustomer.Date as TotalSales, tblMAIN.Region

FROM...