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: Wallie12
  • Order by date
  1. Wallie12

    Multiple records one column separated by comma (,)

    Yes, I encounter this problem. Handled it two ways: 1. Importing through MS Access to DBMS 2. Changing the column deliminator to something else, like |
  2. Wallie12

    Joining Fields From 2 tables with Similiar Data

    Change LIKE to SUBSTRING(COLUMN NAME ,STARTING POSITION, ENDING POSITION) this is much faster due to the fact it reduces the amount of characters you actual look at using % compared to SUBSTRING
  3. Wallie12

    Need help to learn cte usage

    SELECT * FROM Employees -- Common Table Expression (CTE) can be thought as an inline view similar to a derived table SELECT * FROM ( SELECT EmployeeId AS EmpId, FirstName + ' ' + LastName AS FullName, ReportsTo AS YourBoss FROM Employees ) AS x SELECT * FROM x /* 1) Runs the derived table...
  4. Wallie12

    Need to mix Char and Datetime

    Thanks
  5. Wallie12

    Need to mix Char and Datetime

    Can you provide me with an example Please ToText(DATETIME,'formatstring') I am clueless! Thanks
  6. Wallie12

    Need to mix Char and Datetime

    When I do use the following IF SID = A then "NA" ELSE IF SID = B then ToText(DATETIME,'formatstring') ELSE IF SID = C then "-' ??? How do I select 24 hour formatting for Hours and Time?
  7. Wallie12

    Need to mix Char and Datetime

    I need a field to have possible mix results such as when IF SID = A then "NA" ELSE IF SID = B then DATETIME ELSE IF SID = C then "-' Thanks for the help!
  8. Wallie12

    Schedule Excel Import from a Email

    Excel is always closed and around 10am I get a email with an Excel and need to over write the existing Excel from the previous day.
  9. Wallie12

    Schedule Import of Excel into a Access Database

    Thanks
  10. Wallie12

    Schedule Import of Excel into a Access Database

    I need to Schedule an Import of a Excel into a Access Database any Ideas?
  11. Wallie12

    Schedule Excel Import from a Email

    I need to be able to schedule an import of an Excel spread sheet from an Email. Any Ideas?
  12. Wallie12

    Generating Different PDF files in crystal report

    Look into bursting option within Crystal
  13. Wallie12

    Calculate future dates - first and third Thursdays

    How to Find the number of Fridays in a date range (or any other day of the week): The following formula will allow you to count the number of Fridays in any date range. Your input dates can be database fields, formula fields or parameter fields. The Input Dates goes in place of {StartDate} and...
  14. Wallie12

    Trouble with UTC to EST/EDT time formula

    datevar t:=date({Orders.Ship Date}); if t in dateadd('d',8 - dayofweek(date(year(t),3,7)),date(year(t),3,7)) to dateadd('d',8 - dayofweek(date(year(t),11,1)),date(year(t),11,1)) then dateadd('h',4,{Orders.Ship Date}) else dateadd('h',5,{Orders.Ship Date})...
  15. Wallie12

    Procedure Using Global Temporary Table Error

    You have answered your own question "global temporary table" When you are using a global temporary table it is deleted when the process ends. Change the table type and use IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table name]') AND type in (N'U')) DROP TABLE...
  16. Wallie12

    Date Hour and Minute Format Question

    Thanks
  17. Wallie12

    DateDiff Question

    Thanks
  18. Wallie12

    Combining Days, Hours and Minutes

    Thanks!
  19. Wallie12

    Combining Days, Hours and Minutes

    Hello; I have the following: Datediff A)Days B)Hours C)Minutes and need to combine them into one output field. Any suggestions? Thanks in advance!
  20. Wallie12

    DateDiff Question

    I have the following: Datediff A)Days B)Hours C)Minutes and need to combine them into one output field. Any suggestions? Thanks in advance!

Part and Inventory Search

Back
Top