Viewing 6 posts - 1 through 6 (of 6 total)
FROM keyword not found where expected
select *
from quer a
cross join (select 'Text1' as MyText union all select 'Text2') x
missing keyword
select *
from quer a
cross apply (values('Text1'), ('Text2')) x (MyText)
SQL command not...
August 13, 2015 at 10:38 am
Well, considering the error messages did not say much more and were in french, I don't think it was really relevent to post a french error message here
As for my...
August 13, 2015 at 10:18 am
John Mitchell-245523 (8/13/2015)
Another way of doing it:
SELECT A, B, C, 'Text 1' MyText
FROM MyTable
UNION ALL
SELECT A, B, C, 'Text 2'
FROM MyTable
John
Thank you John, that worked very well.
Thank you every one.
August 13, 2015 at 9:08 am
Neither of those seemed to work, sadly.
The first one tells me I lack a "FROM" clause (and underlines union to identify where's the mistake)
The second one says it lacks...
August 13, 2015 at 8:48 am
EDIT: I'm still testing but I think I answered my question, by using CTE. Thanks!
_________________________________________
Ok thanks I will try that, another question though:
I told it came from:
FROM (...) c
Let's say...
June 10, 2015 at 11:10 am
Viewing 6 posts - 1 through 6 (of 6 total)