Hi Jeff,

Thank you very much for the help I really appreciated though I need to study the code for understanding.

Regards,

Clint

Hi Jeff,

Thank you very much for the help I really appreciated though I need to study the code for understanding.

Regards,

Climnt

Jeff,

Yes Jeff please, sorry I haven't answered the question.

regards,

Clint

Hi there,

thank you very much for your help, I guess its complicated on my side due to very newbie of me, I have only learn basic SQL but again I...

hi jeff,

This is the details,

CREATE TABLE [Query_Concat] (

[DocDate] DATETIME,

[Shipping Line] NVARCHAR(30),

[U_soBLNo] NVARCHAR(20)

)

GO

INSERT INTO [Query_Concat] ([DocDate], [Shipping Line], [U_soBLNo])

VALUES ('20080104', N'Shipping Lines...

Hi Jeff,

Im sorry for that Jeff, Im just want to inform you first thats why im making sure before creating tables for sample. Thank you very much,

Regards,

Clint

Hi Jeff,

For clarification, I have read you link, correct me If im wrong your using fnConcatTest to concat the query, Is there any way that we can concat this without...

hi Jeff,

thank you very much for the link!

Regards,

Clint

Hi there,

Can you post your query? You cant insert if you have primary key, it must always have, unless you dont have a primary key set in you database, but...

Hi,

Thank you very much got an idea.

You help and guide me well.

Regards,

Clint

Jeff,

If very much slow then dont bother it anymore Im just taking too much of your time. We cant make it very complicated, if there is any other way like...

Jeff,

This is the link dont remember if this is the one http://articles.techrepublic.com.com/5100-10878_11-6158593.html.

In my given script it only have one table since it is already the output or result...

Hi Jeff,

I have already got the idea of running difference, I have read an article and its said that running total can be established if you inner join it from...

Hi Jeff,

thank you very much for the support!.

Regards,

Clint

Hi matt,

Im sorry for that and the purpose of Jeff and it is very well appreciated at all times. I apologize for being a newbies and not an expert like...