[font="Verdana"]How's your CV/Resume looking?[/font]

[font="Verdana"]...except for Gail. :D[/font]

[font="Verdana"]Frankly, if I were interviewing you, I would keep asking questions until I found something you didn't know about. Then I...

[font="Verdana"]I'm tempted to just tell you to rewrite your solution without using a trigger. A gateway procedure is a better design, and has less performance issues. However... ...

AnzioBake (10/23/2008)

---

Is this not a very Hard coded solution for the particular example that was given.

Surely the more generic solution is not much more difficult and should be the prefered...

[font="Verdana"]I'm not sure what you mean by "BI". However, I suggest you take a look at SQL Server Books Online, and look at the following topics:

Backup

Restore

Database Mirroring

Database Log Shipping

Replication

Good...

[font="Verdana"]The dbo.date_format() function you are calling is not (so far as I know) a standard piece of SQL Server functionality. It looks like a function that someone has developed...

[font="Verdana"]

Your trigger code contains statements like:

SET @CurrMonth = (Select ReportMonth from INSERTED)

But the INSERTED (and DELETED) pseudo-tables can contain more than one row. So when you try to do...

[font="Verdana"]Wow. Do people actually write code that way? Who knew.

Okay, for coding styles, an excellent reference is Code Complete, by Steve McConnell. Look under section 7: High-Quality...

[font="Verdana"]Try something like:

select date1,

comments,

case

...

[font="Verdana"]Oh, the same one you use when you discover that the DBA hasn't tested the backups.

Didn't...

[font="Verdana"]No. I was asking for the impossible, not the implausible.[/font]

[font="Verdana"]Winks turning up in the code? I think the combination of tab-close bracket does it. I've started replacing tab characters in my posted code with spaces. That...

[font="Verdana"]It's a type clash between the char(5) for solution_cde and the tinyint for app_sys_group_cde. You need to cast all of the columns that are going to be listed to...

[font="Verdana"]I think you actually want to unpivot your data, rather than pivot it. It's already pivoted. So you would end up with something like this:

select row_num, [col_name], col_value

from...