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 derfloh 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
  • 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

    Did not work... :O(
  5. mayu03

    OPENQUERY

    Here is my query. SELECT * FROM OPENQUERY(LinkedServer, 'SELECT * from LinkedServer.test.dbo.Table1 where name=''test''' ) Still have this issue: Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user 'server\sqlexec'. Reason: Not associated with a trusted SQL Server connection.
  6. mayu03

    OPENQUERY

    I have a link server set, however when I am trying to see the tables in that server I get that error: Login failed for user 'net\sqlexec'. Reason: Not associated with a trusted SQL Server connection.
  7. mayu03

    OPENQUERY

    I do have appopriate permission. The problem exists only when I run query from my desktop(query analyzer). However when I run the same qeury on a server (using my user id) it is running fine. Thanks
  8. mayu03

    OPENQUERY

    I am getting this error after I change to be a correct syntax Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user 'net\sqlexec'. Reason: Not associated with a trusted SQL Server connection.
  9. 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'' )
  10. mayu03

    select case

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

    Drop Table

    Here is my statement, however it is not working. if exists (select * from dbo.sysobjects where id = object_id(N'[prov].[dbo].[Prov]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [prov].[dbo].[Prov]
  12. 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]
  13. 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...
  14. mayu03

    Grid Control

    I am using ADODB.Recordset to SQL to fill out my flexgrid.
  15. mayu03

    Grid Control

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

    user name

    How do I get validate the current user against SQL db?
  17. mayu03

    user name

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

    Format

    I try to look at reference to see if any dll missing and I couldn't see anything missing. To what libraty belong format?
  19. mayu03

    Format

    I can't chaneg to the double qu. it gives me an error
  20. 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...

Part and Inventory Search

Back
Top