I solved it. I used your code with a cursor. That way I was able to loop through the column names.

Thanks

ok. That works, but I want to get a specific column name, not all the columns....

Well, one of table has around that many columns. I have not designed the database.

I will give it a try when I get back to work tomorrow.

Thanks.

I used "1/1/1900", maybe it only accepts single quotes then. I'll give it a try. Thanks.

Yes, you are correct.

This is what I have and it seems to work like I want it too.

Thanks.

DECLARE c_keys CURSOR FOR

SELECT DISTINCT

...

Ignore my question. It's Monday and I apparently did not get enough sleep.....

Turns out that the table where I am logging to don't accept nulls 🙂

The problem I have with some of these solutions is that they save it as xml. We need to be able to create reports later on in Crystal or SSRS...

Yes, that's what I thought. I now have a table with the next batch id. This seems to work.

Thanks guys.

Thanks.

So if I have a seperate table which contains one thing, batch id.

I then write a function to retreive this batch id, but how do I update the batch id...

I am not sure I understand this code at all. Is this just a template of some kind? Don't you need the IF UPDATE(column_name) ??

create table #Inserted (

ID int...

That is why I turned to this forum for answers.

My experience with this is very limited. I mainly only do Java code 😛 You can probably pick that up...

Thanks. Just what I thought.

Is there a way to format this better? The generated trigger looks ugly to say the least.

Here is a generated trigger:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER TRIGGER [TRG_author] ON [dbo].[author] AFTER...

I have to create a trigger for 9 tables. So, depending on how many columns each table has, it would be a nightmare to write.

Thank you for your answer.

This is what I came up with (Keep in mind that this is the first time I write T-SQL)

All I am missing now is how to...