Posts by Iago Gomes • 3 points

• 0

  votes

  2

  answers

  79

  views

  A: Pivot with Temporary Table

  I was able to solve the problem through the following script: SELECT DISTINCT MAX(pivot_table.TCK_SEQUENCIAL) AS TCK_SEQUENCIAL, MAX([1]) AS CAT_NUMERO_1, MAX([2]) AS CAT_NUMERO_2, MAX([3]) AS…

  sql pivot

  answered 5 years, 2 months ago Iago Gomes 3

• 0

  votes

  2

  answers

  79

  views

  Q: Pivot with Temporary Table

  Hello. I am building a query where I need to use pivot to analyze the results, but it does not return the necessary data. Original table: select * from tbCampoAdicionalTicket where TCK_SEQUENCIAL =…

  sql pivot

  asked 5 years, 2 months ago Iago Gomes 3