Viewing 15 posts - 1,081 through 1,095 (of 1,183 total)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 9, 2007 at 1:51 pm
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
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 5, 2007 at 8:23 pm
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),
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 3, 2007 at 4:32 pm
I'm well aware that it's all me... LOL
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 28, 2006 at 8:57 pm
Yep, that will probably work better, now I'll go stand in the corner for a few minutes. *GRIN*
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 28, 2006 at 6:38 pm
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 +...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 28, 2006 at 6:21 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 21, 2006 at 8:45 pm
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
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2006 at 8:33 am
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]...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2006 at 8:20 am
the FROM clause must reference the "DELETED" table. This holds the info that is being changed/deleted.
Also, I'm not familiar with "udtId"
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2006 at 7:24 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2006 at 5:53 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 14, 2006 at 6:08 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 14, 2006 at 6:02 pm
Can you post what you have in the text box.value and what you have in the hyperlink value properties?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 14, 2006 at 5:43 am
Right click the text box and select "Properties". Select the "Navigation" Tab and select the "Jump to URL" option. Enter your Hyperlink there.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 13, 2006 at 4:42 pm
Viewing 15 posts - 1,081 through 1,095 (of 1,183 total)