Hello

I have a question which need to ask you

I have four tables, each table such as

Table BOCLEARED

DDS BOCLEARED BOCLEAREDDATE

Table CTCLEARED

DDS CTCLEARED CTCLEAREDDATE

TABLE NHCLEARED

DDS...

Hello Ramesh,

I fell off the train, because someone pushed me. :w00t:

I have tried your codes and it gives me a error msg:

"Column 'FinalDDS.DDS is invalid in the select list because...

hello

may i ask you a question? all codes that provided by you, do i have to write in one query?

thank you

hello

how are you? I'm sorry to take me this long to say thank you very much for your helps. because i broke my arm, i will try your codes. if...

Hello,

thanks for your helps....sorry it took me this long to response back to you. because i broke my arm.

if table BOCLEARED has three columns such as DDS, BOCLEARED, and BOCLEAREDDATE....

hi

yes i declared the variable bocleared

Hello all

Please show me how to transfer data from multiple tables to single table with the same column field name.

Thanks

Hi Bob,

I try to transfer the data from 5 tables into one single table(GrandTotal) with the same field names. Below are my codes, but it gives me a syntax error...

Hi GS,

How can I avoid the query add back the comma?

here what I did, I click on view and click new view and copy the codes that I already...

HI GS,

DO you know the command how to insert data from multiple sources (in view). For example, I have 5 tables in views such as dbo.BOCLEARED, dbo.CTCLEARED, dbo.NHCLEARED, dbo.VTCLEARED, and...

Hello GS,

What is it mean GUI? I type it in View. I go to View and click new view and start typing the code in there.

Thanks

Hello GS,

I use the Microsoft SQL Server Management Studio, and when i run the codes then it automatically adds to comma back in by itself.

Thanks

Please help me ....please help me to solve this issue expert

Hello,

I replaced this code Substring as you told me then it gives me a syntax error: Incorrect syntax near ','

DO YOU KNOW WHY? THANK YOU VERY MUCH

WITH CTE AS...

Hello Ramesh,

So now I have to use Substring( ISNULL(',' + a.DDS, '') + ISNULL(',' + b.DDS, '')+.......+ ISNULL(',' + l.DDS, ''), 3,1000) right?

I have to delete COALESCE (a.DDS + ','...