Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
A

Arihant rathi

@Arihant rathi
About
Posts
11
Topics
9
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • converssion of pdf into images
    A Arihant rathi

    hey any one of u can help me.. i have one pdf file with 4-5 pages and i want to save these pages as images.so i can show these pdf pages in thumbnail .i m using C# in asp.net application. can any one help me.can any one give me code help. thx

    Ajay Rathi software engineer NOIDA(UP),INDIA

    C# csharp asp-net help

  • converssion of PDF pages into images
    A Arihant rathi

    hi guys i have one problem . i want to upload a pdf file and want pages of this pdf file as a images in asp.net. means i have a pdf file and this file have 5-6 pages.and when i will upload this file ,i want these all pages should be upload as separate image in database. because i want to show all pages in thumbnails images. if any one of u can help me then it will be gr8 for me thanks

    Ajay Rathi software engineer NOIDA(UP),INDIA

    ASP.NET help csharp asp-net database

  • problem in javascript
    A Arihant rathi

    hi i m ajay can any one of u tell me that for javascript problem where i should write my problem... actually i want to make a fuction that can compare two dates....the date are in mm/dd/yyyy formate.. i want a alert that comes in that condition when second date will less thn first... and i want this onclick of button thxxx

    Ajay Rathi software engineer NOIDA(UP),INDIA

    XML / XSL javascript css help

  • problem in javascript
    A Arihant rathi

    hi i m ajay can any one of u tell me that for javascript problem where i should write my problem... actually i want to make a fuction that can compare two dates....the date are in mm/dd/yyyy formate.. i want a alert that comes in that condition when second date will less thn first... and i want this onclick of button thxxxx

    Ajay Rathi software engineer NOIDA(UP),INDIA

    Database javascript css help

  • how can i use google search engine in my site
    A Arihant rathi

    hi i need search engine in my site.. so how can i use google search engine in my site thxxx

    Ajay Rathi software engineer NOIDA(UP),INDIA

    ASP.NET question

  • want paging in repeater
    A Arihant rathi

    hi friends, i want paging with repeaters,can anyone of u help me to solve this problem.. thx

    Regards Ajay Rathi software engineer NOIDA(UP),INDIA

    ASP.NET help

  • problem in a tipical query(plzzz help me)
    A Arihant rathi

    you gave me solution of one problem "datename(month,month(start_date))" but this is giving me again and again only "january" nothing else.. so plz give me the other solution.. and wht you could not under stand in my first problem plz tell me.... i need the solution... plzzzzzzzz

    Ajay Rathi software engineer NOIDA(UP),INDIA

    Database help database question

  • help in typical query(plzzzzzzzzzzzzzz) [modified]
    A Arihant rathi

    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 Back Room help database question

  • problem in a tipical query(plzzz help me)
    A Arihant rathi

    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

    Ajay Rathi software engineer NOIDA(UP),INDIA

    Database help database question

  • group by problem(plz help me)
    A Arihant rathi

    thx a lot of thx it's working u gave me a big support.... but i have one more problem related to this problem...actually when i m using that query which u gave me that is not working when i m using a sub query in that query ... following is that query.. sum(case when Type_of_view like 'Applicants' and Posting_Id_Fk in (select Id_PK from tbl_Post_Job where Company_Id_Fk = @Company_Id_Fk and Job_Title like @Job_Title and Job_Type like @Job_Type and Job_Location like @Job_Location ) then 1 else 0 end) as Applicants, in this query i know the value of @Company_Id_Fk, @Job_Type, @Job_Location ,@Job_Title

    Ajay Rathi software engineer NOIDA(UP),INDIA

    Database database help csharp asp-net sql-server

  • group by problem(plz help me)
    A Arihant rathi

    hi i m ajay rathi..i m facing a problem in group by clause in sql query..plz any one of u help me The problem is... following are 3 queries and i need to combine all three queries into one query..because this time these queries are giving me data in three table and i am showing this data in repeater in ASP.NET with SQL SERVER 2003.. select count(*)as active from tbl_Post_Job where Company_Id_Fk = 60 and Status = 'Active' and Post_Date between '01/01/2007' and '01/01/2008' group by year(Post_Date), month(Post_Date) select count(*)as billed from tbl_Post_Job where Company_Id_Fk = 60 and Status = 'Inactive' and Post_Date between '01/01/2007' and '01/01/2008' group by year(Post_Date), month(Post_Date) select count(*)as billed , month(Post_Date) as month_date ,year(Post_Date)as year_date from tbl_Post_Job where Company_Id_Fk = 60 and Status='Inactive' group by year(Post_Date), month(Post_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 ------------------------------------ 9,2007 | 4 | 8 10,2007 | 7 | 2 12,2007 | 6 | 6 ------------------------------------ please if any one of you can help me it's very good for me plzzzzzzzzzzzzzz thanks

    Ajay Rathi software engineer NOIDA(UP),INDIA

    Database database help csharp asp-net sql-server
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups