Historical data, how long after the data, if there is a table, there are two fields a and b.

The type of a is int and the type of b is date.

The conversion date and date range SQL is as follows:

Select * from a where b between convert(datetime,' 2015-08-0108: 08') and convert (datetime,' 2015-08-0108').

The above SQL is the query history, and the dates are' 20 15-08-0 108: 08' and' 2015-08-0/8:12: 08' respectively.

Data between

You can create reports through Microsoft. SQL？ Server? 2008? Doing business in R2? Intelligence? Development? Studio or Microsoft? Vision? Use the ReportView control to create a report in studio. This example uses Microsoft? SQL？ Server? 2008? Doing business in R2? Intelligence? Development? Studio creates reports.

Create a report server project

Before generating reports, you should create a report server project, in which several reports can be stored for users to call. Doing business? Intelligence? Development? The steps to create a report server project in Studio are as follows.

Select start | all programs |Microsoft? SQL？ Server? 2008? R2 | Business? Intelligence? Development? Studio, start the business intelligence development environment. Select File | New | Project from the menu bar to open the New Project dialog box. Select the Business Intelligence project option in the Project Type list, select the Report Server Project Wizard option in the Template list, enter Report Project 4 in the Name text box, and then click OK to create the project.

Click Next to enter the operation of creating data sources.

Creating a data source data mining tutorial

A data source is essentially a definition of a connection to a location where data is obtained. Can it be connected by SQL? Can I use any OLE for the connection to the server data source? A connection to a database or ODBC data source.

Is the data source a report? The most important content in the service. No matter what kind of report you create, and whether the report uses report modeler or report project, it works in some way. There are two types of data sources: embedded and shared.

Enter the bookstore name and data in the new data source? In the connection string. Source = localhost initials? Directory = Bookstore, click Next to enter the design query interface;

Design report:

Doing business? Intelligence? Development? Select View | Toolbox from the menu bar of Studio, and use the report items in the toolbox to design and improve the report.

Publish a report

After the report design is completed, you need to deploy the report. The operation steps are as follows:

Doing business? Intelligence? Development? Select Project | Report Project 4 Properties from the menu bar of Studio to open the Report Project 4 Property Page dialog box. In the TargetReportFolder field, set the folder where you want the report to reside when logging in to Report Manager. In the TargetServerURL field, enter the Web service URL of the report server. In this example, the URL is very simple, that is, http://localhost/ReportServer? . After confirming these parameters, click OK to return to business? Intelligence? Development? Studio is ready for deployment.

Start the browser and open the address http://localhost/Reports? And you can see SQL? Server? Report? Service? Personal folder, where you can make some settings.