Well, actually the server we have was both the SQL and the Web server. I would think it is the Web Server though, since it's the webserver/aspx files generating the...

I haven't tested this, but it seems your problem resides in the fact that you're using variables in the statement.

This should work

--======================= SYNONYM TEST =====================--

DECLARE

...

WITH ProductSales(ProductID, OrderYear, OrderTotal)

AS (

SELECT

det.productID,

YEAR(hdr.orderdate),

det.linetotal

FROM sales.salesorderdetail det

JOIN sales.salesorderheader hdr

ON det.salesorderid = hdr.salesorderid

)

SELECT

ProductSalesPivot.productID,

Total_Sales_2001 = ISNULL([2001], 0),

Total_Sales_2002 = ISNULL([2002], 0),

...

I'm well aware that it's all me... LOL

Yep, that will probably work better, now I'll go stand in the corner for a few minutes. *GRIN*

DECLARE

@strSQL nvarchar(1000)

,@dataSource varchar(100)

SET @dataSource = 'SomeDB'

SELECT @strSQL = 'SELECT s.ShowID, sd.ContactName, sd.ContactEmail, @dataSource

FROM show s

INNER JOIN [' + @dataSource +...

Heads Up!

A new and greatly improved procedure/article is coming up (within a few days). I have found that this procedure also works with RS 2005 and the error-trapping has been...

This is why you use the DELETED in your from clause.

SELECT

[FeeStudentId] ,[FeeId] ,[StudentId] ,

[FeeDate] ,[FeeAmount] ,[TotalPaid] ,

[FeeStatusId] ,[DateModified] ,[UserId] ,

[SessionId] 

FROM

DELETED

this will only give you what is being changed/removed

1. You don't need..."set Identity_INSERT tblFeeDelete ON"

2. Change your insert to the following.

Insert tblFeeDelete

([FeeStudentId] ,

[FeeId] ,

[StudentId] ,

[FeeDate] ,

[FeeAmount] ,

[TotalPaid] ,

[FeeStatusId] ,

[DateModified] ,

[UserId] ,

[SessionId] )

select

[FeeStudentId] ,

[FeeId] ,

[StudentId] ,

[FeeDate] ,

[FeeAmount] ,

[TotalPaid] ,

[FeeStatusId]...

the FROM clause must reference the "DELETED" table. This holds the info that is being changed/deleted.

Also, I'm not familiar with "udtId"

One way to accomplish this is to include the function that occurs on this page "http://10.110.2.10/pricing/rqst/p?function=getinvno" in the procedure that gives you the data for your page when a parameter...

This is just a quick post, but...

1. create a table to hold the deleted values, something like ...

CREATE TABLE dbo.deletedValues

(deletedKey identity int (1, 1)

,feeStudentId int

,feeid int

,StudentId int

,FeeDate datetime

,FeeAmount money

,TotalPaid...

So the value you get from the dataset is ...

"http://10.110.2.10/pricing/rqst/p?function=getinvno,CS1897"

I'm a little confused. If the value you get from the dataset is the url and the invoice number but you...

Can you post what you have in the text box.value and what you have in the hyperlink value properties?

Right click the text box and select "Properties". Select the "Navigation" Tab and select the "Jump to URL" option. Enter your Hyperlink there.