i have written some code to help developers spend less time on scripting basic statements.

the first link is a demonstration of this:

http://www.sqlservercentral.com/scripts/AutoGenerate/65042/

the second one is the actual code that uses...

to apply this script to every database on the server try using this and modify the script as appropriate:

http://www.sqlservercentral.com/scripts/Metadata/65453/

will do so in the new year

Hi jim

u should find the find number stored procedure in the master table

try this:

use master

findnumber '%123456%'

i am not sure what you mean in the second part of your question.

Thanks

Chris

i have another methodology for that one. i will submit it soon as i get back to work.

thanks thats a useful technique!

Thanks for the suggestions. i am actually not that experienced in sql and your suggestions have helped me advance my skill. thanks. also please see the post about the temporary...

perhaps your particular login does not have permissions top create temp tables. instead of using #sp create a table perhaps to accomodate the contents of #sp and modify the code...

hi guys/girls

try this as an alternative as well

http://www.sqlservercentral.com/scripts/AutoGenerate++++++parameters/64760/

cheers

chris

this is super simple method of getting the same results:

SELECT * from customer order by newid()

ok that sound good. will try that.

Thanks

please refer to

http://www.sqlservercentral.com/scripts/AutoGenerate++++++parameters/64760/

for an updated version

unfortunately at the time i published this article the data was truncated when i submitted it. unfortunately that stuff is long gone.

basically it worked like this:

i had a table that...

Hi

Thanks for your reply

to satisfy your curiousity this is displayed in a web application, BUT, the clients also include windows mobile apps and windows apps.

the datagrid that displays this data...

i have a similar question posted here: http://www.sqlservercentral.com/Forums/Topic585344-145-1.aspx

i am strugling with the exact same question which is what i have paraphrased how to use table data as column names.

if you...