Thanks Hugo!

So, if I understand using N in front of the single quotes like N' ' is recommended as oppose to just the single quotes with out...

Thanks John and Ed!

I just ran the below query with out the N in the country + ' ' + coalesce(region, N' ') + ' '+ city as...

Hi Jeff,

Your point is correct. But I have a different scenario, our accounting team having some issues - checks were not properly reconcilied with some earlier date and...

Hi SSCoach,

Thanks for the quick reply. Please see below.

For BankAccountTrans

/****** Object: Table [dbo].[BANKACCOUNTTRANS] Script Date: 2/16/2014 9:47:05 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE...

Hi Jeff,

Thank you for taking time to help me with some basic stuff. I do need to get my head around with more T-SQL coding. We...

Hi Jeff,

Thank you for your reply. I am not that expert in t-sql and more of a front-end guy. Can you please help me modify my...