-- use your test database

USE Test

GO

-- create table1

CREATE TABLE table1 (

CustID INT IDENTITY,

Cname NVARCHAR(75) NOT NULL)

-- create table2

CREATE TABLE table2(

CTEID INT IDENTITY,

CustID NVARCHAR(9) NOT NULL)

GO

-- create trigger on table1

CREATE...

select

a.msisdn

,sum(b.amount) 'amount'

,b.[year]

,b.[quarter]

from

account a

inner join accrued_Trans b on

a.msisdn = b.msisdn

group by

a.acctGroup

,a.msisdn

,b.[year]

,b.[quarter]

order by

a.acctGroup

,[year]

,[quarter]

,a.msisdn

I went back and looked at the multivalue parameter again and I was able to paste into it via control+v (but still not with the mouse so the users will...

Thanks to each of you for your reply. I have actually gotten sidetracked on other issues and have not gotten to revisit this but I will consider the multivalue approach...

What I have done in the past is give each box a default of 'ALL' and UNION that with the query that loads the multivalue dropdown so it will appear...

Reducing the batch size did not work for me on this issue, however, by reapplying the snapshot to the subscriber I was able to get the log reader to function...

Thank you, that is very close. Unfortunately what I am trying to get to is a summary of customers and items from the Special_Orders table in relation to which trip...

Thank you Flo. But I think that while that may show me how many items were ordered on each date, it will not show me how many customers in the...

-- Although I used sequential CUSTOMER_ID's here

-- the unique identifier for each customer is LOCATION_ID + CUSTOMER_ID

-- There can be a CUSTOMER_ID of 1 at each location. ITEM is also...

Well I ended up just splitting the datetime field into two (date and time) and then formatting...that worked fine. Thanks to all!