transformation to use ??

• bhavika.chauhan

  Mr or Mrs. 500

  Points: 523

  More actions

  April 16, 2011 at 12:29 am

  #145490

  Please help.

  I have to check this condition : (select count(distinct columnName) From tablename) > 1

  Which transformation should i use for it .

• Portes Ysaias

  SSCrazy

  Points: 2144

  More actions

  April 16, 2011 at 7:26 am

  #1312437

  Hi bhavika,

  First your T-SQL statement is wrong and your question does not explain exactly what you want to accomplish.

  Please elaborate a little more so we can understand your need and provide you with a solution.

  Ysaias Portes | Forward Thinkers Consulting
  sp_SQLFlightRecorder — open-source SQL Server diagnostic recorder | forwardthinkersconsulting.com

• Koen Verbeeck

  SSC Guru

  Points: 259215

  More actions

  April 18, 2011 at 12:04 am

  #1312602

  The answer has been given in the following thread:

  http://www.sqlservercentral.com/Forums/Topic1094054-148-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP