AdvisorAdvisori have the following in it9
Declare @myStartlsn varbinary(10) = 0x00273BB30000AF040005 Declare @myEndlsn varbinary(10) = 0x00 Declare @LastChangeTime datetime = '01/01/2010' if (@myEndlsn = 0x00) Select @myEndlsn = Max(__$start_lsn), @LastChangeTime = Max(sys.fn_cdc_map_lsn_to_time(__$start_lsn)) from cdc.www_users_CT with (Nolock) where __$start_lsn > @myStartlsn If (DateDiff(minute,@LastChangeTime,Getdate()) > 30) --If no changes in the last 30 minutes pick up last trans select __$start_lsn as lsn, __$seqval as lsnSeqNum, Convert(Date,sys.fn_cdc_map_lsn_to_time(__$start_lsn)) as DateModified, sys.fn_cdc_map_lsn_to_time(__$start_lsn) as DateTimeModified, userid,email,password,fname,lname,ship_address1,ship_address2,ship_city,ship_state,ship_postal_code,ship_country,home_phone_cc,home_phone_num,office_phone_cc,office_phone_num,office_phone_ext,mobile_phone_cc,mobile_phone_num,email_critical_updates,email_keep_informed,email_digital_expert,user_hearabout_id,user_leadsource_id,us
when iam trying to capture the above i am getting only one line
