help in typical query(plzzzzzzzzzzzzzz) [modified]
-
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
-
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
-
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
The most troubling aspect of this post is the fact that you have the audacity to proclaim yourself a 'software engineer'. How did you get your job?
-
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
-
Arihant rathi wrote:
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, ...
Did you know that I'm actually the Human Torch from the Fantastic Four? No? Well let me just say "Flame On". 1. I'm assuming that you are colour blind so that the honking red text at the top which says "Do not post programming questions (use the programming forums for that)" is completely invisible to you. 2. There's no need to use text speak in CodeProject. The screen here is a lot bigger than your poxy little mobile phone so you can use the full glory of the English language to express yourself. 3. If you need the answer to a question immediately, you should probably go to a forum where people get paid to answer your question quickly. This site is manned (sorry - should say personed) by volunteers who will answer questions as and when they can. 4. Go to 1 and repeat.
Deja View - the feeling that you've seen this post before.
-
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
-
Pete O`Hanlon wrote:
Did you know that I'm actually the Human Torch from the Fantastic Four? No? Well let me just say "Flame On".
You never fail to make me LOL Pete.
J4amieC wrote:
You never fail to make me LOL Pete.
Oh yeah, he's a live one I tell ya :laugh: I actually wait for people to post programming questions in the lounge just to read Pete's replies :-D
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib
-
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, sum(case when Status = 'Inactive' then 1 else 0 end) as Billed from tbl_Post_Job where Company_Id_Fk = 60 and Start_date between Start_date and Exp_date group by year(Start_date), month(Start_date)order by year(Start_date), month(Start_date) in this query i want many things,first of all i want to say this is not right query i want query from you.. (1)month(Start_date) as start_Month, year(Start_date) as start_Year from this line i want month and year from Start_date to Exp_date (2)in active condition,if any company's status is active from january to april so in this condition the entry of active should be come in january to april in every month (3)group by year(Start_date), month(Start_date) in group by section same problem,i want data from Start_date to exp_date actually the main problem i m facing is this that when i need month and year together and active postion and billed position saperatlly.. actually i need this data in following form... Date | Active | Billed ------------------------------------ january,2007 | 4 | 2 feburary,2007 | 7 | 5 march,2007 | 4 | 2 april,2007 | 6 | 4 ------------------------------------ january,2007 is the start_date and april,2007 is the exp_date actualy above data january,2007 is coming in form of 1,2007 but i need this data in form of january,2007 so plz tell me how can i convert this data... plz if any one needs any clarification then plz ask me about this because i need this query immediatly.. plz try to help me as soon as posible -- Moved to the Soapbox by Ed. at 10:31 Wednesday 10th October, 2007
Ajay Rathi software engineer NOIDA(UP),INDIA
Wasn't this posted a few days ago? Where it should be in the programming forums?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook "There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib
-
Pete O`Hanlon wrote:
Did you know that I'm actually the Human Torch from the Fantastic Four? No? Well let me just say "Flame On".
You never fail to make me LOL Pete.
J4amieC wrote:
You never fail to make me LOL Pete.
That's funny. That's exactly what my wife says as well. Hmmmm. I'm detecting a trend here.
Deja View - the feeling that you've seen this post before.
-
Arihant rathi wrote:
hi this is ajay rathi, i am facing a very big problem, select month(Start_date) as start_Month, year(Start_date) as start_Year, sum(case when Status = 'Active' then 1 else 0 end) as Active, ...
Did you know that I'm actually the Human Torch from the Fantastic Four? No? Well let me just say "Flame On". 1. I'm assuming that you are colour blind so that the honking red text at the top which says "Do not post programming questions (use the programming forums for that)" is completely invisible to you. 2. There's no need to use text speak in CodeProject. The screen here is a lot bigger than your poxy little mobile phone so you can use the full glory of the English language to express yourself. 3. If you need the answer to a question immediately, you should probably go to a forum where people get paid to answer your question quickly. This site is manned (sorry - should say personed) by volunteers who will answer questions as and when they can. 4. Go to 1 and repeat.
Deja View - the feeling that you've seen this post before.
"Flame On" For that you are getting 5 I laughed out loud!
------------------------------------ Happy Primes Lead to Happy Memories. Don't Google FGI
-
"Flame On" For that you are getting 5 I laughed out loud!
------------------------------------ Happy Primes Lead to Happy Memories. Don't Google FGI
Dalek Dave wrote:
For that you are getting 5 I laughed out loud!
Well thank you kind sir. I aims ter please.
Deja View - the feeling that you've seen this post before.
-
after reading your post, i got brain tumour and iam now in ICU. doctor said, i can be relieved only if your question gets answered here in this forum.