![]() |
Hi, Column1 Column2 Column3 and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns: Result
15 Jun 2016
,
|
![]() |
Hi, I have a table that looks like this:
Column1 Column2 Column3 800 900 200 500 300 40 100 600 150
and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:
Result
15 Jun 2016
,
|
![]() |
Hi, I have a table that looks like this:
Column1 Column2 Column3 800 900 200 500 300 40 100 600 150
and I would like to concatenate Column1, Column2, Column3 in a list that is order by the values of three columns:
Result
15 Jun 2016
,
|
![]() |
I'm looking into usage of function: tdstats.udfconcat. Is there any way to control the order of the values that this function concatenates?
20 May 2016
| 5 comments
,
|
![]() |
Hello
26 Nov 2015
| 1 comment
,
|
![]() |
14 Sep 2015
| 5 comments
,
|
![]() |
Hi,
20 Jan 2015
| 2 comments
,
|
![]() |
I am trying to create new variables using a combination of text and numbers. I thought this was possible but do not know for sure. I am getting the following error dont know if its because im missing something simple or the way im trying to concatenate is fundementally incorrect. The query ran exactly as desired prior to adding the concatenated fields.
11 Jan 2015
| 4 comments
,
|
![]() |
Here is the query I am running:
03 Sep 2014
| 2 comments
,
|
![]() |
Hi everyone,
14 Jul 2014
| 3 comments
,
|
![]() |
Hi Guys,
09 Jul 2014
| 2 comments
,
|
![]() |
Hello,
03 Jun 2014
| 1 comment
,
|
![]() |
Greetings,
30 May 2014
| 3 comments
,
|
![]() |
I have a query that results in data containing customer id numbers, marketing channel, timestamp. So, the results might look something like this.
19 May 2014
| 1 comment
,
|
![]() |
So, I'm not sure why this statement isn't working properly. MERGE INTO table1 as a USING table2 as b ON a.date = b.date AND a.id = b.id WHEN MATCHED THEN UPDATE SET col2 = CAST(a.col2 as VARCHAR(3)) ||','|| CAST(b.col2 as VARCHAR(3)) WHEN NOT MATCHED THEN INSERT (id, col2, date) VALUES (b.id, b.col2, b.date);
02 Apr 2014
| 7 comments
,
|
![]() |
How do I combine multiple Select queries? I have 7 queries run separately. Each query return 2 columns. Count(of something), (date) Date Range is Fixed for each query Set to 1 Week only.
15 Aug 2013
| 10 comments
,
|
![]() |
Good Afternoon, My question is this what I want to do is to a date depending on the month to add the last day of the month. For example I get:
09 Aug 2012
| 1 comment
,
|
![]() |
I've had some problems with joining to a concatenated variable and although I've fixed the problem I'd like to understand what happened here. As background, in a transaction table we have the first digit of the account number was dropped for a couple of days and so we have a number of records where the account number needs a single digit added to the front. We basically wanted to do a really simple query to find out how many transactions have been made on an account. However, when a join on the reconstructed account number didn't work. The abstraction of the code is below:
08 Aug 2010
| 1 comment
,
|