One option may be to store the timecolumn as an int.

The 'square' mark you're talking about is most likely some end-of-row unprintable charachter. Make sure that EOL tokens are what you...

Yes, it is faster, though fn_basetodec has another feature - you enter the base as a parameter (2-36)

So you can use it for different situations, like

select  dbo.fn_basetodec('100000110001011100001010110110010010101100', 2),...

1.) Can you explain more about the specific situation? I don't see how the term 'audit trail' relates to 'transaction'... You can read about save points (what they are and...

I guess this is what you want?

select dbo.fn_basetodec('653D0A', 16)

--------------------

6634762

(1 row(s) affected)

The function is from SQL Server Magazine June 2005 by Itzik. The neat thing is...

Why not try to do this auditing the 'proper' way..?

I assume that you want to audit a bunch of tables, correct? A trigger is a part of a table, so...

Well, I guess that you've already realized that 'the easy' way to merge (which I assume in this case means to add the sites column to the 1st query results)...

Maybe. I noticed the similarity as well

/Kenneth

Here's something I had lying in a dark corner that may be of some help.

The general rule to use rand to generate random numbers from <lower limit> to <upper limit>...

Seems like a very typical manager request then... I only wonder how the manager thinks it would be possible to check for quality when the data retrieved is unknown..? (since...

Nope, no analysis. But it's not particularly random, though it may be good enough depending on your purpose.

For the most cases, NEWID() works better for generating random stuff. But, it...

Whenever I get this message, it's because of one of three things:

1) The path/filename is incorrect (check your typing / spelling)

2) The file does not exist. (make sure the file is...

You can't do this from within a proc - simple as that (unfortunately)

The one and only place to grab the complete errormessagetext for...

What is 'sale person' here? Is it the ID of the salesperson or the amount sold?

Care to explain a bit on why you need 2 of each grouping? Is it...

There is only one place where you can get the complete errormessages, and that's at the other end of the connection calling the procedure. (eg the client)

You cannot trap complete...

Check the owner of TOEROK and change your query to:

UPDATE ventven

   SET priori = toer

   FROM <tableowner>.TOEROK INNER JOIN <tableowner>.ventven

      ON nomat = ship

      WHERE codaff in ('tale','talk','tbre','tdle','tdlk','tdpe','tele','tepe')

..perhaps...