.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Please provide the data in expected format.

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

Please find the below table

 

Doc Build
A PQ
B RS
C TU

I want the data in below format.

 

Doc Build1 Build2
A PQ RS
B PQ RS
C

View Complete Post


More Related Resource Links

Please Provide the result in my Expected Format

  
Table:   Doc Sno A 1 B 2 C 3 Expected result is   Doc Sn1 Sn2 A 1 2 A 2 3 A 3 1 B 1 2 B 2 3 B 3 1 C 1 2 C 2 3 C 3 1 Ramesh.M

Please provide the data in the below format.

  

Table looks like this

 

Sno Text
1 AB
2 ZB
3 CA
4 TQ

And i need the output will be like this (1,2);(1,3);(1,4);(2,3),(2,4);(3,4).It means i need output in the below format.

 

Build1

SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities

  

SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.

Jay Nathan

MSDN Magazine September 2005


Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to

  

Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of data from SQL Server 2000 and make the process of pushing data to your users a lot easier.

Alok Mehta and Daniel Williams

MSDN Magazine August 2002


System.Data.SqlClient.SqlException: Bulk load data was expected but not sent

  
Hi everyone We've had this error twice now from our C# code. Nothing is changing the columns, but I've noticed though that it appears to happen when two threads are attempting to bulk insert into the same table, generally millions of rows. The docs say that SqlBulkCopy.WriteToServer is not guaranteed to be thread-safe, but is this the problem here? It feels like it. I've seen some posts where people appeared to have experienced problems in similar circumstances (http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/85d51484-6381-46bc-bcce-63b58b362d2d). There is no identity column just a non-unique clustered index that is (spid) process keyed to each thread. Do I need to synchronise access to the table for WriteToServer - is this a known problem? Many thanks Reg --- System.Data.SqlClient. SqlException: Insert bulk failed due to a schema change of the target table.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()   at System.Data.SqlClient.SqlBulkCo

SQL Query to retrive the data in XML Predefined tag format

  
I am looking out the way for  instead of using column names as tags, be able to use a predefined mapping. For example Select firstname from employee <firstname>John</firstname> Instead, Have a file that maps the firstname to fname so when we run the TSQL should get:  <fname>John</fname> Please consider that there are over 100 columns in the Query for which how can I use the predefined format.  Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!

Unable to export data to an excel file in grid format!!!

  
I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines. I think I'm missing to set some property or somethnig ehwn exporting.   Any help would be really appriciated.

putting data in a format send by email

  
Gooday If i want to send my data to someone by email so as they can update the data into their database , how can i do this . The database is too big to send by email? thanks Robrh

Suggest controls for the data format shown in message.

  
Hi all,  I have to display data in following format in asp.net. Please suggest me the best suited control for the same. Any help with code, rather than just the control names would be much appreciated.thanks in advance.-Harshal Month Category Budget ($) Actual ($) Updated Budget ($) Completed August 2009 --> CMG0 --> -$22,294,000.00 $0.00 -$22,294,000.00 Y TOTAL: -$22,294,000.00 $0.00 -$22,294,000.00   September 2009 --> CMG0 --> $0.00 $0.00 $0.00 Y TOTAL: $0.00 $0.00 $0.00   October 2009 --> CMG0 --> $0.00 $0.00 $0.00 Y TOTAL: $0.00 $0.00

format-number issues with the Data View Web Part in SharePoint 2010

  
I have a number column named @Year_x0020_1_x0020_Revenue in the data view web part in SharePoint Designer 2010. In the Xpath expression builder - @Year_x0020_1_x0020_Revenue previews "500,000" If I use the format-number in the Xpath expression builder ==> format-number(@Year_x0020_1_x0020_Revenue, '$#,##0.00;-$#,##0.00'), it returns NaN. Is there any reason? 

consuming wcf Data service in different format in client - SOAP (including a WDSL), XML, JSON, etc.

  
Hi I have implemented wcf data service with entity framework with the following steps, i want to know i can we consume this WCF Data service in different format like (SOAP, JSON, XML, PLIST). it will be helpfull if some one help on this. - Created web application with VS2010 and added edmx file and selected tables,views and SPs that i want to use - imported SP with complex type by using function import. - Created WcfDataservice (.svc File). - in SVC File i have added [webget] method as follows.         [WebGet]        public List<GetSearchResultWithComplextype_Result> GetSearchResultComplextype(string email, string Title, string Color)        {            Entities db = new Entities();            var query = db.GetSearchResultWithComplextype(email, Title, Color);            List<GetSearchResultWithComplextype_Result> caseList = query.ToList<GetSearchResultWithComplextype_Result>();            return caseList;        } - created one more client application and added service reference. here i want to cons

consuming wcf Data service in different format in client - SOAP (including a WDSL), XML, JSON, etc.

  
Hi  I have implemented wcf data service with entity framework with the following steps, i want to know i can we consume this WCF Data service in different format like (SOAP, JSON, XML, PLIST). it will be helpfull if some one help on this. - Created web application with VS2010 and added edmx file and selected tables,views and SPs that i want to use - imported SP with complex type by using function import. - Created WcfDataservice (.svc File). - in SVC File i have added [webget] method as follows.         [WebGet]         public List<GetSearchResultWithComplextype_Result> GetSearchResultComplextype(string email, string Title, string Color)         {             Entities db = new Entities();             var query = db.GetSearchResultWithComplextype(email, Title, Color);             List<GetSearchResultWithComplextype_Result> caseList = query.ToList<GetSearchResultWithComplextype_Result>();             return caseList;         } - created one more client application and added service reference. here i wan

"This feature installing a form template does not match the expected format" error

  

I'm trying to create a new SP Feature that consists of the following components -- an InfoPath form, a document library (list) where these forms will be used, and a custom Task list (that will be used in a workflow that is triggered when the form is submitted).  Each of these components was created in a DEV env and is working.  I then created my feature in Visual Studio 2008 and successfully created the WSP file.  I then (successfully) installed the WSP (I got no errors on install and all seemed well -- the "solution" shows up under Central Admin and shows as being deployed. 

When I go to site settings, the feature shows up, but deactivated.  WHen I attempt to activate it, however, I get this error in the SP Logs:

09/24/2010 09:38:19.12  OWSTIMER.EXE (0x07C4)                    0x07F0 Forms Server                   Forms Services Deployment      

82mz Exception FeatureInstalled failed with unhandled exception Microsoft.Office.InfoPath.Server.Util.InfoPathLocalizedException: This feature installing a form template does not match the expected format: CAPital EXpenditure Request. Refer to the

How to convert .html format data to normal text using Regular Expressions?

  
How to convert .html format data to normal text using Regular Expressions?

Issue in the Format of the Data while retrieving from Cube

  

Hi,

I have an MDX which returns me certain columns like "Sales Value", "Sales Units" etc. Now I need to find the average price which will be Sales Value/ Sales Units. But when I write this in MDX then sometimes I either get empty space or any gibberish value. I want to know what format type I need to select to fetch the actual value. My value would come something like, 0.00231.

The MDX that I have written is,

with

Member

 

[Measures].[Current Year Sales Value] as ' ( [Measures].[SalesValue], [PERIOD].[All PERIOD].[MAT1]) '

Member

 

[Measures].[Previous Year Sales Value]

populating textboxes via data reader - how do I format the string??

  

Here is what I have tried:


txtCost.Text = string.Format("{o:c}", dr["Cost"]);


Here is the error I receive.  How can I format the data that is coming from the data reader into currency format???  Also, is there a way to format it into currency without the dollar sign?


Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.



format date in data view

  

Team,

 

How do i convert date which is entered in mm/dd/yyyy format to dd-AUG-yyyy format in data view?Is there an xslt code for it?

 

Thank you.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend