User Profile

Collapse

Profile Sidebar

Collapse
guidomarcel
guidomarcel
Last Activity: Sep 15 '05, 08:28 PM
Joined: Sep 14 '05
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • guidomarcel
    replied to Self join sub query syntax
    in General
    HI,
    there is a dot where it should not be. I formatted your SQL using the online formatter at www.sqlinform.com

    Code:
    SELECT 
    APPS.CST_ITEM_COST_TYPE_V.Item_number, 
    APPS.CST_ITEM_COST_TYPE_V.Description, 
    APPS.CST_ITEM_COST_TYPE_V.Cost_Type, 
    APPS.CST_ITEM_COST_TYPE_V.Item_Cost 
FROM 
    APPS.CST_ITEM_COST_TYPE_V 
INNER JOIN 
    (SELECT 
        Item_Number,
    ...
    See more | Go to post

      Leave a comment:

    • guidomarcel
      replied to SQL Analyzer
      in SQL Server
      Hi,
      maybe you can try the free online SQL Formatter called SQLinForm at http://www.sqlinform.com . It has the possibility to add line numbers to the SQL statement. You can use the version 1 with most computers as this Java applet is working with the very early versionof Java Runtime Environment 1.1 . The applet allows to format SQL statements independently from the DB used and you can format SQL code out of program code and / or format it...
      See more | Go to post

        Leave a comment:

      • guidomarcel
        replied to Query Analyzer. Align/indent stored procedure script
        in SQL Server
        Hi,
        maybe you can try the free online SQL Formatter called SQLinForm at http://www.sqlinform.com . You can use the version 1 with most computers as this Java applet is working with the very early versionof Java Runtime Environment 1.1 . The applet allows to format SQL statements independently from the DB used and you can format SQL code out of program code and / or format it for many different languages.

        Hope this helps
        ...
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...