Problem!! Trying to create a table with various type fields....

• dnf999

  SSC Eights!

  Points: 870

  More actions

  February 22, 2007 at 7:25 am

  #153449

  Hi I have a table:

  Create table

  ( max_value nvarchar(50))

  Now I want to input all the max values within a particular column to this table.

  i.e insert into table

  select Max(column) from Table1

  my code runs it in a loop so it will put all max columns of a table into this field.

  My problem is I can have varying column types. i.e. Column with varchar, column with numeric, column with money.

  What can i assign the column Max_Value in my table to handle all of these different datatypes??

  The query can work, but produces an error when it gets to the money type columns

• Steve Fine

  Ten Centuries

  Points: 1134

  More actions

  February 22, 2007 at 7:54 am

  #691153

  Maybe too simple, but did you try this:

  insert into table

  select Max(cast(column as Varchar)) from Table1

• dnf999

  SSC Eights!

  Points: 870

  More actions

  February 22, 2007 at 8:17 am

  #691172

  Hi thanks!!

  I solved with:

  cast(max(['

  +@Column_Name+ ']) as varchar) as Max_Value

  Thanks!