when I use 'RowNumber' = ROW_NUMBER() OVER(ORDER BY ColumnName) then due to orderby Column name consume 76% usage. in such case what I have to do? I can see sorting taking much time in execution plan.
View Complete Post
This is the third part of my three-part series on serialization. In part one, I showed how to serialize and deserialize objects. I also showed how to define types that allow instances of themselves to be serialized.
MSDN Magazine September 2002
MSDN Magazine July 2002
MSDN Magazine April 2002
So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.
Does anyone else experience this? If so is it a known problem and being worked on?
I have a little question about calculated columns in WSS 3.0 (not MOSS 2007)
How can I have a calculated column which is a Date+Time based on a text_column
Converting YYYYMMDD_HHMM (time = 24 hour format) formatÃÂ ==>ÃÂ Date+Time
20070629_0848 converting to 29/06/2007 08:48
==> I have already a formule, but with teh DATE(...) function, you cannot give the hour-minute-seconds as a parameter, so the time is always 00:00 in WSS 3.0 (and yes, i have selected date+time as result-type for the column)
Is this possible in WSS to calculate a full date out of a text, maybe if i use two seperate text-columns, and convert a to date and one to time and a third which combines the two...
It would be a huge help if somebody could give me som advice to calculate a full date+time out of one or more text-columns....
Situation: SQL database, Linq to SQL class a ASP.NET page with a LinqDataSource and a gridview.
The table has a ID field, a date field and a Serialnr field.
In my Grid I like to Page on the datefield but to sort on the serialnr field ( or a selectable other field).
Is that possible? Standard the paging is always done on the sort field and when you select a different sort field the page jumps back to the first page., and paging is then done over that sorted column.
I want to get the old state (lets say datagridview default state) of grid after sorting is done. How can I achive this.
I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.
I can manage to set the field to today() => but the time is always 00:00 houres.
I would like toÃÂ set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)
So I anyone could help me how I can do such "simple" task, I would be very pleased.
I have a datagrid column whose column values are databinded. I have used DataGridTemplateColumn and i need to use the sorting in this column.
<my:DataGridTemplateColumn SortMemberPath="FileName" Header="Name" IsReadOnly="True" MinWidth="150">
It works and sort the the data but when i edit the data after sorting, i need to re-generate the columns data.
FileListingGrid.ItemsSource = listFiles1;
But this generates "'Sorting' is not allowed during an AddNew or EditItem transaction. "
It works file when column data is not sorted but whenever i sort the data and have to re-generate the column data, it throws the following error.
private ObservableCollection<SummaryItem> _summaryData = new ObservableCollection<SummaryItem>();
SummaryDataGrid.ItemsSource = _summaryData;
SummaryDataGrid.AutoGeneratingColumn += (s, e) =>
//if (e.Column.Header.ToString() == "ProcessName")
// e.Column.Width = new DataGridLength(1, DataGridLengthUnitType.Star);
e.Column.Width = new DataGridLength(1, DataGridLengthUnitType.Star);
public class SummaryItem : INotifyPropertyChanged
public event PropertyChangedEvent
I can't find out how to set the format for this column in document libraries. I have seen the column also display time so I know it's possible.