peterlyttle
Technical User
Hello,
Im pretty new to all this and would appreciate some help on this.
This returns the following -
I would like to add another column to the above query that does a count on each value returned in the name, eg Table1 has 2000 rows then the 2000 would be displayed alongside the priority etc.
Anyone any ideas?
Im pretty new to all this and would appreciate some help on this.
Code:
Select SMA.name,SMS.priority, SMA.pub_range, SMA.range, SMA.threshold
FROM [CFSP].[dbo].[MSmerge_identity_range] as MSIR
join [CFSP].[dbo].[sysmergesubscriptions] as SMS
on SMS.subid = MSIR.subid
join [CFSP].[dbo].[sysmergearticles] as SMA
on SMA.artid = MSIR.artid
This returns the following -
Code:
name priority pub_range range threshold
Table1 75 10000000 1000 80
Table1 75 10000000 1000 80
Table2 75 10000000 1000 80
Table2 75 10000000 1000 80
Table3 75 10000000 1000 80
Table3 75 10000000 1000 80
Table4 75 10000000 1000 80
Table4 75 10000000 1000 80
Table5 75 10000000 1000 80
Table5 75 10000000 1000 80
I would like to add another column to the above query that does a count on each value returned in the name, eg Table1 has 2000 rows then the 2000 would be displayed alongside the priority etc.
Anyone any ideas?