Maybe skipwith has a table with dates stored in varchar (in the wrong format) and wants to change them into correct format in order to perform conversion into DATETIME and fill...

Still not sure I understand the question, but maybe this is it?

DECLARE @counter INT

SET @counter = 14

WHILE @counter < 700

BEGIN

    SET @counter= @counter+1

    INSERT INTO your_table group_id, section_value, aro_id

    SELECT '18', NULL, @counter

END

I suppose...

Hi Reet,

if you need some help with conversion error, you should post table DDL (definitions, best in CREATE TABLE statement) and some sample data on which we can reproduce the error.

BTW,...

Thanks for the replies, there is unique key for each row so I will consider that. I will not be writing the procedure myself, I just wanted to have some...

I would suggest to use a trigger, but since I still don't know much about how it should work, I'll show you a simplified one, without any validity checks etc. It works...

"That should be two tables, not three.."

Actually I think it should be 3 tables. One for computers, one for software, and one that says which SW is on which computer....

Hello,

what is the question, please?

As far as I can understand your explanation, I would probably go about it the other way... insert or update table2 and have a trigger that...

Hi,

SELECT * really is bad style, but there are places where it can help. I'm using it in one place only - we have some views that are basically reports,...

Now that's interesting... I didn't know about this behaviour, but you're right. The same happens when I try it on our server. I found something in BOL regarding use of...

mj,

may I ask why you decided not to check the data before insert? I know that life brings many situations not covered in books, but I still think that your...

If you want to be sure that no errors occur, the only way I know about is checking data before insert. You can not command SQL Server to insert some...

Thanks Rémi 🙂

That Ninja part is a new addition, isn't it? I didn't see your posts for a while though, so it may be some time since you've renamed yourself.

Oh, Department...

Hi,

please read this article, it is great and it will tell lots more than I'm able to post here as direct answer to your question. Hope it helps.. oh, and...

If you want to have all numbers positive, you can use ABS (<column&gt function. As to the rest, unfortunately I don't have time to analyze...

Populate textboxes? That's really strange, because it looks more like cost calculation... Are you sure this is the right trigger?

This trigger can do something, if rows are updated one by...