HI Anders Pedersen 

Is the developer edition really as cheap as $49.95???

Would this be the correct version that...

Well I just want to incoporate it into a procedure so that the temp tables are dropped to ensure that there is enough space in the tempdb.

I deal with basic...

Well to be honest I don't need to drop them.  I'm just being a bit anal when users are creating temp tables...

Still,  I always try and like my code to...

Hi Gene

Thanks for the reply none the less.  I believe that full-text search has the capability to search within docs, but I'm unsure how user friendly this is!!

how do you...

Thanks that's great help. I'm trying to write a cursor to drop all my temp tables but as the table name is like #<Tablename>____________________________________________________000000258

it will not drop.  Any idea's how...

Thanks for all your help.

Was just wondering if there was a 'magic' way to do fuzzy searches without the use of dictionaries.  To an extent I guess not.

Cheers

Excellent, is this the same for SQL Server 2005?

I know you have to download a free kit from the Microsoft site, but I can't download at the mo.....

Cheers I managed to get it working by changing the table nvarchar types to varchar.

Quite a useful SP if you need to audit a table.

FYI code i used:

CREATE PROC...

Hi thanks!!

I solved with:

cast(max(['

+@Column_Name+ ']) as varchar) as Max_Value

Thanks!

Thanks Chuck and Malcolm that works a treat.

I'm trying to add more columns to the table to audit other criteria, but am having problems thinking of how to...

Thanks for those suggestions guys.

Chuck Rivel, I do not understand why the Blank_Quantity will either be a 1 or 0?

If I hard-code the statement:

select sum(case when Column1 is not null...

Thanks for all you suggestions guys!!  I've been playing around and nearly there, should be fine for tonight.

Cheers!!

Hi I managed to sort this.

Basically as the default precision for numeric is (18,0)  I increased it to (20,0) due to the high values in my data.  That solved it.

I...

Excel Spreadsheet, as this is the best way to present the data to the client.

Thanks

Hi Sergiy,

I want everything to be done through SQL and result in an Excel file.  Not from Excel connecting to SQL Server.

Thanks