Here is a little example that might help...

-- Show sample time data 

Select Time,  

DateDiff(HH, '1/1/00', Time) % 24 as TheHours,  

DateDiff(n, '1/1/00',...

Something like...

 

CREATE PROCEDURE IntoTest 

(@myDate DATETIME = NULL, 

 @myInt  INT = 3, 

 @myStr  VARCHAR(30) = 'hello')  

AS 

INSERT INTO...

Something like...

Exec ('master.dbo.xp_cmdshell ''BCP ' + db_name(db_id()) + '..' + @TBName + ' OUT "' + @OutPutFile + '" -c -S"' + @@Servername + '" -a32768 -T...

Thanks Jonathan,

I'll look into deeper on Monday,

but 1 question: Any particular reason you used Char(16) instead of VarChar(16)?

On the Hand Held Computer display, the end user should see "8% Sales Tax" or "6.5% Sales Tax". Customer does not want to see "8.00000% Sales Tax". Some taxes may...

Understood.

Thanks

I'm just curious, but if your SP did a Dynamic SQL (EXEC) with variables all replaced with constants, would your code run in the faster 2 min. time frame?

...

If Object_ID('TempDb..#Temp') is not NULL Drop Table #Temp

Or in some cases...

If Object_ID('TempDb..#Temp') is not NULL Exec ('Drop Table #Temp')

It was bugging me, so I dug around a little...

It was VSLive Orlando 2002, Kimberly Trip's "Designing for Performance" session...

The Data Row:

4 Byte Header +

Sum of...

Way back, I remember being told that SQL Server will physically reorder the columns, having the fixed length columns first, then the variable length ones. (SQL Server Conf. in Orlando...

Thanks, I'll wait a couple/few days, and see if I get responses... if not, then maybe I'll put a link into the other forum.

Depending on how long your log data is, you could save the logging data to a local string or output to a text file, then after the rollback, repopulate the...

If you just need info on CR or CRLF,

then maybe something like:

SET @NewString = @Str1 + Char(13) + Char(10) + @Str2