No announcements
Found 2899086 threads
-
0 Votes
Unable to acccess data from Table
I created the default TodoItem Solution for Windows 8 and everything is fine. But while debugging, I can't see any loaded items. For example in the RefreshTodoItems I added a breakpoint to watch the ...Answered | 3 Replies | 2475 Views | Created by Hans-Peter - Saturday, March 9, 2013 1:53 PM | Last reply by Hans-Peter - Tuesday, March 12, 2013 1:23 PM -
0 Votes
Duplicates removal from Acccess
Example SQL finding duplicates; - SELECT [PurchaseOrderID] ,[PurchaseOrderDetailID] , COUNT(*) FROM [AdventureWorks].Answered | 4 Replies | 6648 Views | Created by Ashika 1402 - Wednesday, January 19, 2011 4:11 PM | Last reply by Kieran Patrick Wood - Wednesday, January 19, 2011 4:50 PM -
0 Votes
SQL Server Mig Assistant For Acccess: Extended Properties
The fact is SSMA generates around 5'000 extended properties (they are created to keep the name of the column of the corresponding Access table) !Answered | 4 Replies | 8869 Views | Created by guestMS - Thursday, September 22, 2011 12:30 PM | Last reply by guestMS - Monday, September 26, 2011 7:46 AM -
1 Votes
Unable to change data type in a SQL 2008 table
SQL Server prevented me from data loss.Answered | 7 Replies | 2940 Views | Created by BKreft - Tuesday, October 8, 2013 4:28 PM | Last reply by BKreft - Tuesday, October 8, 2013 7:20 PM -
1 Votes
Unable to Update Data-Connected Linked Table
create PowerPivot linked tables from both.Answered | 4 Replies | 6641 Views | Created by GeorgU - Thursday, November 29, 2012 7:02 PM | Last reply by Ed Price - MSFT - Friday, October 25, 2013 9:25 PM -
0 Votes
Data Genration plan - unable to see the tables
I'm trying to create a data generation plan for some of my tables using VS2010. i did the below steps..but i couldnt find the table list in the panel to select.Answered | 1 Replies | 6933 Views | Created by msbimsbi - Tuesday, December 20, 2011 12:35 PM | Last reply by RamJaddu - Tuesday, December 20, 2011 12:42 PM -
0 Votes
Retieve Data from a table
If the table has a field that is related to data in the table currently feeding your form the you can add it in the Record Source using a LEFT JOIN current table to ...Answered | 2 Replies | 750 Views | Created by DonnaLPorter - Monday, June 10, 2013 6:23 PM | Last reply by QA Guy CommElec - Monday, June 10, 2013 7:27 PM -
0 Votes
SSIS unable to load the data into destination table
But i am unable to load the data into destination as a single file(21000) Thanks, RamAnswered | 3 Replies | 3527 Views | Created by Ramanjaneyulu Golla - Friday, July 19, 2013 5:51 AM | Last reply by Koen Verbeeck - Friday, July 19, 2013 6:36 AM -
0 Votes
accessing an acccess database in .net
You can select created identity from Access database using SELECT @@IDENTITY statement.Answered | 1 Replies | 2696 Views | Created by Bruno_1 - Wednesday, May 5, 2010 2:58 AM | Last reply by VMazur - Wednesday, May 5, 2010 10:56 AM -
0 Votes
Deleted Data from table
You need to use xquery to get the data from you imported table.Answered | 13 Replies | 3626 Views | Created by Manjunath.M - Tuesday, October 25, 2011 5:46 AM | Last reply by Warwick Rudd - Wednesday, October 26, 2011 5:23 AM -
0 Votes
Data from a query into a table.
Return the desired columns from both tables as a query's result table, e.g.Answered | 1 Replies | 701 Views | Created by Devon_Nullman - Saturday, June 25, 2016 4:42 PM | Last reply by Ken Sheridan - Saturday, June 25, 2016 5:20 PM -
0 Votes
Need to copy data from 2 sets of tables which some refer to identity columns of one table in the group
Then use BIDS studio to open it from the SQL Server, and edit that file with whatever other functionality you need and save it as the job you want to use to copy the records ...Answered | 2 Replies | 1375 Views | Created by shiftbit - Friday, June 14, 2013 8:49 PM | Last reply by J Alverson - Sunday, June 16, 2013 12:00 AM -
0 Votes
Unable to get data from table having millions of records
Transaction Isolation levels, the process which is modifying the data, acquires an exclusive lock on data and prevents other processes from reading and ...Answered | 4 Replies | 1114 Views | Created by ManikantM - Tuesday, January 28, 2020 2:21 PM | Last reply by ManikantM - Thursday, January 30, 2020 1:22 PM -
0 Votes
export data from table
In the export wizard "Specify Table Copy or query" window select Write a query....Answered | 6 Replies | 2629 Views | Created by DBA DEVELOPER - Wednesday, April 4, 2012 9:10 AM | Last reply by DBA DEVELOPER - Wednesday, April 4, 2012 12:45 PM -
0 Votes
Unable to join a linked table
I cannot change the data types as they are from another database.Answered | 7 Replies | 7627 Views | Created by system243trd - Saturday, September 24, 2011 7:11 AM | Last reply by system243trd - Wednesday, September 28, 2011 11:22 AM -
0 Votes
Transfer data from a table to another table
If there's a lot of data to be transferred then you can still use a linked server you just have to transfer the data in small batches rather than using one large transaction.Answered | 6 Replies | 897 Views | Created by DataNerdE - Wednesday, July 2, 2014 6:48 PM | Last reply by Itz Shailesh - Thursday, July 3, 2014 3:30 PM -
1 Votes
Create a Parameterized Query from a Data Table (VB.NET)
For that I have 3 tables: Books_Main (BookID, Title, AuthorID, PublisherID, NumOfPages, Language, YearPublished, Version, ISBN, Location)Books_Authors ...Answered | 2 Replies | 2288 Views | Created by Abdullah Gulraiz - Sunday, March 16, 2014 1:37 PM | Last reply by Fanny Liu - Monday, March 17, 2014 3:01 AM -
3 Votes
unable to retrive data from two tables using multiple joins
Sai, It would be very helpful if you could mention your table structures a bit more clearly.Answered | 3 Replies | 1149 Views | Created by avs sai - Thursday, October 9, 2014 6:58 AM | Last reply by Jayakumaur (JK) - Thursday, October 9, 2014 8:57 AM -
2 Votes
Retrieve the data from table
Hi sir, I have a table,it contained EID,Ename,Deptno and i want to retrieve data like deptno,all Enames with comma seperation(30,ramu,subbu,suman,raja) ...Answered | 2 Replies | 9735 Views | Created by LSREDDY - Wednesday, January 4, 2012 8:38 PM | Last reply by Hasham Niaz - Thursday, January 5, 2012 4:46 AM -
2 Votes
compare data from tow tables ?
If both table has same data with 'column2' , it will be able to retrieve the COLUMN1 data.Answered | 3 Replies | 5723 Views | Created by abu5alilo - Wednesday, September 15, 2010 1:05 PM | Last reply by Prakash Nandwana - Wednesday, September 15, 2010 2:01 PM - Items 1 to 20 of 2899086 Next ›
No announcements