You could also have the server spend the week-end with my parents. That would be a very fair test :D.

Isn't there a tool at redgate that does stres testing?...

That should help :

zip

ftp to sql server

unzip

run import.

I have a crappy computer here and an import like that wouldn't take more than a few seconds.

Just for the fun of...

How big is the file and how long does it take you?

How many columns and how much data do you have to process?

Where do I send my resume? I'd love to help out on that project.

Why "load it" in access since SQL Server is the data server in this case.

You can base any reports, diagramsor whatever you need from a query on that data on...

You seem to understand the question really well. Now I don't know if you know the correct answer tho :D.

BTW about 50% got it right, so it's definitly not...

and then ...look up books online in books online...

Sorry Gail, I know I'm not supposed to read your mind :D.

Hey Gail, I'm stuck in an environement like that where it was installed CS. Have you found any advantages of using CS collation?

something like sp_msforeachdb?

Well you actually get paid for that... you used to anyways.

I'm sure you can trade in for a shirt :D.

You better drink it then, I'm not into alcool all that much.

Thanks for the thoughts. 😛

You need to put a prefix in front of the function (sorry I don't remember it).

It's like Code.FunctionName (parameters, go, here).

Again F1 with keyword search function should lead you to...

I don't have RS in front of me but I can guide you...

open up the report in design view.

Then right click somewhere in or under the report where there's no...

Yup, Steve loves to give stuff away... he probably will do it if you ask him nicely.

the problem is that everything gets evaluated before the iff is executed... hence the error.

You need to create a function in the code pane with 3 parameters (numerator, denominator, valueifzero).

Then...