One thing with convert is it does do an extra read but only one to get the format from the syslanguages table if I remember correctly.

But unless you freed the...

Don't believe there is but for a file that might be corrupt you can stop SQL Server, rename the log files extension to like .old from .ldf then restart SQL,...

I suggest you first take a look at the database design and normalize it first. Then recheck the application and correct for knonw performance issues. Then spec out what you...

Alright maybe it is me but it looks like you are going out of your way to do this

replace(convert(char(10),dateadd(d,-7,@date),102),'.','-')

or

convert(char(10),dateadd(d,-7,@date),120)

in your function.

and if you are wanting to be able to adjust...

I think I know you good enough to read here between the lines.

Yeah, best part for me has been the recent change from...

You poor recheted fool... What have you done?

You know it is all your fault from now on and you will never undertsand anything ever again as far as they will...

Glad someone posted that Microsoft link as I couldn't find to save me. The statement about TempDB is incorrect with Tbale Variables see the following.

Q4: Are table variables memory-only structures...

Of the ones I listed, the 2 XP desktops are used everyday by me or rest of the family. The XP HE laptop is the wifes and is used everyday...

FYI this is from the last BOL Update

CREATE PROCEDURE

"All data types, except the table data type, can be used as a parameter for a stored procedure."

You might want to try DBCC UPDATEUSAGE and sp_updatestats.

In addition you might want to run a DBCC CHECKTABLE and or DBCC CHECKDB to see if their may be any reports...

I think the biggest reason user groups die quickly after starting so greatly is the amoutn of time people have to give up in order to participate. They have to...

Unless things are singular values which you could pass with OUTPUT parameters from your sub procedures you will likely have to use a temp table which you can execut the...

Ok here goes

1 Windows XP HE Laptop

1 Very dead XP Pro Laptop (laptops don't like coke)

2 Windows XP HE Desktop

1 Windows XP Pro Desktop

1 Multiboot Windows 98SE, Red Hat Linux...

SQL Mail requires a mapi client such as Outlook.

1) Sorry brain is working backwards today that is the third time and I usually follow the rules well.

2) Ok

3-4) Thanks.

5) So how do you id which branch or branches...