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: Molkas
  • Content: Threads
  • Order by date
  1. Molkas

    Replace multiple values on a string with data from another table

    --I have two Sql Server 2012 tables with data similar to these: -- Table 1 Declare @Product_Sales Table (Suggested_Products varchar(max) null); Insert Into @Product_Sales Values ('({1421,1} OR {1422,2}) AND NOT ({1426,2},({1698,0} OR {1699,1} OR {1700,0})'), ('{1698,0} OR {1699,1} OR {1700,0}')...
  2. Molkas

    Greetings, We have a MS Sql Server

    Greetings, We have a MS Sql Server table which outputs data like this: (1000 OR 1001 OR 1002 OR 1003 OR 1004) And Not (2000, 2001) I need to report the data this way: (Alfred OR Bruce OR Crystal OR David OR Esperanza) AND NOT (Monica, Ruben) There is already a table with the user data. The...
  3. Molkas

    T SQL - Name Format - String manipulation

    Hello everybody, I'm new to MS T SQL. I'd like to request your help with name formatting. My data comes from one single table and contains employee names like this: ANDREW J. O'BRIEN JR. I need to format the names as follows: O'Brien, Jr. Andrew J Thank you in advance for your assistance...
  4. Molkas

    Faily new in Crystal Reports (version IX)

    How do you calculate the previous business day from today (excluding Saturdays and Sundays)? Thank you sincerely for your help. Merry Christmas. Molkas Guevara
  5. Molkas

    Currency formatting on CR-9 problem

    How can I format a field to show currency value this way: $1 (instead of 1,250) $125 (instead of 125,078) $1,125 (instead of 1,125.345) Thank you. - Molkas

Part and Inventory Search

Back
Top