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


Post New Web Links

Increase the counting records

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 

Hi, Following both scripts's last counting record goes less than 1300.
How I can get results more than 2000. Thanks.

with Q as
(select 0 as std union all select 1 union all select 2 union all select 3 union all select 4 union all
select 5 ),tn as
(select ROW_NUMBER() over (Order by (select 1)) as tm from Q Q1,Q Q2,Q Q3,Q Q4)
select * from tn where tm <= 3000 and tm % 4 <> 1


with Q as
(select 0 as Count_1_5_9 union all select 1 union all select 2 union all select 3 union all select 4 union all
select 5 ),tn as
(select ROW_NUMBER() over (Order by (select 5)) as tr from Q Q1,Q Q2,Q Q3,Q Q4)
select * from tn where tr <= 3000  and tr % 4 = 1

 




View Complete Post


More Related Resource Links

how to increase Performance onloading page and navigation of records ?? Help

  

TU

U2

U3

u4

U5


u6


this is my aspx and cs code , let me know whether it is correct or not??

onload and performance on navigation of record show be good.

Plz help me


<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True"

                DisplayGroupTree="False" ReuseParameterValuesOnRefresh="true" HasToggleGroupTreeButton="False" Height="1039px" ReportSourceID="CrystalReportSource1"

                Width="901px" />

            <CR:CrystalReportSource ID="CrystalReportSource1" runat="

how to start counting from 1 in automatic int increase field after delete table - sqlCE

  
hi
how to start counting from 1 in automatic int increase field after delete table ?
i have MEN table with 10 rows, if i delete the table (delete from MEN)
and if i insert new row - it start in 11.
how to start from 1  ?
thanks in advance
i work on sqlCE

how to start counting from 1 in automatic int increase field after delete table - sqlCE

  
hi
how to start counting from 1 in automatic int increase field after delete table ?
i have MEN table with 10 rows, if i delete the table (delete from MEN)
and if i insert new row - it start in 11.
how to start from 1  ?
thanks in advance
i work on sqlCE

ASP.NET GridView - edit records using JQuery Dialog

  
There are many ways in which you could modify modular data in Grid View:
1. Inline by making rows editable when u click on Edit
2. By using separate pages for Edit
3. By using popups/dialogs for adding/editing

adding XML 'records' with a key field

  

I have a vb.net Sub that is successfully adding 'records' to my XML file:

Private Sub btnSubmit_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles btnSubmit.Click             'for adding an XML 'record'
        Using ds As New DataSet()
            ds.ReadXml(Server.MapPath("History1.xml"))
            Dim dr As DataRow = ds.Tables(0).NewRow()
            dr("subject") = txtNewEvent.Text
            dr("year") = DateTime.Now.ToString("MM/dd/yy")
            ds.Tables(0).Rows.Add(dr)
            ds.WriteXml(Server.MapPath("history1.xml"))
            bind()
            txtNewEvent.Text = ""
        E

Showing filtered Records in Crystal Report as per User Requirement

  

ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);
            CrystalReportViewer1.ParameterFieldInfo = paramFields;
            reportDocument.Load(Server.MapPath("CMS_Report.rpt"));
&

Basic Instincts: Increase LINQ Query Performance

  

Jared Parsons demonstrates a technique to achieve maximum performance from LINQ queries on large sets of data in order to create a responsive user interface.

Jared Parsons

MSDN Magazine August 2008


Web Services: Increase Your App's Reach Using WSDL to Combine Multiple Web Services

  

The very tools that have helped drive the growing adoption of Web services, and the enabling abstractions that they provide, can often prevent developers from peeking behind the curtains at the XML standards that make up the Web services stack. This article will offer a solution that enables type sharing between proxies created for complementary Web services, while at the same time providing an opportunity to examine the Web Services Description Language (WSDL) and its interaction with the Web services tools you know and love.

Gerrard Lindsay

MSDN Magazine March 2005


dropdownbox which selects records based on criteria (TODAY, THIS WEEK, THIS MONTH, etc)

  

I have a dropdownbox which I want to use to search records based on a timescale. The gridview populates results based from that search.

So here is how I want to work this;

If a user selects "today" - a list of records input today are populated. If "this week" is selected, a list of all records added within that week from todays date is populated.

I created a forum on this issue previously but to no avail whatsoever. How do I work around this problem?

Help would be much appreciated



search multiple words into textbox and populate all records in gridview related those keywords

  

I have a textbox and a gridview which is bound to a table

what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;

1. Book

2. Red

I have set up the sql data source and everything and my like operator is this...

LIKE '%' + @record + '%'

how can I solve this problem?


sqldatasource's filter returns too few records

  

I have a puzzling issue.  This is in asp.net 2.0, using vb.  I have a gridview that is bound to a sqldatasource.  Here is the datasource code:

<asp:SqlDataSource ID="fellowsSqlDataSource" runat="server"
        ConnectionString="<%$ ConnectionStrings:PFPFellowsConnectionString %>"
        ProviderName="<%$ ConnectionStrings:PFPFellowsConnectionString.ProviderName %>"
        SelectCommand="usp_v_fellows2"
        SelectCommandType="StoredProcedure"
        UpdateCommandType="StoredProcedure"
        UpdateCommand="usp_edit_selected"
        FilterExpression="{0}"  >
        <SelectParameters>
            <asp:SessionParameter Name="psuaccessid" SessionField="username" />         
        </SelectParameters>
         <UpdateParameters>

How to save records with autogenerated html links in Sql database?

  

Hi I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?

Any help much appreciated. Thanks


How to stop unauthorized users from sending documents to a Records Center site?

  

I can't find a way to stop unauthorized users from sending documents to a Records Center site. Can someone please help me? Do i need to configure anything to restrict it to the members of the web submitters group?

I'm still using MOSS2007

Thanks!


The impossibility of doing things depends on your will to do it.

workflow and "child" records events ?

  

Hi,

 

In a project, I have two lists that are linked together with a lookup column (it's not the actual scenario, but I simplify it) :

* a parent list, that defines some fields and especially a state field that will follow the life of the object (created, open and archived)

* a children list, that also defines some fields including a lookup field to the parent list and a similar state field for its own lifecycle (created, open and archived)

 

the life cycle of both kind of objects are linked together. For example, when the parent is opened, all children must be opened too (looks like easy because it's a workflow action from parent, and finding children is simply an activity of the workflow).

Another requirement is to archive the parent when all children are archived.

What is the best approach ?

In the parent life cycle workflow, can I monitor children events (I don't think so :() ?

I can cheat a bit by adding an hidden field "all children archived" in the parent, and set this to true from a child workflow or event. I'm not at ease with this solution as it's not a proper way. Anything else I may dive ?

 

 

Any idea, advice, tip, encouragement?

thanks,

steve


Paying back the community for its help by writing articles :

changing records frm control in update panel

  

i have a list box, a command button and a grid

when i click a particular record / or multiple records on the  list box and then cclick the command button the records r transferred 2 the grid

i also have custom paging, the paging shld ocur as many times i clcik the command button

i have used updatepanel with the command button in it so that partial postback ocurs or there is no page flicker ,

but when i use update panel i get teh records in the grid but custom page is not working . it has no affect even if the records are added

if i remove update panel the paging works properly

how do i manage it with update panel


Video: SharePoint 2010: In Place Records Management

  
SharePoint now has a record management feature that can be activated on any site so that you no longer need to create a separate record center site to manage your documents. (Length: 2:33)
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