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.
April 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...
April 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,...
April 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.
April 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)
April 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...
April 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:
April 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.
April 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.
April 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...
April 18, 2007 at 4:44 pm
Without more detail on your reordset, If your using SQL 2005 then look into the PIVOT function.
April 13, 2007 at 5:21 pm
remove the .ToString (s)
April 7, 2007 at 10:34 am
Peter,
I did notice that but was curious.
Thanks, and we're always learning.
Jason
April 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)...
April 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.
April 6, 2007 at 10:22 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,183 total)