Viewing 15 posts - 1,006 through 1,020 (of 1,183 total)
OOPS, I had my namespaces reversed...but I'm sure you caught that.
______________________________________________________________________
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. SelburgApril 30, 2007 at 1:33 pm
Actually,
The only way to go back and forth is allow VS to do the upgrade to 2005, but to go backwards you'll need to edit the reports from 2005 to still use...
______________________________________________________________________
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. SelburgApril 30, 2007 at 1:02 pm
Judging from your other post, you may be better off following the directions in the other article. Make sure that you BACKUP the Encryption KEY as described in the article,...
______________________________________________________________________
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. SelburgApril 30, 2007 at 12:47 pm
RM,
Read through the info here http://support.microsoft.com/default.aspx?scid=kb;en-us;842425 This may not be exactly what you need, but it should get you going in the right direction.
Sorry, I can't be of more help.
______________________________________________________________________
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. SelburgApril 30, 2007 at 12:37 pm
CREATE PROCEDURE [dbo].[Distributor_Last7DaysSolds]
@DistributorID [int],
@StatusID [int]
AS
SELECT distinct dbo.BuyerItems.ItemID,dbo.BuyerItems.Quanity,dbo.BuyerItems.SoldDate ,DATENAME(dw ,soldDate) as Days, dbo.GetSoldCountInOneDay(dbo.BuyerItems.SoldDate) as TotalSolds
FROM dbo.BuyerItems INNER JOIN
dbo.Item ON dbo.BuyerItems.ItemID = dbo.Item.ItemID
where (dbo.Item.DistributorID=@DistributorID) and (dbo.BuyerItems.ItemStatusID=@StatusID)
and (datediff(dd,SoldDate,GetDate()) < 7)
______________________________________________________________________
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. SelburgApril 27, 2007 at 6:14 am
Francis,
Without having the DDL for the tables, I can only make a suggestion, but it seems that you would be better...
______________________________________________________________________
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. SelburgApril 25, 2007 at 5:09 pm
2000:
RTM: 8.00.743.00
SP1: 8.00.878.00
SP2: 8.00.1038.00
SP2 with KB901383 Hotfix: 8.00.1042.00
2005:
RTM: 9.00.1399.00
SP1 CTP:
______________________________________________________________________
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. SelburgApril 19, 2007 at 10:30 am
Can you post the queries in question, table definition and some sample data/results? This would help a lot in solving this.
______________________________________________________________________
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. SelburgApril 18, 2007 at 5:21 pm
I can't speak to a SQL 2000 solution,
but in 2005 you can use a CLR function. See http://msdn.microsoft.com/msdnmag/issues/07/02/SQLRegex/default.aspx for more info on that.
______________________________________________________________________
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. SelburgApril 18, 2007 at 4:50 pm
RM, it looks to me as if you are using a SQL 2005 Reporting services Database with SP2. Is this correct? Has the Database been updated/service packs applied? Were they...
______________________________________________________________________
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. SelburgApril 18, 2007 at 4:44 pm
Without more detail on your reordset, If your using SQL 2005 then look into the PIVOT function.
______________________________________________________________________
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. SelburgApril 13, 2007 at 5:21 pm
remove the .ToString (s)
______________________________________________________________________
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. SelburgApril 7, 2007 at 10:34 am
Peter,
I did notice that but was curious.
Thanks, and we're always learning.
Jason
______________________________________________________________________
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. SelburgApril 7, 2007 at 3:45 am
I had to account for loaned employees that were loaned for a date
(4/1/2007 00:00:00 to 4/2/1/2007 00:00:00) and have them not show in the list
BUT
(4/1/2007 00:00:00 to 4/1/2007 17:30:30)...
______________________________________________________________________
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. SelburgApril 6, 2007 at 10:34 pm
NO, I was saying that's how we all learn. TEST, then TEST, then TEST until we figure it out.
Your method worked fine.
______________________________________________________________________
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. SelburgApril 6, 2007 at 10:22 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,183 total)