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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

need some help parsing data views

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
not sure how to ask this, but, I've got an internal customer who has to grab a lot of data from a SCCM view. Specifically the v_R_User view. All of the columns are generated in the DB by AD attributes, one of them being the Manager field. We're using SQL Reporting and when the data from the column is displayed it's displayed exactly as it is in the column. thus the column data reads as the distinguished name and I'd like it to be displayed in the report as just the manager's name.  Not a SQL guru, so not sure how ot go about doing this. Any help will be greatly appreciated.

View Complete Post

More Related Resource Links

Cutting Edge: Flexible Custom Data Views


ASP. NET 1. x introduced some powerful and useful data-bound controls. However, none were designed specifically to manage the view of a single record. When you build master/detail views, you need to display the contents of a single record.

Dino Esposito

MSDN Magazine December 2005

Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Regarding Ui1 data type parsing in xml file

Hi all, I am sending data to host application in the xml file format given below <communicationData deviceStatus="D0"><communicationData> where "deviceStatus" is ui1 data type. The host application  throws a error " error: parsing "D0" as ui1 datatype ". I have tried to send deviceStatus value in decimal format as well but host application is not resposding correctly. If the hex value does not contain any alphabet then host application respond perfectly fine but if hex value contain any alphbet then host application throws error " error parsing "D0" as ui1 datatype" Can any one please tell me how to convert hexvalue(with alphabet) to Ui1 data types Thanks In advance Ravish Kumar      

Parsing XML data

Hello,I am using YQL! for one of my projects: http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22YHOO%22%2C%22AAPL%22%2C%22GOOG%22%2C%22MSFT%22%29&format=xml&env=store%3A%2F%2Fdatatables.org%2FalltableswithkeysHow can I get the following response for the results node in an object? Any ideas on the best way to approach this?

SSRS 2008 R2 Data Source View Wizard does not recognize unique key constraints on views when using O

Hi, SSRS Data Source View Wizard does recongnize Primary/Foreign Key relationships from oracle datasouce tables, but does not recognize unique key constraints on views. How can I solve this problem. Thanks

Parsing XML RSS Data

Hello, I am looking to make a small project that can take an RSS feed that is stored in XML format (i.e. http://www.bbc.co.uk/radio1/rss/rss_radio1.xml) and display it on my asp.net page. A simple XML Datasource does not seem to accept nor like a url as the defined source. How can I make an ASP.NET page that will grab data from this remote XML source and display it?

Dynamic Data Entity Framework: Initial Sort Order for Views

Hello Steve,I'm trying to set an initial sort order for my View (not table) in Dynamic Data using Entity Framework 2. I have updated my Model and Imported the View. Now I'm trying to use the DisplayColumn attibutebut it's not working.[DisplayColumn("Product", "ParsingOrder", true)]Fabio

Incomplete/truncated data Serialized to disk. Error:End of Stream encountered before parsing was com

Greetings!! i have a dataset which is constantly serialized & deserialized by multiple threads (in a thread safe manner using lock statement) using System.Runtime.Serialization.Formatters.Binary.BinaryFormatter (.net 2.0). The Code below works pretty fine but in some rare scenarios it gives the above exception while deserializing. public void SerializeData(string path, DataSet currentData) { dataStream = new FileStream(path , FileMode.Create, FileAccess.ReadWrite); try { biFormatter.Serialize(dataStream, currentData); } finally { dataStream.Flush(); dataStream.Close(); } } DataSet DeserializeData(string path) { dataStream = new FileStream(path , FileMode.Open, FileAccess.ReadWrite); DataSet storedDataSet = new DataSet(); storedDataSet.Locale = CultureInfo.InvariantCulture; try { storedDataSet = (DataSet)biFormatter.Deserialize(dataStream); } finally { dataStream.Close(); } return storedDataSet; } When i observed the serialized file i realized the file had some in incomplete/truncated data. The truncated file loo

Parsing Data Into Variables

Hi All, At present I have a number of jobs that are scheduled and executed through SQL Agent.  The Agent is set up to execute batch files that parse data into variables contained within the packages themselves. Is there anyway that I can get data into variables without using batch files just to make the process more integrated in SSIS rather than starting the process in SQL Agent to start the job, coming out of SQL Server to execute the batch file and then back into SQL Server to run the packages detailed in the batch files? I would like to point out that this is something I have inherited not built myself. Many Thanks B_G

Unable to view data on list views

I have two lists. A List item in one list will be inserted to the other list based on the actions. This is easily achieved on the event receiver by adding the list item to the target list. Though I adds the list item to the target list; i am only able to view those data when i click on "Modify View" and simply click on "OK" button. Basically its a view refresh / commit. Has anyone came across such issue?

Clear data in views of multiview


I created a asp.net survey program in which there is a multiview to store different questions and answers.
There are 5 views in a multiview. Each view has varies controls, such as text boxes, dropdown lists, check boxes.
Every time, once user move to next customer, I want to clear all data within 5 views and then start over.
Is there a easy to do it?

I created a asp.net survey program in which there is a multiview to store different questions and answers.

There are 5 views in a multiview. Each view has varies controls, such as text boxes, dropdown lists, check boxes.

Every time, once user move to next customer, I want to clear all data within 5 views and then start over.

Is there a easy to do it?

What is the techical difference between Data Sources and Data Sources Views ?


Hi friends,

I am total new in SSAS world.

Can anyone explain me, what is the fundamental difference between Data Source and Data Sources Views ?


Thanks !!!

Data Parsing


What would be the best way to parse data multiple times from a column?

ABC EFG HIK123456789 01

When this substring is run, we get some of the data 

LTRIM(RTRIM(substring(column, CHARINDEX(' ', column, CHARINDEX(' ', column)+1), 5)))


But how do we get the last two numbers (01) from the string?

passing data between views


I have a view, which contains data from a Model class.  In this view I have a <form> section and submit button, and using that to pass data to a controller works fine.  What I'm struggling with is using a link that I also have on this view which passes data to a different view if the user clicks on it.  I'm using HTML.ActionLink, and including a message, name of the view, and as the third parameter, the Model.  However, when I get to the called View, the Model is null.  Anyone know what's going on?


MVC Move Data Between Views



I am trying to move data, in the project I am working on a ViewModel containing two Data Contract Classes, from one view to another.

This is to facilitate a form process with multiple steps.  Similar to filling out a survey.

The issue is that I have been asked not to use session (due to multi tab issues), not to use cache and not to use Cookies.

What is the best way to move this data?

The only example I have been able to find revolves around creating hidden fields for all of the fields of the ViewModel and its associated classes.

Here is an example of the Hidden fields. Once the form is submitted the controller's method is given a full ViewModel object with the details from all of the hidden fields.
<form runat="server">
        <%: Html.HiddenFor(m => m.Reference)%>
        <%: Html.HiddenFor(m => m.FirstName)%>
        <%: Html.HiddenFor(m => m.LastName)%>
        <%: Html.HiddenFor(m => m.Things)%>
        <%: Html.HiddenFor(m => m.surveyData.Title)%>
        <%: Html.HiddenFor(m => m.surveyData.Q1)%>

use multiple data source views in one cube


Is it possible to use multiple data source views in one cube so I can organize each star with separate data source views?

This applies to SQL 2005 and SQL 2008 enterprise

Business Intelligence professional

.How to Create Views Displaying Cross-Web and Joined List Data



This is said to be available option, and was planned for the series. We unfortunately didn't see anything after part 3, and I am asking part 9 topic!

Any help will be appreciated. I want to show a list frmo root site in sub-web.


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