Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mayu03
  • Content: Threads
  • Order by date
  1. mayu03

    SP

    Is it possible to do in one statement? I have a sp where I am passing 2 param: @lastName and @ID. Some times ID can be empty and I need to select based on lastname, if Id is not empty select spesific record. My 'or' and 'And' is not working correct. Can you help me? SELECT * FROM Table1...
  2. mayu03

    Select

    I have the following code in my sp where I am passing the param: select count(*) as Voided from Table1 where groupNumber=@GroupID and status='V' select count(*) as Active from Table1 where groupNumber=@GroupID and status='A' I wanted to display this way when the sp exec: Voided x Active y Is...
  3. mayu03

    Date

    I have a field datatype timestamp. Data in that fields looks like this : 0x0000000000000093 How do I convert this data to see a real date?
  4. mayu03

    OPENQUERY

    here is basic OPENQUERY statement, however if I use where close with conditional statement syntax is incorrect. How do I fix this issue? SELECT * FROM OPENQUERY(IMGSPE, 'SELECT * from table1) My query: SELECT * FROM OPENQUERY(IMGSPE, 'SELECT * from table1 where name='test'' )
  5. mayu03

    select case

    Why I am getting an error? Status= case Status when 'V' or 'E' then 'Voided' else 'Active'end
  6. mayu03

    Drop Table

    From a sp in database1 I need to drop a table in database2. How do I do this? Right now my statement can't see that table located in different db. drop table [dbo].[table]
  7. mayu03

    Task

    I have 2 connection (conn1 and conn2) to the different sources. I need to do the following logic: 1. Select data from conn1 based on pk 2.Compare the data to the data in conn2 based on pl 3.If data exists in conn2 update conn1 based on pk Please help me with the task I should use in order to do...
  8. mayu03

    Grid Control

    I was able to get a data from db into grid. How do I save the data from grid into db?
  9. mayu03

    user name

    How to get user name from a computer?
  10. mayu03

    Format

    I have the following statement in my module. For some reason (I can't understand...) it is running on one pc but not running on the other. I am getting an error about format function. Can you help me please.... qdf.SQL = "SELECT CVSSN, CVGRP, CVLOC, Format(CVLECY, '00') & Format(CVLEYR...
  11. mayu03

    select

    What is incorrect in this select? select Format('01/01/04','yyyymmdd')
  12. mayu03

    Array of labels

    I am trying to create dynamicaly an array of label based on the recordset value. What am I doing wrong? For i = 0 To rs.RecordCount While Not rs.EOF Set lblInput(i) = Main.Controls.Add("VB.Label", rs("PlanChangeDesc")) With lblInput(i) .Width = 3000 .Height = 3000 End...
  13. mayu03

    DB Design

    What data type should be for a fields with values (0/1)or(Y/n).
  14. mayu03

    File read

    I am just learning XML... I have a flat file (text.txt) not xml file. What should I do to transfer that file into xml file?
    • mayu03
    • Thread
    • Replies: 4
    • Forum: XML
  15. mayu03

    Questions

    In first query I am getting result back.Second query should get the same data back (just different syntax). I can't see where my error is, but my second query is not returning any result back.Pleae help 1.select a.lastname from Table1 a Left join table2 b On a.lastname=b.last 2. select...
  16. mayu03

    Remove

    I have the following string '00001762'. Sometimes it can be '00000562'. How do I remove all unwanted 0 before the actual number?
  17. mayu03

    Cast

    I have the following query where I am trying to create an extra line with a headers. But I am getting an error msg., because count in header is varchar , but in my select statement is int. How do I fix this problem? Select 'Report' as 'Report' , 'Count' Union Select 'Report',count(*) from table1
  18. mayu03

    Schema

    I have data in a file where lines end indicator is'~' Can you help me create schema for the following data. The actual data is after the second star in line. ST*278*0001~ BHT*0078*13*A990145*20010912*1010~ HL*1**20*1~
    • mayu03
    • Thread
    • Replies: 6
    • Forum: XML
  19. mayu03

    Mouse over

    I have the following code where clients can view a bigger picture when they click on a smaller. Is it possible to view a bigger picture when mouse in the smaller picture. <head> <title>HOME</title> <meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot;> <link...
  20. mayu03

    frameset

    I have following code where my frameset is on the left side. I would like to move it to the right. I've try the align=right, but it is not working. can you help me? <frameset cols=&quot;180,*&quot; border=&quot;0&quot;> <frame src=&quot;thumbnails.html&quot; scrolling=&quot;yes&quot...

Part and Inventory Search

Back
Top