User Profile

Collapse

Profile Sidebar

Collapse
shieldsco
shieldsco
Last Activity: Mar 9 '13, 06:01 PM
Joined: Oct 17 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • shieldsco
    replied to Delete Column
    in SQL Server
    Actually two of threads were futher explanation of the problem....
    See more | Go to post

      Leave a comment:

    • shieldsco
      replied to Delete Column
      in SQL Server
      I really want to delete a column based on the following example:
      Table 1
      FinancilaPeriod Month UdateMonth
      ThisYearMonthEn d01 Jan
      ThisYearMonthEn d02 Feb
      ThisYearMonthEn d03 Mar
      ThisYearMonthEn d04 Apr
      ThisYearMonthEn d05 May
      ThisYearMonthEn d06 Jun
      ThisYearMonthEn d07 Jul
      ThisYearMonthEn d08 Aug
      ThisYearMonthEn d09 Sep
      ThisYearMonthEn d10 Oct Oct
      ThisYearMonthEn d11...
      See more | Go to post

        Leave a comment:

      • shieldsco
        replied to Delete Column
        in SQL Server
        Delete Column

        --------------------------------------------------------------------------------

        I want to delete a colum in a table using the following sql statement:
        ALTER TABLE tblMarketing DROP COLUMN ThisYearMonthEn d10. In addition I only want to delete the column if it meets specific crietria. The crirtria is stored in the table below. If the UdateMonth is not null then I want to delete.

        FinancilaPeriod...
        See more | Go to post

          Leave a comment:

        • shieldsco
          replied to Delete Column
          in SQL Server
          Delete Column Using Specific Crietria

          --------------------------------------------------------------------------------

          I want to delete a colum in a table using the following sql statement:
          ALTER TABLE tblMarketing DROP COLUMN ThisYearMonthEn d10. In addition I only want to delete the column if it meets specific crietria. The crirtria is stored in the table below. If the UdateMonth is not null then I want to delete....
          See more | Go to post

            Leave a comment:

          • shieldsco
            replied to Delete Column
            in SQL Server
            Delete Column Using Specific Crietria

            I want to delete a colum in a table using the following sql statement:
            ALTER TABLE tblMarketing DROP COLUMN ThisYearMonthEn d10. In addition I only want to delete the column if it meets specific crietria. The crirtria is stored in the table below. If the UdateMonth is not null then I want to delete.

            FinancilaPeriod Month UdateMonth
            ThisYearMonthEn d01 Jan
            ThisYearMonthEn d02...
            See more | Go to post

              Leave a comment:

            • shieldsco
              started a topic Delete Column
              in SQL Server

              Delete Column

              I want to delete a colum in a table using the following sql statement:
              ALTER TABLE tblMarketing DROP COLUMN ThisYearMonthEn d10. In addition I only want to delete the column if it meets specific crietria. The crirtria is store in the table below. If the UdateMonth is not null then I want to delete.

              FinancilaPeriod Month UdateMonth
              ThisYearMonthEn d01 Jan
              ThisYearMonthEn d02 Feb
              ThisYearMonthEn d03 Mar ...
              See more | Go to post
              No activity results to display
              Show More
              Working...