No announcements
Found 2426704 threads
-
0 VotesReturn a column's value after merge 2 table
Sheet1 is the result after merged from Table 2, as you can see indexed row 25 (PT. ERATEX DJAJA TBK) is not in the Table ...Answered | 6 Replies | 301 Views | Created by AnPham28 - Thursday, January 23, 2020 3:01 PM | Last reply by Lz._ - Thursday, January 23, 2020 5:39 PM
-
0 Votes
return a value referenced in a table
I need to return a value in a related table in ssis incoming flat file source (fact table) has a record that ...Answered | 4 Replies | 3889 Views | Created by siera_gld - Sunday, December 27, 2009 7:41 AM | Last reply by Nitesh Rai - Sunday, December 27, 2009 6:16 PM -
0 Votes
How to assign a column's value to another column's default
I got a table. i m using SQL 2005. tblMy -------- col1 varchar(10) NotNull col2 varchar(10) AllowNulls col3 varchar(10) ...Answered | 3 Replies | 6549 Views | Created by MasterG - Saturday, December 2, 2006 10:40 AM | Last reply by MasterG - Friday, December 8, 2006 9:57 AM -
0 Votes
Column's list temp table?
Hi Vit007, Why you want to get the column list of the local temp table which is only available in current session? As per my understand, you should create ...Answered | 4 Replies | 2167 Views | Created by Vit007 - Thursday, January 9, 2014 10:34 AM | Last reply by Fanny Liu - Monday, January 20, 2014 1:50 AM -
0 Votes
Setting a column's value to NULL based on another column's value
FROM paramCategories I will use result set for a treeview control. However, some of the records in the table has same values for both recID and ...Answered | 1 Replies | 4514 Views | Created by msoyturk - Monday, January 10, 2011 9:20 AM | Last reply by Gavin Campbell - Monday, January 10, 2011 9:27 AM -
0 Votes
Return a value - Powershell
I can see): 1)What the current value of $state is in postiion1 and 2) the NetPing.State return value as well. You need to do ...Answered | 11 Replies | 25572 Views | Created by Trey Walker - Friday, July 8, 2011 4:11 PM | Last reply by kjsmith42 - Tuesday, October 21, 2014 1:41 PM -
0 Votes
How to increase a column's value ?
Hi Riya, Please refer to Justin's reply to have a check, I think it could be helpful. SharePoint does not have OOTB functionality to achieve ...Answered | 4 Replies | 416 Views | Created by RiyaSharma073 - Friday, June 26, 2020 2:27 PM | Last reply by RiyaSharma073 - Monday, June 29, 2020 1:45 PM -
1 Votes
table A column joins to other tables, but which table depends on column's current value
"3". Table A has 3 rows, each with a distinct numeric value in Col1, the values in this case being 1, 2, and 3. What's ...Answered | 2 Replies | 630 Views | Created by SQL Server dude - Monday, August 8, 2016 3:48 PM | Last reply by SQL Server dude - Monday, August 8, 2016 10:14 PM -
0 Votes
return a TABLE
hello all I need a function with a return value TABLE... this is ...Answered | 1 Replies | 5345 Views | Created by GMS0012 - Tuesday, July 17, 2007 10:49 AM | Last reply by Kent Waldrop _ - Tuesday, July 17, 2007 11:03 AM -
0 Votes
Merge 2 rows of a table into one in sql
There is no simple T-SQL "merge" for your task. You need to develop a logic to scan the table for "merge" opportunities ...Answered | 1 Replies | 425 Views | Created by AussieFH - Tuesday, August 9, 2016 12:52 PM | Last reply by Kalman Toth - Tuesday, August 9, 2016 1:29 PM -
0 Votes
Return Value from Temp Table Not Correct
= CC.RangeTimeFrame END As a note DateSerial is a little Scalar-Value function to return a date. ...Answered | 2 Replies | 422 Views | Created by Programmer Guy - Friday, June 3, 2016 2:29 PM | Last reply by Programmer Guy - Friday, June 3, 2016 2:59 PM -
0 Votes
Merge 2 columns from the same table
Hi *, I have a table with 2 columns A1 and Firm. A1 holds "dirty data" and there are no NULL values. Firm holds "clean data" for some ...Unanswered | 1 Replies | 5632 Views | Created by ssauerw - Tuesday, September 19, 2006 2:52 PM | Last reply by Rafael Salas - Tuesday, September 19, 2006 3:38 PM -
4 Votes
Can we SET return value in MERGE STATEMENT (tsql) ?
Hi Guys, I have used MERGE statement in my SP but the think is I have a return value which has been declared @intReturn as int and I would like ...Answered | 4 Replies | 1693 Views | Created by Berkan Bilgin - Tuesday, February 26, 2013 10:18 PM | Last reply by --CELKO-- - Wednesday, February 27, 2013 1:50 AM -
6 Votes
Merge on temporal table fails with Attempting to set a non-NULL-able column's value to NULL
the temporal table on an hourly basisNotice sometimes the error will produce: Attempting to set a non-NULL-able column's value to NULLDrop the index from the ...Proposed | 31 Replies | 3982 Views | Created by OmaCoder - Thursday, May 3, 2018 6:03 PM | Last reply by Erland Sommarskog - Thursday, April 2, 2020 12:32 PM -
0 Votes
Return Value
declare @t table ([Return Value]Answered | 3 Replies | 4768 Views | Created by NSG12 - Wednesday, October 22, 2008 3:11 PM | Last reply by CN_SQL - Wednesday, October 22, 2008 3:40 PM -
1 Votes
table value function vs sp that return a dataset
and have others found themselves in this situation of reverting to just using a stored proc to return a dataset rather than using a table value ...Answered | 14 Replies | 2676 Views | Created by GoodOldFashionedLoverBoy - Wednesday, January 8, 2014 5:51 PM | Last reply by davidbaxterbrowne - Wednesday, January 8, 2014 8:03 PM -
1 Votes
Concantenated column's value incorrect after the item has been modified?
Thanks thriggle, my mistake was when I used the action "Set Variable" I went straight to the value which only display the fx option. After setting the variable as ...Answered | 5 Replies | 1093 Views | Created by Stunpals - Friday, December 13, 2013 8:26 PM | Last reply by Stunpals - Monday, December 16, 2013 4:12 PM -
1 Votes
MERGE statement error: Attempting to set a non-NULL-able column's value to NULL.
] ,[Table2].[CRNCY]); With the following error: Attempting to set a non-NULL-able ...Answered | 7 Replies | 8244 Views | Created by Mikhail Tsimashkou - Tuesday, January 25, 2011 12:56 PM | Last reply by John.Bevan - Friday, July 15, 2011 9:34 AM -
0 Votes
Return a Null Value
tblCsEvents has a row? 2. If there is a row exists then does the columnAnswered | 7 Replies | 424 Views | Created by Kurt Woodfin - Monday, September 25, 2017 5:18 PM | Last reply by KEAARPEE - Monday, September 25, 2017 6:53 PM -
0 Votes
Functoid Which can Return Value of Column from A table
If you are using a custom functoid and returning a string the database lookup and value extractor functoid won't work because they work on recordset. So only string functoid ...Discussion | 9 Replies | 8807 Views | Created by Sanghi - Thursday, September 17, 2009 8:31 AM | Last reply by Thiago Antonio Brancher de Almeida - Thursday, September 24, 2009 8:23 PM - Items 1 to 20 of 2426704 Next ›
No announcements
