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 Chriss Miller 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: MeanJoeGreen13
  • Order by date
  1. MeanJoeGreen13

    Help with grouping

    That was my error - i was trying to post a new thread and had his thread on my clipboard and when I pasted my code in it took his by accident. My bad. Still new to this site and cant see how to remove mine.
  2. MeanJoeGreen13

    SQL Output help

    My current query: mySQL1="SELECT * FROM demo where tasks<>'' and cast(left(ptime,4) as unsigned) = " & xryear & " and status <=> " & xrstatus & " and subid <=> '" & xruser & "' and cast(substr(ptime,6,2) as unsigned)=" & xrmonth table called demo ptime column set as TEXT data inserted to...
  3. MeanJoeGreen13

    String Full Name

    I have the following that does not seem to work well. It leaves spaces where there is a null value, any idea on what the problem may be? Set full_name = rtrim(ISNULL(prefx,''))+'' +rtrim(ISNULL(first_name,''))+' ' +rtrim(ISNULL(preferred,''))+' ' +rtrim(ISNULL(middle_name,''))+' ' +...
  4. MeanJoeGreen13

    Data Type

    How can I get the data type [size] [null or not null], schema from a table columns? Please, if this is posible, show me an example.
  5. MeanJoeGreen13

    Outlook, 2003 sharing Calendar

    I have created a new folder for a calendar other than the default one. But when I try to share and give it a name to calendar and then add permissions to it, I cannot open this new shared calendar on another computer. Gives me an error message cannot find specified calendar. I tested the default...
  6. MeanJoeGreen13

    SQL function help needed

    It is SQL 2005
  7. MeanJoeGreen13

    SQL function help needed

    Yes, there is data in the TEST db. Sorry let me clarify: RM20201 is the open invoices table, and RM30201 is the invoice history table. The field GLPOSTDT simply needs to be checked for in both tables. I do not want to add the result together. My SQL is incorrect, I just am not sure how to...
  8. MeanJoeGreen13

    SQL function help needed

    I am working on a sql function to be fed an invoice number, then calculate the difference between the current system date and the last GL posting "GLPOSTDT" The function is not returning any results as of yet...see attached code USE [TEST] GO /****** Object: UserDefinedFunction...
  9. MeanJoeGreen13

    First Instance

    Forgive me but i'm a beginner at this - could you please help with the syntax? I deeply appreciate all the help!
  10. MeanJoeGreen13

    First Instance

    Sorry my error. Needs only the one Sales Date column
  11. MeanJoeGreen13

    First Instance

    I posted this in SQL forum in error ... should be in Access forums (apologies ... still new to this site). I use the following code to pull a list of customers who have placed an order for a particular product between two dates. However, if the customer has ordered this item more than once in...
  12. MeanJoeGreen13

    Crystal Reports XI - Modify sql

    I don't see Add Command in my list anywhere. My source is Sybase.
  13. MeanJoeGreen13

    Retrieving just the first instance

    I use the following code to pull a list of customers who have placed an order for a particular product between two dates. However, if the customer has ordered this item more than once in the date period multiple records appear for the customer. How can I change the SQL to just show me one...
  14. MeanJoeGreen13

    Arithmetic overflow error

    Hi, Below query failed which executing in sql 2005 64Bit and large memory select count(*) AS Buffered_Page_Count ,count(*) * 8192 / (1024 * 1024) as Buffer_Pool_MB from sys.dm_os_buffer_descriptors Msg 8115, Level 16, State 2, Line 4 Arithmetic overflow error converting expression to...
  15. MeanJoeGreen13

    Crystal Reports XI - Modify sql

    I have a report which was written in crystal 8.5. When i open it in 8.5, i can do Show SQL and modify the sql and save it. But when i export the report to XI, i am not able to modify the sql.I can do Show SQL but not modify. Any help? Thanks

Part and Inventory Search

Back
Top