No announcements
Found 3231538 threads
-
0 VotesGetting the derived column from an other table
> I am working on a query that will create a table from an other table.Answered | 3 Replies | 1797 Views | Created by srisql - Wednesday, July 18, 2012 9:35 PM | Last reply by --CELKO-- - Wednesday, July 18, 2012 10:34 PM
-
0 Votes
Adding a new column from a table to a SQL view
As you mentioned you need to add a column from a different table, you need to join the table appropriately with the existing table so that you maintain the ...Answered | 4 Replies | 2551 Views | Created by Anu9 - Monday, November 2, 2015 6:29 PM | Last reply by Krantionline29 - Wednesday, December 2, 2015 11:55 PM -
1 Votes
join columns from a related table in grid view.
thanks, i havent had much time to play with that yet but I keep getting empty columns when adding other data screen objects.Answered | 4 Replies | 2874 Views | Created by Nehemiah Willis - Friday, July 29, 2011 5:04 PM | Last reply by JaimeH - Friday, July 29, 2011 10:28 PM -
0 Votes
Display Column into a Specific Table
Hi Sakura, Please refer to the following steps to replace the "DimProduct" table with new ...Answered | 3 Replies | 1542 Views | Created by Sakura Data - Tuesday, September 24, 2013 1:49 PM | Last reply by Elvis Long - Thursday, September 26, 2013 6:04 AM -
2 Votes
Transposing Table Data From Rows to Columns Into a View
The srcTbl in the sample can be viewed as the result of the SELECT statement from your base view that used to insert data into the resultant table in your ...Answered | 10 Replies | 1019 Views | Created by Seif Orabi - Monday, January 19, 2015 6:18 AM | Last reply by Seif Orabi - Monday, January 26, 2015 10:42 AM -
0 Votes
Mapping between view columns and table columns
Hi, I'm trying to create a mapping between my views and tables so that I can find out for each column in my views what column and what ...Answered | 2 Replies | 3053 Views | Created by kristwa - Wednesday, September 14, 2011 2:34 PM | Last reply by kristwa - Thursday, September 15, 2011 8:54 AM -
9 Votes
Referencing other tables in computed columns?
If you run a SELECT * on that table, that will take quite some more time than a view where this column had been achieved with a CROSS APPLY against contactdatasetBase.Answered | 10 Replies | 22355 Views | Created by Nathon Dalton - Monday, January 4, 2010 10:47 PM | Last reply by Zeek2 - Tuesday, October 9, 2018 2:15 PM -
2 Votes
PowerPivot-View with column which is displayed as last column
Hi I've an PowerPivot-Table in Excel with ProductGroups as rows, Month as Columns and Turnover as Values(SUM).Answered | 1 Replies | 1045 Views | Created by chmav - Wednesday, January 21, 2015 9:14 PM | Last reply by recio - Thursday, January 22, 2015 4:33 PM -
4 Votes
How to give view access to a column in a table
I tried to expand this view in SSMS but could not able to see the other columns.Answered | 3 Replies | 918 Views | Created by Donsls - Thursday, October 9, 2014 4:49 PM | Last reply by Teun van den Biggelaar - Friday, October 10, 2014 1:13 PM -
0 Votes
view that contains derived columns that feed into other derived columns
Dark Blue->Very Dark Blue Declare @t table(txt varchar(400)) insert into @t select 'blue' union all Select 'red' select *,case when Derived_1txt= ...Answered | 3 Replies | 847 Views | Created by GoodOldFashionedLoverBoy - Wednesday, July 23, 2014 7:20 PM | Last reply by SaravanaC - Thursday, July 24, 2014 11:41 AM -
0 Votes
Fetch column names from view
I need to display all the field names in a list box for the users to be able to select from.Answered | 7 Replies | 3996 Views | Created by Akila R - Wednesday, July 8, 2009 5:38 AM | Last reply by K H Tan - Wednesday, July 8, 2009 10:39 AM -
0 Votes
Verifying column definitions across tables and views
OK, After a lot of research I have determined that there is not and easy way to find dependant table/view and column name that is used to create an alias in a view.Answered | 3 Replies | 826 Views | Created by TheBrenda - Saturday, August 22, 2015 4:19 PM | Last reply by TheBrenda - Monday, August 24, 2015 2:30 PM -
2 Votes
Create a view from two tables having different number of Columns
are suggesting first to create a table with maximum number of columns possible, and the insert all the rows generated/selected dynamically into that table... and ...Answered | 8 Replies | 7829 Views | Created by devROGUE - Monday, May 7, 2012 8:25 AM | Last reply by devROGUE - Monday, May 7, 2012 12:23 PM -
2 Votes
Data Grid View Display Table
If I`m not mistaken, if there comes a data (from who-knows-where) that the height of application reduces to 300px, your datagridview MUST become blank (no data displayed).Answered | 4 Replies | 3387 Views | Created by Dora9 - Wednesday, March 21, 2012 9:10 AM | Last reply by Mitja Bonca - Wednesday, March 21, 2012 9:27 AM -
0 Votes
Display Table From MySQL DB
You might want to add a button column to the datagridview and handle clicks in the button column by adding a CellClick handler.Answered | 1 Replies | 2704 Views | Created by L.M.Z - Wednesday, September 30, 2009 1:50 AM | Last reply by Harry Zhu - Wednesday, October 7, 2009 2:46 AM -
0 Votes
Display Unbound Column From a ListBox
I tried ItemData, but it always displays the bound column.Answered | 4 Replies | 742 Views | Created by RichLocus - Friday, July 24, 2015 10:54 PM | Last reply by .theDBguy - Friday, July 24, 2015 11:53 PM -
0 Votes
Display sum of the Grouped Column in another table
SettlAmount.Value)), it displays NOT the sum of the group, but the TOTAL sum of the column Sorry, my english level is not so high..Maybe for ...Answered | 4 Replies | 1056 Views | Created by bombocha - Monday, August 4, 2014 5:50 AM | Last reply by bombocha - Tuesday, August 5, 2014 7:00 AM -
1 Votes
Display Column in a Table
FK_A_nr fields.Answered | 1 Replies | 2816 Views | Created by Sakura Data - Monday, June 3, 2013 8:46 PM | Last reply by David J. Duncan - Wednesday, August 21, 2013 9:15 PM -
2 Votes
Auditing a Table Created From Other Tables
I created two table variables; one for merging the source data from its various tables and then another to hold the exceptions.Answered | 9 Replies | 2555 Views | Created by Adam Quark - Thursday, December 1, 2011 8:48 PM | Last reply by Adam Quark - Friday, December 9, 2011 5:35 PM -
3 Votes
Dynamic table from other tables?
>> Can I populate this table dynamically?Answered | 3 Replies | 984 Views | Created by Leonel GUZMAN - Wednesday, May 16, 2018 5:33 PM | Last reply by Søren Amstrup - Thursday, May 17, 2018 12:07 PM - Items 1 to 20 of 3231538 Next ›
No announcements
