Search:

Type: Posts; User: yousufkhan

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: SQL Query for different values for same ID

    my question is very simple i have itemcode and mrp column in the table it can have multiple records with same itemcode with same and different mrp
    I wand to query only those records which are...
  2. SQL Query for different values for same ID

    I have table ItemMaster (ItemCode, Mrp) I wanted to query only those records
    having different mrp with same ItemCode if there is a single record i dont want that
    only multiple record with...
  3. SMS Procedure in SQL Server 2008(Urgent)

    I have created following procedure for sending SMS
    earlier it was working fine suddenly it has stop working
    what is the problem can any body guide me urgently it has hamper my work

    CREATE...
  4. Replies
    2
    Views
    400

    Re: CTE SQL 2008 ( urgent )

    Oh thanks our are right funky i should be using a full outer join to get the result from a atleast single table my inner join is wrong
    thanks a lot
  5. Replies
    2
    Views
    400

    [RESOLVED] CTE SQL 2008 ( urgent )

    I have written the following CTE
    for monthly analysis but
    there are 4 table from where i am fetching the data for the given months
    if the given month is not present all table it skipping the...
  6. sp_OAMethod 'Send' Failed SQL Server 2008 R2

    This procedure suddenly has stop working it was working very fine earlier
    where would be the problem



    ALTER procedure [dbo].[SendSmsSQL]
    @MobileNo varchar(12),
    @smstext...
  7. Replies
    1
    Views
    1,028

    Unicode text in sms

    I have written the follwoing sp for sending sms
    i wanted send sms in other language how to pas the text in other language
    to a declared variable @smstext

    for example i have like set @smstext...
  8. Re: Aggregate query from multiple tables sql 2008

    I am not getting the accurate sum by joining

    select sum(d.depamt ),sum(a.apamt ),sum(r.rfndamt)
    from deposits d,apply a ,refund r
    where d.custid=123969 and d.custid =a.custid and d.custid =...
  9. Aggregate query from multiple tables sql 2008

    I Have three table
    Table 1 Name Deposit(CustID, DepAmt)
    Table 2 Name Refund(CustID, RfndAmt)
    Table 3 Name Apply(CustID, ApplyAmt)

    I want have query so than i can...
  10. system shutdown has already been scheduled

    I am creating internet explorer object
    and navigating it and always getting this error "System shutdown has already been scheduled
    can help me where I am wrong in the following codes


    Private...
  11. Replies
    1
    Views
    1,486

    Internet explorer maximize

    I am opening internet explorer from vb6 program in the following manner
    it is getting open but in minimize mode i wanted to open in maximize make it active


    Set ie =...
  12. Replies
    3
    Views
    803

    Re: Datagrid Date problem in XP

    Yes it is windows forms and I am using DataGridView / ListView on both i am having same problem
    this one sample where i am putting data into datagridview
    so i tried DateTime.Parse while putting...
  13. Replies
    3
    Views
    803

    Datagrid Date problem in XP

    my .net application is developed on win 7 where it work fine
    i am using datagrid i have date column in it on double click of datagrid i handover the grid data to text boxes
    while handing date type...
  14. Replies
    4
    Views
    858

    Select case with and condition

    select case with and operator

    I have 2 parameters for which i wanted to wirte select case i tried something like this

    Select case cmbo1.value and combo2.values
    case 1 and 2
    mycode
    case 1 and...
  15. Replies
    1
    Views
    541

    Removing specific Rows in DataGridView

    i have datagridview for displaying and records and to remove the rows the dgv is having a checkbox for selecting the rows to remove

    i did in the following way

    For Each row As DataGridViewRow...
  16. Replies
    3
    Views
    3,032

    Re: [RESOLVED] Set Time of DateTimePicker

    thanks
  17. Replies
    3
    Views
    3,032

    [RESOLVED] Set Time of DateTimePicker

    I have a Datetimepicker on form and sql table having Time Field
    datetimepicker is set to customformat as "hh:mm:tt"

    i wanted to set sql table's time to datetimepicker
    i queried the table got...
  18. Replies
    9
    Views
    1,553

    Re: Type mismatch error 13

    i tried byval also
    if i remove listview from function its working fine but when i am declaring Lv as listview and calling the function it giving error
  19. Replies
    9
    Views
    1,553

    Re: Type mismatch error 13

    it is highlighting
    Call lsthlpbatch(StrTxt, lvhlp)
  20. Replies
    9
    Views
    1,553

    Re: Type mismatch error 13

    space is their in the code by mistake i written here
  21. Replies
    9
    Views
    1,553

    Type mismatch error 13

    I have private procedure like this

    Private Sub lsthlpbatch(ByVal StrHlp As String, Lv As ListView)

    Lv.Refresh
    Lv.ColumnHeaders.Clear
    Lv.Visible = True
    ...
  22. Replies
    2
    Views
    663

    Pdf Creation from xml file

    I have student data in xml file
    i wanted to generate and download a pdf file from xml file for a specific record
  23. [RESOLVED] Select Button of Gridview in asp.net

    <html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
    <title>Untitled Page</title>
    </head>
    <body>
    <form id="form1" runat="server">
    <div>
    <asp:TextBox ID="txt1"...
  24. Replies
    1
    Views
    986

    web Page for downloading Hall Ticket

    I want to create a page for the student to download the hall ticket by putting their rool no and date of birth in the textbox and aurthenticating it
    I am planning to use xml file for student data...
  25. Replies
    9
    Views
    1,100

    Re: Select count() from 2 table

    select unit,count(*) from (select unit from table where
    date between '03/01/14' and '04/31/14'
    union all
    select unit from table2
    where date between '03/01/14' and '04/31/14'
    group by unit
    ...
  26. Replies
    9
    Views
    1,100

    Re: Select count() from 2 table

    its not working
  27. Replies
    9
    Views
    1,100

    Re: Select count() from 2 table

    select code,unit from talbe1
    union all
    select code, unit from table2

    but how query the list and get total units
  28. Replies
    9
    Views
    1,100

    Select count() from 2 table

    I have 2 sql tables table1 and table2 both table are having same fields - Code, unit, amt,date
    i want to write a query to have total count(unit) from both table in a single query
    but its not...
  29. Replies
    0
    Views
    1,705

    usb foot pedal/switch C#.net

    I wanted use a foot pedal in my application
    and perform some action on the click of the pedal
    how can I capture that event of foot pedal
  30. Replies
    3
    Views
    1,021

    Printing jpeg Images and text from db

    I am working one image management project now i wanted to write printing for the same

    I have images into folder and text in the sql table
    i wanted club the images and text from the sql table...
  31. Replies
    5
    Views
    555

    Re: Query in loop

    yes you are right its not fixed there can be more trntypeid's
  32. Replies
    5
    Views
    555

    Re: Query in loop

    Database is SQL server 2008 R2 instead of coumn descripton we can use TrnTypeID which is fixed
  33. Replies
    5
    Views
    555

    Query in loop

    I have table AmtDtls in which i have columns

    CustID, TrnTypeID, TrnDesc , Amt,
    1 1 SrvCharges 500
    1 1 SrvCharges 200
    1 2 ...
  34. Replies
    1
    Views
    643

    Decoding restriction

    I have done some big projects in c#.net created exe
    and i tried to decode the exe my exe's are easily getting decode by some decoding softwares
    lite .net reflector etc...
    What shall I do so...
  35. Replies
    1
    Views
    841

    Query for inventory report

    I have 2 tables I SQL DB
    1.BedMaster - fiels(WardNo,BedNo,BedSts)
    Data(G2,G1,A)
    2.Admissions fileds(AdmNo,PatientNo,BedNo,AdmissionDate,DischargeDate)
    ...
  36. Replies
    4
    Views
    1,366

    Re: Fixed lenght String

    Yes I wanted the output in text file in a formatted way I fixed width columns for the printing
  37. Replies
    4
    Views
    1,366

    Fixed lenght String

    How can I declare a fixed length string
    fixed mean if I declare a length size of 30 it should always be of 30
    even if the data is of less then 30 it should take space of 30
    if should not reduce...
  38. Replies
    2
    Views
    776

    Re: Find Age Group between 2 fields

    Thanks Funky
    its working

    if i have age 400 days it shuld select agegroupid 2 - this was wrong by mistake i have writtern 400 it would have 6570
    thanks
  39. Re: Operation not allowed when object is closed

    are you using db connection to retreiw data if so please check the connection
  40. Replies
    2
    Views
    776

    Find Age Group between 2 fields

    I have table Called AgeGroup and fields are

    AgeGroupID, AgeGroupName, MinAgeDays , MaxAgeDays


    I wanted a query to select the AgegroupID & AgegroupName by pass AgeIndays
    to query whose...
Results 1 to 40 of 497
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width