Select Query To Get Last 6 Months Data

Hi,
I need to write a select query to get last six months data from a table , on monthly wise.Can anyone help me in writing this query
I am using sql server 2000.

eg: Jan...data
feb...data

TIA,
Ravi



ADVERTISEMENT

Select Last Months Data

Hi, i am trying to create a t-sql statement that will retrieve last months data (ie. if i run the query on 9th August, i only want to retrieve Julys data, 1st Sept will retrieve all of Augusts data etc). The query will be used once a month to populate a table, can anyone advise me on the correct where clause to use ?

Thanks in advance

Dave

View Replies View Related

Select Data From Table An Return All All Months

I have the following query:SELECT Month, Sum(Hits) AS Hits FROM tblHits GROUP BY Month ORDER BYMonthUnfortunately it only returns rows for months that have data assignedto them.How can I tweak this so that months 1-12 are returned, and Hits = 0 formonths with no data in the base table?Thanks.

View Replies View Related

Selecting Data Within 1 Month, 6 Months, 12 Months

 

I have the following table

 

FeedBack         Type       Date

test2                  positive     03/15/08

tes3                    negative   03/01/08

..                             ....

 

in my page i need to select the number of  negative/positive comments within the last

 

1 month, 6 months, 12 months

 

How can I accomplish that?
thanks

 

View Replies View Related

Very Hard Question On How To Query Data And Return By Months

I have a data set that returns the following







Customer
pncount
pn%
monthval

ABC
5
30
01/01/2007

DEF
9
20
01/01/2007

GHI
4
40
01/01/2007

ABC




DEF
4
90
02/01/2007

GHI
7
10
02/01/2007

ABC
4
5
03/01/2007

DEF




GHI
6
100
03/01/2007
 
but I need this









01/01/2007
01/01/2007
02/01/2007
02/01/2007
03/01/2007
03/01/2007

abc
5
30


4
5

def
9
20
4
90



ghi 
4
40
7
10
6
100

 
Any Idea Help

View Replies View Related

SELECT Where Date &>= 14 Months Ago

Hi,

I need a select statement with the condition that the date (a timestamp with format yyyy-mm-dd) is either equal to or longer than 14 months from today's date.

I am using SQL Server

Can anyone point me in the right diretion?

Thanks

View Replies View Related

How To Select Only Three Months Recored From Database

Hi guys,
Could anyone help me to write sql query to select only three months record from database
if the cur month is march then i need jan, feb and mar data , if it is jan, then i need nov , dec and jan data...how can i write sql query for this, i need this for creating reports
and also how cal i write queries based on days...mean to say that i need to select all records of particular month that falls on monday or tuesday...
Help me out.
Thanks in advance

View Replies View Related

Getdate() To Select Dates Less Than 15 Months

Hi,
I need help. I want to select dates less than 15 months, as i am new to sql server , can anyone advise me.

I tried this query but it gave me the dates that are greater than 15 months

Selec calendardate from table
where calendardate < getdate()-457

Thanks

View Replies View Related

Query For Due Months

Hi All,

I need to display the rent not paid months in the year. How can I form the query?

Help me.

Kamal.

View Replies View Related

Last 3 Months Query

Hi,
 
I need to count last 3 months records. The query I'm trying to use was based on last 8 days. How can I use this query in months and not days? Or should I use a new query?
 



Code Snippet
SELECT COUNT(Column1) AS [Nș de CartĂ”es], Column2 AS [Tipo de CartĂŁo], Column4 AS Periodicidade
FROM main_client_file
WHERE (Column9 >= DATEADD(Day, DATEDIFF(Day, 0, GETDATE() - 3), 0)) AND (Column9 <= DATEADD(Day, DATEDIFF(Day, 0, GETDATE() - 1), 0))
GROUP BY Column2, Column4
 
 


 
Thx.

View Replies View Related

Rolling 13 Months In Query

Hi,

I'm writing a query that will be calculating a number of business performance measures including the following...

Average Stock:
This is calculated by taking the actual stock value of the product category per month and dividing it by 13 if we have over 12 month's history, or if a new product, then by the number of months we have had it in stock for.

Cost of Goods Sold Annualised:
This is an average figure for the year of the sold landed costs for the product category over a 13 month period if we have over 12 months history. If it's a new product, then it's for the number of months we have had stock.

My question is, how do I tell the query to go back 13 months from the current month?

View Replies View Related

Data For Last 13 Months

 

Hi,
 
I want to select data from a table for last 13 months.
Can anyone tell me how to write the T-sql code for this?
 
The table looks like this.
 
 
FileMonth                          Type
 
2007-04-01 00:00:00.000     Total         NULL      199886109.65
2007-04-01 00:00:00.000     Total         Line        170724936.92
2007-05-01 00:00:00.000     Total         Loan       29161172.73
2007-05-01 00:00:00.000     InstLend    NULL      49780163.49
2007-06-01 00:00:00.000     InstLend    Line        42450387.44
...........
 
So I wanna pull data from 04/01/07 to 04/01/08.
 
So I wanna write a query some thing like this.
 
Select *
from table1
where Filemonth BETWEEN PreviousMonth AND Last13thMonth
 
 
Thanks

View Replies View Related

Query For Getting Missing Dates In Months

I have a table like FK_ID, Value, Date (here FK_ID is  foreign key)this table getting updated frequently by daily bases that means one record per one day(For example in January month it has maximum 31 records or minimum 0 records, in February it has maximum 28 or 29 or minimum 0 records, based on calender year)I need to query this table to get missing dates in between particular monthsfor example for one FK_ID has only 25 records in Jan 2008 month and in Feb 2008 it has 10 records , so i need to get those missing 6 dates from JAN month and 18 dates from FEB monthhow can i query this 

View Replies View Related

Sorting Data Having Months

Dear all,

 

I have a field [Month] in my table AA.having Data like ( January,February,March,April etc.)

I need to sort them by starting of month

lets say as

January

February

March

How i can i do this

Have no index and can't define a index on this field

Thanks for ur time and Help

 

Regards

Mohd Sufian

View Replies View Related

Showing Data For All Months

I have a Report Parameter Non-queried list for all months (Labels January, Februari... and Values 01,02...).
When I pick a month in my report all works fine
But I would also like to have data for the complete year (via an All selection)
How should I get this done .  Any help appreciated
Edwin
 

View Replies View Related

Return The Last 3 Months Data

Hi,

I have the following SSAS MDX query, currently taking a From & To date. How would I alter the MDX below so that just the prior 3 months data was returned for a chart of balances. I do not wish to retain the date parameters

SELECT NON EMPTY { [Measures].[EOD Book Balance] } ON COLUMNS, NON EMPTY { ([Time].[Simple Date].[Simple Date].ALLMEMBERS * [Products].[Product ID].[Product ID].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@FromTimeDate, CONSTRAINED) : STRTOMEMBER(@ToTimeDate, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Products].[Product Type].&[Term] } ) ON COLUMNS FROM ( SELECT ( { [Book Balance Type].[Balance Type].&[Credit Balance] } ) ON COLUMNS FROM [DailyBalances]))) WHERE ( [Book Balance Type].[Balance Type].&[Credit Balance], [Products].[Product Type].&[Term] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

View Replies View Related

Need Report Also Showing Months Even When No Data For That Month

Hi All,
 
would like to make a report with sales figures per month even is there are no sales figures that month.
Report should still show the month.
 
Any help to get me started in the wright direction much appreciated
 
edwin
 
 

View Replies View Related

T-SQL Scritp To Calculate The Last 6 Months Of Data In A Date Field.

Hi there,

if any body out there has done this before, can you please  post the T-SQL script that calculate whatever last months of data based on a Date field.

Thanks very much,

 

Manny

View Replies View Related

Difference Between Select Query And SelectCommand In Data Adapters

 

Can any one tell me the difference between Select Query and
SelectCommand in data adapters?

 

Using SelectCommand:

 

string selectSQL = "SELECT CustomerID, CompanyName FROM Customers WHERE Country = @Country AND City = @City"; SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");SqlDataAdapter custDA = new SqlDataAdapter();           SqlCommand selectCMD = new SqlCommand(selectSQL, nwindConn);custDA.SelectCommand = selectCMD; // Add parameters and set values.selectCMD.Parameters.Add("@Country", SqlDbType.NVarChar, 15).Value = "UK";selectCMD.Parameters.Add("@City", SqlDbType.NVarChar, 15).Value = "London"; DataSet custDS = new DataSet();custDA.Fill(custDS, "Customers");  Using Select Query: 

SqlDataAdapter
da = new SqlDataAdapter("select P_UID,P_EMIAL,P_NAME from p_users where p_email=@p_email
and p_pwd=@p_pwd", con);

            da.SelectCommand.Parameters.Add("@p_email", SqlDbType.VarChar, 50).Value
= etxt1.Text;

            da.SelectCommand.Parameters.Add("@p_pwd", SqlDbType.VarChar, 50).Value = pwdtex.Text;   Can you plz tell vat is the need for giving custDA.SelectCommand and adding parameters to that command instead of  directly giving Select Query in Data Adapter?  Similarly  Update Command: custDA.UpdateCommand.Parameters.Add("@CustomerID", SqlDbType.NChar, 5, "CustomerID") custDA.UpdateCommand.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40, "CompanyName")Dim myParm As SqlParameter = custDA.UpdateCommand.Parameters.Add("@OldCustomerID", _ SqlDbType.NChar, 5, "CustomerID")myParm.SourceVersion = DataRowVersion.Original[C#]custDA.UpdateCommand.Parameters.Add("@CustomerID", SqlDbType.NChar, 5, "CustomerID"); custDA.UpdateCommand.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40, "CompanyName"); SqlParameter myParm = custDA.UpdateCommand.Parameters.Add("@OldCustomerID", SqlDbType.NChar, 5, "CustomerID");myParm.SourceVersion = DataRowVersion.Original; instead of above process, y cant v do above method in below procedure? 

private void UpdateStudent(int
RollNo, string SName, string
Course, DateTime Doj, Decimal
FeePaid)

    {

        SqlConnection
conn = new SqlConnection("Data Source=UMASHANKAR\SQLSERVER2005;Initial
Catalog=employee;Persist Security Info=True;User ID=sa;pwd=sa1 ");

 

        SqlCommand
cmd = new SqlCommand("UPDATE Student SET SName='" + SName + "',Course='" + Course + "',Doj='" + Doj + "',FeePaid='" + FeePaid + "'
WHERE RollNo=" + RollNo, conn);

 

        try

        {

            if
(conn.State == ConnectionState.Closed)
conn.Open();

            cmd.ExecuteNonQuery();

        }

        catch {
}

        finally

        {

            cmd.Dispose();

            conn.Close();

            conn.Dispose();

        }

    }

 

PLZ TELL ME
THE DIFFERENCE OR ANY ADVANTAGES OF UPDATECOMMAND PROCESS AND QUERY METHOD

  IN this way I want difference OR ANY ADVANTAGES for InsertCommand, DeleteCommand also

View Replies View Related

Trying To Select AdventureWorks Database Data From Query Analyzer - Need Help

Hi there,    I have installed Sql server 2005 developer on my machine which already has a Sql server 2000 installed on. Now i am trying to query the Sqlserver 2005 data(Ex: from Person.Address located in AdventureWorks database) in Sqlserver 2000 query analyzer:
When i try as Select * from Address it said invalid object.
But when i explored AdventureWorks database in the Management studio i see it as Person.Address!!! i don't understand what is a Person in Person.Address??? any clues on this?
So as a test when i ran select * from Person.Address it did work and i saw the results in query analyzer.
Can any one help me understand about this confusion?
Thanks-L

View Replies View Related

How To Use INSERT INTO.... SELECT FROM Query To Export MS SQL Data In FoxPro 2.6 DBF

Hi all,

   This is my very first post to this forum. How to use the INSERT INTO... SELECT FROM query to export MS SQL 2000 data into FoxPro 2.6 DBF file?  I want to write a VB 6.0 program, and already connected to MS SQL 2000 Database by MS SQL ODBC connection. Now I want to Export this MS SQL data to FoxPro 2.6 DBF. I found ROWSET option, but don't know how to use it for FoxPro.
   Please help me.

 Thanks in Advance.

Regards,
  Rajeev Vandakar

View Replies View Related

Query - Select Common Data From One Column And Display In Severalcolumns

Hello,I have a (big) table which is not normalized, but for i need at themoment i thinkthat's no problem. Indeed, what i would like to do is to select thename field andthe note. The problem is that i want to display the note in 2different columns.the first columns will show the number (count) of time that a certainnote (e.g note=4)appears for a certain name and in the other column the same thing butfor a different note value.so each column noteX will display the number of time that the notewith the value X appears for each namefor example, to the following table:Name | note | job | city | id |----------------------------------------john | 4 | jb1 | hamb | 1 |john | 5 | jb2 | hamb | 2 |john | 5 | jb3 | hamb | 3 |john | 5 | jb4 | hamb | 4 |Mark | 4 | jb1 | mun | 5 |Mark | 4 | jb2 | mun | 6 |Mark | 4 | jb5 | mun | 7 |Mark | 5 | jb1 | mun | 8 |peter | 5 | jb3 | berl | 9 |peter | 5 | jb5 | berl | 10 |frank | 4 | jb6 | v.form | 11 |frank | 5 | jb3 | v.form | 12 |frank | 5 | jb2 | v.form | 13 |the result should be:Name | note5 | note4 |-------------------------john | 3 | 1 |Mark | 1 | 3 |peter | 2 | 0 |frank | 2 | 1 |How should be the right SQL command to show the data i want?Rui DiasJoin Bytes!Thanks a lot

View Replies View Related

Select A Subset Of Data From The Dataset Returned By A Union Query

hi all

Any day, another question. I love you guys.

I want to select a subset of data from a dataset returned by either another subquery or a union.

e.g. this is how i would do it in oracle, but i have no idea how this can be done in mssql or whether it's possible at all.

select * from
(
select col1, col2, col3 from table1
union
select col1, col2, col3 from table 2
)
where col1 = 'blah'

in essence oracle treats the data returned by the subquery as a table that it would select from.


how would i do the same in mssql?

thank you


James :)

View Replies View Related

Query To Select Data Based On Alphanumeric (surname) Information.

Hello,
 
I am trying to write a query that will be able to select different segments of data based on spelling of the last name. 
 
For example, in my database of name information, I need to select anyone whose last name starts with 'AAA' to 'EJJ'
 
then need to select anyone whose last name starts with 'EJK' to 'JAE' and so on...
 
I have tried using LIKE and some other methods with the > operator, but I can't get it to work.  Does anyone have any suggestions or ideas on how to select data based on the alphanumeric characters this way?
 
Thanks
 
 

View Replies View Related

Get The Row Counts For Each Day Going Back To 6 Months (was &"query Help&")

I have a proc to get the rowcounts for the given date range.
I have to get the row counts for each day going back to 6 months on the table.

With this proc i can get one day's row couts.. i need to loop through for all dates.

Please can someone get me the code for this.



create proc p_rowcounts

@Date1 datetime,
@Date2 datetime

SELECT
count (*) as 'Number of Rows', @Date1 as Date
FROM
Table1 (nolock)
WHERE ModifyTime >= @Date1 and ModifyTime < @Date2

thanks for the help.

View Replies View Related

Return The Results Of A Select Query In A Column Of Another Select Query.

Not sure if this is possible, but maybe. I have a table that contains a bunch of logs.
I'm doing something like SELECT * FROM LOGS. The primary key in this table is LogID.
I have another table that contains error messages. Each LogID could have multiple error messages associated with it. To get the error messages.
When I perform my first select query listed above, I would like one of the columns to be populated with ALL the error messages for that particular LogID (SELECT * FROM ERRORS WHERE LogID = MyLogID).
Any thoughts as to how I could accomplish such a daring feat?

View Replies View Related

Select Query Based Upon Results Of Another Select Query??

Hi, not exactly too sure if this can be done but I have a need to run a query which will return a list of values from 1 column. Then I need to iterate this list to produce the resultset for return.
This is implemented as a stored procedure

declare @OwnerIdent varchar(7) 
set @OwnerIdent='A12345B'

SELECT table1.val1 FROM table1 INNER JOIN  table2
ON table1. Ident  = table2.Ident 
WHERE  table2.Ident  = @OwnerIdent

'Now for each result of the above I need to run the below query

SELECT  Clients.Name , Clients.Address1 ,
Clients.BPhone, Clients.email
FROM Clients INNER JOIN Growers ON Clients.ClientKey = Growers.ClientKey
WHERE Growers.PIN = @newpin)

'@newpin being the result from first query

Any help appreciated

View Replies View Related

Is There A Way To Hold The Results Of A Select Query Then Operate On The Results And Changes Will Be Reflected On The Actual Data?

hi,  like, if i need to do delete some items with the id = 10000 then also need to update on the remaining items on the with the same idthen i will need to go through all the records to fetch the items with the same id right?  so, is there something that i can use to hold those records so that i can do the delete and update just on those records  and don't need to query twice? or is there a way to do that in one go ?thanks in advance! 

View Replies View Related

Result Sets Using Select In Query Anlyzer Vs BCP Vs Select Into

When I run simple select against my view in Query Analyzer, I get result set in one sort order. The sort order differs, when I BCP the same view. Using third technique i.e. Select Into, I have observed the sort order is again different in the resulting table. My question is what is the difference in mechanisim of query analyzer, bcp, and select into.
Thanks

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved