Please do this! I am really interested as I'm going to get .Net real soon and dynamic sql is one of my favorite topics.

Honestly, I only wanted to make sure, because here we also have XXX Edition on a multi-processor machine. I was only unsure as to the number of processors.

...smart, good looking, joking, ready for the weekend???

I'm not good at self studying. I learn most effectively when presented to a problem. That's why I like answering questions here. While this certainly adds experience, I can't put...

Sorry, yesterday evening posted the wrong thread title. I meant this one here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=13473

Yes, are you still busy playing the game I sent you last time

Not really. In the end they shot themselves in the foot. Here we have a somewhat great deal. The company pays and you do learn in your spare time and...

Hey Andy,

this is the test post with Opera.

Seems to work.

Dave, you mean

;o

Something like this ?

use pubs

go

select

au_fname

from

(select top 1

*

from

authors) a

au_fname

--------------------

Abraham

(1 row(s) affected)

Theory and practice sometimes differ

>...looking pretty in the >mean time, though they seem to manage the latter with ease.

3 out of 4 isn't...

I would say the effect should be none as Standard Edition can only use up to 2 GB of RAM

(a) Take a look at sp_password.

(b) None that I'm aware of.

Du kannst das in der Onlinedokumentation unter Systemadministrator, Kennwörter nachlesen

That's what I actually did. Looking at BOL for Maximum Capacity Specifications for processors and RAM and guessed right

Is there a reason why the HR department should be involved?

Just curious.

That's what I meant. Splitting *should* not be necessary and what is the error message you're getting when you place all in one string?