No announcements
Found 3840946 threads
-
0 VotesData comparison between two tables
Data size is 6~7 millions.Answered | 5 Replies | 989 Views | Created by Ayush Raj - Monday, May 25, 2015 1:30 AM | Last reply by COZYROC - Wednesday, May 27, 2015 3:09 PM
-
0 Votes
Query the data between two tables
Because the DateTime for it in Table1 doesn’t included between FromDate column and ToDate column.Answered | 2 Replies | 1197 Views | Created by Gopal Kannaiyan - Monday, October 6, 2014 9:10 PM | Last reply by Katherine Xiong - Tuesday, October 7, 2014 9:15 AM -
0 Votes
Compare the data between tables
My team is against using merge due to performance issues in the past.Answered | 6 Replies | 1458 Views | Created by anki2010 - Sunday, March 17, 2019 10:37 PM | Last reply by Natiq Rzazade - Monday, March 18, 2019 7:03 AM -
1 Votes
Data Feed Between Tables
Hi Everyone, I have two tables.Answered | 2 Replies | 5135 Views | Created by sqlserver2000Queries - Saturday, April 17, 2010 5:26 PM | Last reply by sqlserver2000Queries - Sunday, April 18, 2010 12:39 AM -
1 Votes
data warehouse design and how to make relation between specific tables
If you have to join dimensions to each other because their is a many-to-many relationship or due to the circumstances of your environment then use a bridge table or ...Answered | 20 Replies | 11113 Views | Created by RamzyEbeid - Thursday, September 15, 2011 12:33 PM | Last reply by charlow80 - Thursday, June 7, 2018 10:36 PM -
2 Votes
Difference between Data staging and Dimension Table ?
Staging tables are not a required part of building a fact or dimension table, but are used when they come in handy.Answered | 3 Replies | 10646 Views | Created by WASI UDDIN BAN - Tuesday, November 25, 2014 3:17 AM | Last reply by Ernest Ostrander - Tuesday, November 25, 2014 4:23 AM -
0 Votes
Compare data between two tables all coullms
How do you work with this result set?Answered | 8 Replies | 21497 Views | Created by Jack Houston - Tuesday, June 26, 2012 10:40 PM | Last reply by jeffatICS - Thursday, April 10, 2014 2:01 AM -
0 Votes
How to display relational data between more than two tables.
If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.Answered | 6 Replies | 3027 Views | Created by Hamed_1983 - Friday, April 17, 2009 10:26 PM | Last reply by Guo Surfer - Friday, April 24, 2009 3:35 AM -
0 Votes
Simple SSIS for Data Integrity between two tables
Hi, Above requirement is to just understand myself about how the SSIS works.Answered | 4 Replies | 5655 Views | Created by Courageous_Heart - Tuesday, February 1, 2011 3:05 PM | Last reply by Aamir Shahzad Warraich - Wednesday, February 2, 2011 3:18 PM -
0 Votes
Inserting Data into two tables when there is reference between two tables
Hi Smash126, The Bulk Insert task provides an efficient way to copy large amounts of data into a SQL Server table or view.Answered | 2 Replies | 3325 Views | Created by Smash126 - Thursday, August 2, 2012 6:32 PM | Last reply by Eileen Zhao - Thursday, August 9, 2012 5:50 AM -
0 Votes
How to have a relation between a view & a table please.....
Per my understanding, Fundamentally, you cannot establish referential integrity between objects that exist across databases.Answered | 1 Replies | 5418 Views | Created by asitti7 - Friday, April 23, 2010 8:41 PM | Last reply by Phaneendra Babu Subnivis - Saturday, April 24, 2010 5:55 AM -
2 Votes
how to encrypt data between sql and client or is it better to use VPN?
christIndia - if you only goal is to protect the data in transit (between the client and the server), using encrypted connections via TLS is ...Answered | 4 Replies | 904 Views | Created by christIndia - Thursday, February 9, 2017 9:18 PM | Last reply by pituach - Wednesday, March 22, 2017 9:07 AM -
0 Votes
Data Synchronization using table Partitioning
Hi BHVS, Even though there are options to doing it with SSIS e.g. via lookups, or table ...Answered | 2 Replies | 812 Views | Created by BHVS - Tuesday, July 14, 2015 11:21 AM | Last reply by ArthurZ - Tuesday, July 14, 2015 1:23 PM -
3 Votes
how to share table between stored procedure?
Hi First read what is GLOBAL Temporar table as below, then use it in storead procedure.Answered | 3 Replies | 7867 Views | Created by moshik.salem - Saturday, July 14, 2012 4:49 PM | Last reply by Ahsan Kabir - Saturday, July 14, 2012 8:46 PM -
0 Votes
Simple and easy copying of data between tables
If you have two databases and want to move data from one to the other, I would not use Dataset for this.Answered | 3 Replies | 4245 Views | Created by PSAKSor - Friday, January 30, 2009 8:19 AM | Last reply by Ksor - Sunday, February 1, 2009 6:41 AM -
4 Votes
Data modeling (calculation between tables)
Let us called it Table 2a and Table 2b.Answered | 12 Replies | 1461 Views | Created by Bartek Wachocki - Tuesday, July 29, 2014 3:33 PM | Last reply by Mike Dietterick - Tuesday, August 5, 2014 2:14 PM -
0 Votes
How to give relationship between two tables with comon column with between oprator
Are you asking about how to create a foreign key?Answered | 5 Replies | 935 Views | Created by HL Raju - Tuesday, July 22, 2014 8:19 AM | Last reply by Satheesh Variath - Tuesday, July 22, 2014 9:07 AM -
0 Votes
difference between SPList and table
SPList data is stored in Content Database (Microsoft SQL).Answered | 2 Replies | 5446 Views | Created by Nilesh Nimje - Wednesday, March 17, 2010 9:06 AM | Last reply by Mike Walsh FIN - Wednesday, March 17, 2010 10:36 AM -
0 Votes
How table is getting data
Hi Knewsql, According to your description, you need to know which stored procedure was used to insert data into your table, right?Answered | 2 Replies | 1218 Views | Created by knewsql - Wednesday, April 20, 2016 7:11 PM | Last reply by Charlie Liao - Thursday, April 21, 2016 5:51 AM -
0 Votes
How to archive table data
How can i achieve this..Answered | 4 Replies | 15440 Views | Created by Sandeep.Handa - Thursday, March 4, 2010 10:50 AM | Last reply by ashishshevale - Tuesday, March 9, 2010 1:48 PM - Items 1 to 20 of 3840946 Next ›
No announcements
