T-SQL Tuesday #22 Data Presentation

T-SQL Tuesday #22 Data Presentation

This month’s TSQL Tuesday topic: Data Presentation. I am not going to show any code this month, and I am also going to veer off the topic of SQL server slightly. My company does a lot of reporting though Cognos.  The nice thing about Cognos is that it is platform independent.  Once a connection is [Keep reading…]

UDA-SQL-0283 Metadata describing column does not match results from database

In my current job, I have a MySQL database server that I am responsible for.  We also run some reporting through Cognos against this server.  I ran across a problem while testing reports on an upgrade to Cognos 10.  I thought I would share the solution here in case it helps someone else out someday. [Keep reading…]