Hi All,
So I decided to make some changes to the flex header as we don't use certain data from the default fields. One piece of data that would be really useful to have is what a constituent's primary web login is. I have tried a few different lines but I have limited knowledge of SQL, so I just keep getting errors!
Any help on this would be really appreciated
Many thanks,
Matthew
Hi Matthew.
Something like this should work:
SELECT TOP 1 tcl.login FROM T_CUST_LOGIN AS tcl WITH (NOLOCK) WHERE tcl.customer_no = @customer_no AND primary_ind = 'Y'
Amazing Steve, Thank you for this! I really appreciate it
You're welcome