More Related Resource Links

I understand that the below fragment will return a separate 1-row results set for each successful loop (also unnecessarily repeating the column header each time). How can I alter my procedure so that each value returned by the loop is appended
underneath the previous value as multiple rows of a single results set? Do I have to store each return value in a temp table or someother storage object? It would be nice to just be able to spit them out row by row as each loop returned. Possible? Easy? Hard?
I really appreciate the help I've received here so far.

I have two methods that do the similar thing. There are small differences here and there, which I can control by passing arguments to them when I call them, so I can effectively merge them. However one returns a string, and the other one an ArrayList.

On the top of my head, I could merge them and return an Object, and then get the information I need.

Is there a way though to return multiple types in the method's signature?

I am new in XML SQl i have created a schema with namespace in SQL 2005; I can return single records with the following query using table and column name; however, i do not understand how to return multiple (nodes) records from xml segments where there are
multiple (same) elements.

Here is the query which works with one record, when trying to declare the Namespace to use nodes get error

The schema is an HIPAA 837 schema with multiple elements ; Table name =
PATIENTTRAC_SUBMISSION_HISTORY; xml field = PATIENTTRAC_EDI_SUBMISSION

I have extended a gridview to add an additional header with following two hyperlink controls "Select All" and "Clear All". These will operate on checkboxes in the data rows of the grid. I hide the column headers as I only want to show one column with checkboxes and "Select/Clear All" links. Everything is working as expected.

Now, I wanted to add a scrollbar to my grid control, I did add the scroll bar using div but what it does is, it includes the "Select All and Clear All" links aswell. I only need to add the scrollbar to datarows and not to the header.

I am trying to extend my control to include hte scrollbar by adding div during Render function. But how will I determine or loop through header rows? How will i get the header row with hyperlinks that I created above?? In Render if I do this.HeaderRow, it gets the original column header and not the custom header. Please help!!!

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

I want to add multiple rows of a gridview if the data for multiple fields are same.

Idea for this is that a user may search a record with some parameter e.g. Sector, plot.

For example 15 records being displayed in gridview.

There should be checkbox before every row and if user wants to update Plot and Flat No that is same for 10 rows out of 15 so he will check the rows and update.

For this a dialog box should appear asking for the parameter i.e. Plot and Flat or something else next time may be it will be City or country. Moreover, there is already an Edit button to update records, when user click it another page open for the record to be updated and whatever he wants to update, it updates.

Hope everone understand the scenario.

I don't want to disturb the already provided Edit functionality and want to provide same record to be updated.

Hi all,
I'm using the below query to retrieve one vendor information. I dont want the columns and I need the query to return me one row with no column header. what would be the syntax for that. I'm trying to use this on SAP BW system - if that really matters. I
tried tweaking the code, but SAP didnt seem to like it and the error message isnt helpful either. The code below works just fine - but I want to get rid of the column header
SELECT [Measures].MEMBERS ON COLUMNS, NON EMPTY [0VENDOR].[LEVEL01].MEMBERS DIMENSION PROPERTIES [0VENDOR].[20VENDOR] ON ROWS FROM [OPOMCHS0/ZQT_GPO_PO_CHNG_REP_SUMM_3]WHERE[0VENDOR].[ABCD]
Please help. Thanks in advance.

I'm building a stored procedure to return a set of records, yes nothing big.
The column is an NVarchar column and I'm using a select statement of
Select * from Table1
where Column1 Like @Column1
Table is currently one record containing the words: ***Some Test Word*** Is my test word
I've set the value of @Column1 to:
Some - no records returned
Some% - no records returned
%Some% - 1 record returned
% - 1 record returned
*% - no records returned
%*% - 1 record returned
%Not Here% - 1 record returned
Can someone tell me why if I have a leading and trailing wildcard I will get all records returned? Does it have something to do with the '*' characters in the field because some of my users are using these characters.
I've also tried changing the select to:
where RTRIM(Column1) Like @Column1 with the same result
and
where RTRIM(Column1) Like N'%' + @Column1 with the same result
What way should I give a user the way to search for a substring inside of an NVarchar field?
Oh, I tried using the Substring function and got the same result.
Thanks
Mike

Hi all,
I've been given a specific type of report to produce, and am having difficulty in getting my SQL right to return the data as needed. I need to return TOP n Categories based on amount of sales (which I can do) but then a final category with a sum of all other
sales. The purpose would be to capture all of the small sales values into one 'Other' category so that the chart I'll produce does not have lots and lots of small-value columns.
I found the following post which seems to come close:
SELECT TOP 10 CompanyID, CompanyName, SUM(GrossSales) [GrossSales]
FROM CompanySales
GROUP BY CompanyID, CompanyName
ORDER BY SUM(GrossSales) desc
UNION
SELECT -1, 'Other' [CompanyName], SUM(GrossSales) [GrossSales]
FROM CompanySales
WHERE CompanyID NOT IN
(
SELECT TOP 10 CompanyID, CompanyName, SUM(GrossSales) [GrossSales]
FROM CompanySales
GROUP BY CompanyID, CompanyName
ORDER BY SUM(GrossSales) desc
)
But this gives a syntax error on UNION, which I'm guessing is due to the ORDER BY clauses. However I think the ORDER BY is needed to ensure I return the results in the correct order. Does anyone have any ideas of how to do this?
Thanks for any assistance
Matt

I have a ListView in my View that I would like to bind to the return value of a method on my ViewModel.
View:
<ListView DataContext={???}" />
ViewModel:
public void GetParameters(string foo)
{
return myObj.FindParameters(foo);
}
My question is, what would the binding syntax look like on the View's ListView to call GetParameters, and pass in a parameter (argument)?

Sorry if this sounds silly, but it's been getting to me for quite a while now. I've been having some issues installing both .net framework 3.5 and 4.0 on my computer since I have certain software that either requires one or the other to run.
I've tried over and over again to install framework version 3.5 from your web site, but each time, the result is the same. I always get the error that I mustconfigure the framework from the control panel. Yet I see nothing about that in the control
panel. Maybe it would help you to know that I had first found .net framework through IIS when I went to put that in there, and so I've been trying to install it from there. Every other framework version works fine except for version 3.5.
I unfortunately cannot provide any logs since my computer is currently with the Gordon college techs due to another issue, but any help on this would be appreciated. Thanks.

When i use DataGridComboBoxColumn in my WPF DataGrid, the DataGrid SelectionChanged event is triggering multiple times based on the number of rows while loading the rows in the WPF DataGrid.

How can i stop this? Because of this I am facing Performance issue.

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This will help other members to find the solution easily.