To be honest it depends on alot of things. The size of your operation is a concern, some tools are great for a small desk, but lack the functionality a...

Well, i don't need to know for this implementation, but i'm very interested for my personal knowledge.

Thanks.

Hey Jeff,

Luckily, i only ever add one row at a time... which as i type it sounds a little RBAR... but that's how i'm fed the data.

ps: love the...

Ok, i do laugh at myself sometimes.... 😀

so, the trigger was calling it

exec @NewIP = dbo.sp_Woodside_String_IP_Selection_V1 @IP, @NewIP = @test-2 OUTPUT

When Ian did point out i should...

Returns need to be an INT, that's why i got the conversion error. So i must be doing that wrong...

Changed the returns to selects and it works in the query...

lol at me changing the the name of the sp in the first code block and not the second one... *sigh*.

anyways, i noted that i should have an OUTPUT in...

good question! i recall them adding some new functionality to convert in 2k8 but had to research what that was 🙂

great question today 🙂

i went right ahead and clicked 4... then read the question again... "active"... d'oh.

There are hundreds of statements you could cut...

yikes... i chose error while truncating due to the fact the table wasn't named correctly in the truncate statement....

:hehe:

are you running an application from this DB?

i'd exercise caution before changing a collation from case insensitive... (if your Oracle was indeed case sensitive then there should not be an...

Hugo Kornelis, you are a ninja!

i feel like i learned something now 🙂

i was pretty confused by the question, and even the explanation of why i got it wrong, but...

so, does the transaction actually run and get rolled back?

could you:

SELECT top(1) [ACTIVITIES.StartDateTime]

,ACTIVITIES.CategoryId

,ACTIVITIES.Id

FROM [Activities]

order by [ACTIVITIES.StartDateTime] desc

?

This may be a silly question, but if you have access to Active directory, couldn't you get the username directly?

sAMAccountName...

I'm just thinking is someone has a different logon to their...