Gives me an error message ( I did modify your syntax )

SELECT

preop.MPOG_Case_ID,

STUFF( (SELECT ',[' + s.AIMS_value_text + ']'

FROM dbo.AIMS_Preop as s

WHERE

s.MPOG_Case_ID = preop.MPOG_Case_ID

and

s.MPOG_Deleted_CD = 0

and

preop.AIMS_Preop_Concept_ID IN...

Sorry, NO.

What is PASS anyway ?

Ann Arbor, MICHIGAN 48105

Drop by if you are closeby

Thank you that works!

I owe you a beer.

No I changed my mind..

That solution worked...:):)

Thanks...Have a great day and no need to reply to this

___CASE CLOSED _______

Sorry this is too cokplicated.. Lets go back to the picture and I will explain.

The picture was to show you how the data looks like in the table.

Please...

No HELP needed.. I figured out

Select *

FROM

(

Select Pat_ID, reg, date_of_lvad, method_found as [method_found]

FROM ABCD

)as s

PIVOT

(

COUNT(method_found)

FOR [method_found] in ( [QUERY-4301],[QUERY-4723],[REGISTRY],[REGISTRY-(NO ADM DT)] )

)AS p

no did not work.. Since this was an link to an Oracle database.

However I found it while googling...

Select top 100 * FROM CDRQ_Moderage..[CDR].[EEG_TEXT_T]

This works! 🙂 GOT TO HAVE...

Thank you and please close this ticket.

Yes, that works ( I modifed according to my needs )

DECLARE @table_name varchar(50),

@sql varchar(1000);

SET @table_name = 'TEST_DATE_' + CONVERT(varchar, getdate(), 112)

Set @sql = 'Select *...

True but I do have to figure out how to rename the table and include the current date as a part of the table name.

I am not going to be...

Thx, it worked.

However when I paste the results in EXCEL the entire string got converted to some numbers ...

Hmm that is outside of this forum but a reply would be...

OK, this is good if you were to gram all the rows in a table.

Sorry, I need to able get the data from a SQL query

Can you modify your BCP...

This site has all the options for SQL sever 2014. I am going to try this

https://msdn.microsoft.com/en-us/library/ms162802.aspx

bcp "SELECT FirstName, LastName FROM AdventureWorks2012.Person.Person ORDER BY LastName, Firstname" queryout Contacts.txt -c...

Sorry I have no way to copy this.

I tried to highlight this and only part gets highlited.

Can you copy and paste the entire command in one line please