No announcements
Found 2163662 threads
-
1 VotesHow to fill table field with an arithmetical operation of fields from other two tables?
UDF computed column link: Computed Column from UDF Kalman Toth, SQL Server & Business Intelligence ...Answered | 1 Replies | 4985 Views | Created by r4ul90 - Saturday, November 13, 2010 9:42 PM | Last reply by Kalman Toth - Sunday, November 14, 2010 12:22 AM
-
1 Votes
Field is Concatenation of two other Fields
> I don't know how to do set a SQL field to be the concatenation of two other fields in design mode.Answered | 4 Replies | 912 Views | Created by TodAtWork - Monday, July 25, 2016 6:37 PM | Last reply by Albert_ Zhang - Tuesday, July 26, 2016 7:18 AM -
0 Votes
Table join two fields
So, the SQL I provided from above should work ... just name my columns so they match the correct column names in your tables.Answered | 8 Replies | 4446 Views | Created by iamapw - Tuesday, September 20, 2011 4:52 PM | Last reply by iamapw - Friday, September 23, 2011 3:12 PM -
0 Votes
Groupping by more than two fields in a Table
ColumnA.Value & "|" & Fields!Answered | 1 Replies | 4352 Views | Created by spitzmann - Monday, July 20, 2009 9:47 PM | Last reply by Robert Bruckner - Monday, July 20, 2009 10:59 PM -
0 Votes
Fill field calculated from other values from seperate list
I think I know how to put it in terms of pseudo code.Answered | 4 Replies | 6751 Views | Created by JabberWalker - Thursday, July 16, 2009 6:24 PM | Last reply by JabberWalker - Monday, July 20, 2009 4:17 PM -
11 Votes
Looking for a table and a field in list of tables?
select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%user%' -- will list all tables having columns with User select * ...Answered | 6 Replies | 773 Views | Created by cloudsInSky - Friday, July 6, 2018 2:39 AM | Last reply by Jackuline - Monday, July 9, 2018 9:45 AM -
0 Votes
Delete a field from table where?
When you write "i wanna delete only one field with out deleting the other ", i suppose that you want to set ( for example ) the value of the ...Answered | 9 Replies | 6662 Views | Created by Mr.GMKREDDY - Thursday, July 28, 2011 5:29 PM | Last reply by Thunga Anil Kumar - Wednesday, June 20, 2012 3:14 AM -
3 Votes
Cannot use Area field from both tables
Hello, For me this work, I can select all columns from all table with a 1:n relationship.Answered | 4 Replies | 2260 Views | Created by LAWSQL - Tuesday, August 27, 2013 11:50 PM | Last reply by Olaf Helper - Friday, August 30, 2013 11:41 AM -
1 Votes
How to connect id field between two tables
Create Foreign key between NTABLE.id and FTable.ntable_id When you are going to create record id 3 in FTable it gives error similarly when you are going ...Answered | 3 Replies | 4316 Views | Created by caymanag - Thursday, July 30, 2009 6:58 AM | Last reply by Shamas Saeed - Friday, July 31, 2009 7:01 AM -
2 Votes
How to explain FILTER('Table', 'Table'[Field] = "X") and FILTER(ALL('Table'), 'Table'[Field] = "X")?
Hello, ALL( {<table> | <column>[, <column>[, <column>[,…]]]} ): It returns all the values from the column(s) or all the rows ...Answered | 4 Replies | 2299 Views | Created by BIAnalyst - Wednesday, April 17, 2013 4:39 PM | Last reply by BIAnalyst - Tuesday, April 23, 2013 8:18 PM -
1 Votes
How to create a table from 2 others tables
select Fields into NewTable from Table1 T1 inner join Table2 T2 on T1.Pk = T2.FK INNER JOIN Table3 T3 on T1.PK = ...Answered | 5 Replies | 5196 Views | Created by patrickthierry - Sunday, May 2, 2010 1:26 PM | Last reply by patrickthierry - Sunday, May 2, 2010 6:55 PM -
0 Votes
How to update fields in two tables using one query
In MS-Access you can update 2 tables in a single query.Answered | 3 Replies | 3460 Views | Created by andy pelkey - Wednesday, December 7, 2011 4:59 AM | Last reply by andy pelkey - Tuesday, December 13, 2011 3:28 PM -
0 Votes
find field / table name
How to see name for that object_id?Answered | 5 Replies | 1721 Views | Created by kdinuk - Thursday, April 25, 2013 9:11 PM | Last reply by Chris Sijtsma - Friday, April 26, 2013 3:17 PM -
0 Votes
Unique ID field concatenated from two other fields
Email is unique unless shared by two people like husband & wife.Answered | 4 Replies | 1227 Views | Created by Flyersfan9474 - Wednesday, July 16, 2014 2:15 PM | Last reply by Kalman Toth - Wednesday, July 16, 2014 4:01 PM -
1 Votes
Find matching records from two tables, useing three key fields, then replace two fields in table1 from table2
My requirements changed from syncing and Updating the table to understanding why there were differences.Answered | 4 Replies | 913 Views | Created by TheBrenda - Friday, April 18, 2014 2:06 PM | Last reply by TheBrenda - Thursday, April 24, 2014 3:34 PM -
0 Votes
rename field in table variable
select Field1, 'field' + @Qrt = field2, field3 from @tblMain so the result is from field1, field2, field3 but only the field2 is ...Answered | 20 Replies | 5052 Views | Created by arkiboys - Monday, July 16, 2012 7:25 AM | Last reply by arkiboys - Monday, July 16, 2012 9:59 AM -
0 Votes
Null field in destination table
., '' as ColA from SourceTable and then map ColA to the destination column.Answered | 5 Replies | 1805 Views | Created by KenVida - Tuesday, October 9, 2012 1:07 PM | Last reply by Rajkumar5055 - Tuesday, October 9, 2012 1:28 PM -
0 Votes
How to create a calculated field from fields in different tables in a query
From these tables a I build an SQL View and use this View to create a Pivot Table from which I generate Pivot Reports.Answered | 2 Replies | 6493 Views | Created by gruaca - Wednesday, May 4, 2011 8:27 PM | Last reply by StefDBA - Thursday, May 5, 2011 4:24 PM -
1 Votes
Matching Two Tables on Date field
I learned the derived table CROSS APPLY trick from Erland.Answered | 6 Replies | 4639 Views | Created by Praveeri - Saturday, June 26, 2010 10:43 AM | Last reply by Praveeri - Monday, June 28, 2010 10:36 AM -
1 Votes
Linked Server Table fields
However, as Erland post, you can right click on the table and choose the options of “ Script Table As Select/Insert/Updates”, you can check the fields ...Answered | 7 Replies | 3469 Views | Created by tr112 - Tuesday, January 7, 2014 9:04 PM | Last reply by tr112 - Thursday, January 9, 2014 4:38 PM - Items 1 to 20 of 2163662 Next ›
No announcements
