Sorry, ran into an issue again ( See attached file )

SQL Sever 2012 gives you an option to add a custom delimiter.

However you can only enter one character (...

Sorry Sean was right

TOOLS-->OPTIONS does give you the options to save with a custom delimiter.

I am all set. I think, LETS SEE HOW IT GOES

Louis can you please pass an example of what command to user. Keep in mind , I need a CSV file.

And I need the delimiter to be '****%*****'...

I know what you mean.

SSMS allows me to save the data in a file that has the extension .rpt

So my next question is what tool do I use to reimport...

Sql server management studio

Can the import export wizard do just one table ?

Tried that web page. it is not there any more...

You can share yours if you like.

The only good thing is he had written in in such a way that it...

Never mind, found my own solution..

Here it goes....

Of couse I used parts from some of the solutions you provided above.

Thanks for the effort.

Can close this ticket now.

drop table #a1;

drop table...

I want #a1 to have all the labs for abc.

I don't care whether you do this via an UPDATE or INSERT or any combination.

#a1 will need to have 6 rows for 'abc'

and the rest of what was there ( 3 of them for the other members )

So a total of 9 rows

Sorry slight typo

Here is the real question

create table #a1 ( name varchar(100) , unit int, lab numeric ) ;

Insert into #a1( name, unit ) values ( 'abc', 1 );

Insert...

Thanks...

That was my mistake..

Works well......

CASE CLOSED!

Credit for LUIS ( Well done! )

Cool

But I would appreciate someone writing that query for me please

Well I need it. I can certainly update the script to remove yetersdays table.

But please I need the help.

Thx

Good Explanation. I got my answer!

So the final conclusion--> PRIMARY does not have to be clustered