They demonstrate that someone has passed the exam, and that they actually bothered to do it. That's worth something to some people.

I think it's valuable when I'm looking through...

True... books can be good. But I see lots of people stress out totally about doing exams. They should just try them and see how they go. Most people who...

My big exam tip is to just try it. The exams are designed to test what you know as part of your job, not what you can learn in books....

Just specify it as a string, like this:

Insert into EmailList

Select Name,date,emailaddress,'BVC_User' as TableName

from BVC_user

UNION ALL

Select Name,date,emailaddress,'GFD_User' as TableName

from GFD_user

UNION ALL

Select Name,date,emailaddress,'TRE_User' as TableName

from TRE_user

Hope this helps...

I like the OVER clause for this type of problem.

select * from

(SELECT *, RANK(PARTITION BY PUP_UPN_DFEE ORDER BY PUP_UPN_DFEE, PAT_TO_DATE DESC) as rn

FROM TableName

) t

where rn = 1

Or you...

Do what David has recommend, use sp_executesql and pass in the value as a parameter.

The fundamental problem here is that you're passing in data which you then execute, so you're...

Or store the last time you checked somewhere. Perhaps make it a table-returning function instead, so that you can throw in a little more functionality. After all, a view isn't...

Your 'post_date' field will include a time component too. So really you want to group by dateadd(day,0,datediff(day,0,post_date)) (which is a simple way of truncating the time - counts the number...

More on primes at:

http://blogs.technet.com/wardpond/archive/2006/09/23/458344.aspx

http://blogs.technet.com/wardpond/archive/2006/09/23/458580.aspx

http://sqlblog.com/blogs/hugo_kornelis/archive/2006/09/23/Prime_numbers.aspx

http://sqlblog.com/blogs/hugo_kornelis/archive/2006/09/23/Prime_numbers.aspx#comments

And of course, at my _old_ blog at:

http://robfarley.blogspot.com/2006/09/primes.html

http://robfarley.blogspot.com/2006/09/more-on-primes.html

All lots of fun...

It's not something I would ever suggest someone really relied upon - but in a scenario, SQL will always go through the select clause one by one.

Of course, the way...

It's not a Microsoft thing, and you don't need to analyze and manipulate bits or anything like that - it's just one of the lesser-known features of the XOR function....

This is that old 'in place swap' routine provided by XOR.

Thanks everyone. It's funny - when there was another article about ownership chaining just last week, I assumed they wouldn't run mine.

I'm pleased...

But... this is something that doesn't involve spending my budget of one person. I think the most effective 'help' isn't a full-time person.

To use a person who was full-time, I...

I think a life-coach would be really useful. Someone who can help me keep accountable for taking the next step towards the goals I want to achieve. In fact, I'm...