Question about Merge Agent

Does anyone know of a reasource that will describe exactly what happens during merge replication. I particular, I would like to know what is happening when the merge agent history says "Downloaded xxx data changes". Where is it downloading it to?
Downloaded refers to Publisher->Subscriber changes, while uploaded is the converse (information stored in dbo.MSmerge_history). To get further information on this and related topics, BOL is currently the best resource. Have a look at 'merge replication, o
verview' as a good page to navigate from.
HTH,
Paul Ibison
sql

Question about Joins

Hi,

I have a stored Procedure called rpt_FundLipperRatings and i want to display a image which is store in the Database which a particular fundid doesnt exist. Below is the stored procedure that exist, I tried putting a case statement like totalreturnScore = CASE When TotalReturnScore IS NULL then 0 else TotalreturnScore END, but it doesnt work if the the fund doesnt exist in the database. So can some one please tell me how can i do it. and is it possible to put a where statement in a inner join

Like

Select * from fund f

Inner Join LipperLeaderPix ll on f.TotalReturnScore = ll.score where Condition

inner join .....

ALTER

PROCEDURE [dbo].[rpt_FundLipperLeaderRatings]

@.FundId

int

AS

SELECT

NumberOfYears

,

TotalReturnScore,

ll1.OverallBW TotalReturnImage,

ConsistentReturnScore

ll2.OverallBW ConsistentReturnImage,

PreservationScore,

ll3.OverallBW PreservationImage,

ExpenseScore,

ll4.OverallBW ExpenseImage

FROM

FundLipperLeader f

INNERJOIN LipperLeaderPix ll1ON f.TotalReturnScore= ll1.ScoreINNERJOIN LipperLeaderPix ll2ON f.ConsistentReturnScore= ll2.ScoreINNERJOIN LipperLeaderPix ll3ON f.PreservationScore= ll3.ScoreINNERJOIN LipperLeaderPix ll4ON f.ExpenseScore= ll4.Score

WHERE

f

.FundId= @.FundId

There are a number of ways you could handle this but I would have to see sample data in your tables to understand it.

You can always try using a LEFT OUTER JOIN instead of INNER JOIN on the two tables if you still want to return records that have NULL on the joined field

|||

Rossoneri,

Thanks for your reply and sorry for replying late.

The Fund Lipper Leader has the following Columns - FundId,,Numberof Years(0,3,5,10), DataValidDate, TotalReturnScore, ConsistentreturnScore, PreservationScore, ExpenseScore, addDate, LastChangeDate

All the score have data ranging from 0 - 5 and each score has a different picture associated with it.

The LipperLeaderPix has Columns which store Binary data(or the pictures) the columns are Score(0,1,2,3,4,5) OverallColor, ConsistentReturnColor, ExpenseColor, PreservationColor, TaxEfficineyColor, TotalReturnColor and OverallBW.

So the score is been associated with each picture. Is this information helpful or do u need more.

Regards,

Karen

|||

Rossoneri,

I tried running it using Left Outer Join but it didnt tried doing some like for some other sproc but i had to write a union to get to handle the non existent funds, but couldnt do it for this sproc.

Regards,

Karen

question about charts

I have a pie chart which is been populated from a sproc.

and for a particular fund the values that generate are 78%,20% and 2% respectively.

And when it generates a chart the pie chart is uniformly displayed... Like for eg.. its been broken into 3 parts and there isnt a difference between the 78% and the 2% so ... How can i get the pie chart to be a displayed according to its values..

Any help will be appreciated..

Regards

Karen

So you are saying that each piece of the pie is showing as one third of the pie instead of being divided according to the percentage if you have three values in the pie chart?

Have you tried an exploded pie with 3D effects? Have you displayed the value for each piece of the pie on the chart?

Since it is a pie chart, it should naturally divide the pie according to the values in the chart.

If not, it would be like a bar graph with all of the bars at the same height when the values were in fact different.

|||

i have a exploded pie chart ... in design mode i can see the differences but not when i preview it..

Regards

KAren

|||

So when you preview it you can see the percentages over the pieces of the pie, but it looks as if it's not dividing it accordingly?

I'm making sure I understand the problem...

|||Maybe it's having a problem with the percentage itself. Is your field in itself a percentage? If so, I don't think it should be. The field itself should be a number (not a percentage) and the pie chart will divide the number by the total to get the percentage behind the scenes. You don't need to make it a percentage yourself.|||

greg,

The fields is varchar field in Sql server and i am not doing any thing special in the report..

78% part should be bigger than 2 % but 78% and 2% are the same size.

So how can i solve it

Regards

Karen

|||

i changed the datatype to decimal and it works fine.

Thanks

Regards,

Karen