No announcements
Found 929486 threads
-
3 VotesConcatenate text after math?
"{0:N2} GB" -f ([math]::Round($_.FreeSpace/1GB))Answered | 8 Replies | 930 Views | Created by Adam F Kings - Wednesday, March 21, 2018 5:20 PM | Last reply by Albert Ling - Friday, March 23, 2018 1:20 AM
-
0 Votes
Concatenate text with a field value
How do you concatenate text with a field value in a group?Answered | 2 Replies | 9810 Views | Created by FogHorn I - Thursday, February 5, 2009 1:53 AM | Last reply by FogHorn I - Thursday, February 5, 2009 3:00 AM -
0 Votes
trying to concatenate text and number
This is the row that is not concatenating properly #"Add Supplier Name and Ref C" = Table.AddColumn(#"Added Conditional Column", ...Answered | 3 Replies | 1137 Views | Created by Grapevine2015 - Thursday, January 3, 2019 1:14 PM | Last reply by Colin Banfield - Thursday, January 3, 2019 5:12 PM -
0 Votes
concatenate text fields
DECLARE @tbl TABLE(ID INT,Line INT, Text VARCHAR(100)) INSERT INTO @tbl SELECT 1,1, 'The quick' UNION ALL SELECT 1,2, 'brown' UNION ALL SELECT 1,3, 'fox jumped over' UNION ALL SELECT 1,4, ...Answered | 5 Replies | 4712 Views | Created by jschroeder - Monday, January 31, 2011 4:01 PM | Last reply by Sean Gallardy - Monday, January 31, 2011 4:29 PM -
0 Votes
Concatenating a datefield and a text field
Why do you need concatenate dates with numbers.Answered | 7 Replies | 8323 Views | Created by system243trd - Wednesday, November 14, 2012 10:18 AM | Last reply by Kalman Toth - Wednesday, November 14, 2012 7:24 PM -
0 Votes
Can I concatenate text within a COALESCE statement?
I'd like to introduce some text, "Deductible is $" within a COALESCE statement for the data column [Deductible].Answered | 1 Replies | 963 Views | Created by PSULionRP - Thursday, August 15, 2013 4:22 PM | Last reply by Jingyang Li - Thursday, August 15, 2013 4:35 PM -
0 Votes
concatenation
Here are helpful links on this topic: MSDN thread about concatenating rows Making a list and checking it ...Answered | 4 Replies | 3291 Views | Created by mdpham - Tuesday, February 14, 2012 6:14 PM | Last reply by Kalman Toth - Sunday, February 19, 2012 11:22 AM -
0 Votes
Vertical Concatenation
For example, you can type "concatenate" in the search box and it will return both links.Answered | 7 Replies | 7294 Views | Created by BenSandall - Thursday, April 8, 2010 2:00 PM | Last reply by Adam Haines - Thursday, April 8, 2010 3:39 PM -
2 Votes
Concatenating text data types - is there a workaround?
You could create a temp table with a text column.Answered | 3 Replies | 2979 Views | Created by Edward444 - Tuesday, July 26, 2011 12:43 PM | Last reply by Edward444 - Wednesday, July 27, 2011 11:24 AM -
1 Votes
Concatenate many rows into a single text string
EDIT: It worked after changing database compatbility to 130.Answered | 4 Replies | 543 Views | Created by SSRSDeveloper_ - Friday, January 26, 2018 7:33 PM | Last reply by Visakh16 - Monday, January 29, 2018 5:32 PM -
0 Votes
Concatenate issue with Year and Month
I am trying to use Concatenate function to concatenate a lookup column ...Answered | 5 Replies | 1410 Views | Created by Shinu Pappan - Sunday, January 3, 2016 10:20 AM | Last reply by Jerry Zy - Monday, January 4, 2016 8:27 AM -
2 Votes
Fixing a Values Error when trying to isolate a number in a basic math problem
Another option is with the first formula set the number of digits with the TEXT function.Answered | 3 Replies | 362 Views | Created by sykoseki - Monday, September 19, 2016 6:14 AM | Last reply by Emi Zhang - Monday, September 26, 2016 10:08 AM -
3 Votes
Concatenate a string to use after the AS statement
Normally, T-SQL does not allow variable names in column aliases, nor does it allow you to use expressions, such as concatenation, to derive the column name.Answered | 8 Replies | 20496 Views | Created by Lalewicz - Tuesday, August 3, 2010 1:58 PM | Last reply by AlHowarthWF - Thursday, January 17, 2019 9:31 PM -
0 Votes
Query - Concatenate prompted text and static value in query
Hi, Is it possible to concatenate values in a sccm query?Answered | 1 Replies | 1179 Views | Created by Dian vd k - Tuesday, April 21, 2015 2:42 PM | Last reply by Garth Jones - Tuesday, April 21, 2015 11:34 PM -
0 Votes
Concatenation
jkhill74, (1) If LastName and FirstName don't have any NULL values:- SELECT LastName+', '+FirstName AS Sname FROM ...Answered | 3 Replies | 843 Views | Created by jkhill74 - Thursday, May 12, 2016 2:03 AM | Last reply by Sam Zha - Thursday, May 12, 2016 7:13 AM -
0 Votes
how to concatenate
Here is the link to that post: https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/ By ...Answered | 9 Replies | 1392 Views | Created by kumarpanjala - Tuesday, February 11, 2014 1:11 AM | Last reply by --CELKO-- - Wednesday, February 12, 2014 1:11 AM -
0 Votes
In DB2 after Concatenation Group by throws error
Hi Visakh16, The error message in the original post seems to indicating a missing comma after "as T" while I agree with you to the GROUP BY ...Answered | 6 Replies | 1757 Views | Created by Palani_M - Friday, November 20, 2015 12:12 PM | Last reply by Palani_M - Monday, November 23, 2015 10:10 AM -
0 Votes
String Concatenation
Hi StefDBA You get nothing if descrition column has NULL value As alternative create table t(a varchar(30) ...Answered | 12 Replies | 5138 Views | Created by marcobosco - Thursday, February 17, 2011 10:29 AM | Last reply by marcobosco - Thursday, February 17, 2011 11:21 AM -
0 Votes
Concatenate Pronlem
Assuming that the input data contains one entry per employee for each and every day of the month, the following PowerQuery code would do what you ...Answered | 2 Replies | 588 Views | Created by etranquille - Tuesday, May 31, 2016 3:02 AM | Last reply by Bertrand d'Arbonneau - Tuesday, May 31, 2016 9:07 AM -
5 Votes
concatenate numbers (not add them)
How can you concatenate them and not add them?Answered | 15 Replies | 36967 Views | Created by Daniel_DeHaven - Saturday, November 6, 2010 12:51 AM | Last reply by --CELKO-- - Wednesday, May 27, 2015 2:44 PM - Items 1 to 20 of 929486 Next ›
No announcements
