yeah i was totally qualfied up until that;

another victim of "you are too...

i love to help those who help themselves;

it looks like Chris@home spent a lot of time writing code and helping you out there in the other thread, but i don't...

this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and folders,xp_cmdshell,bcp with a "trusted"...

i'm in the US, but i ordered my from amazon for ~$44 USD;

is it available on amazon.uk? (blocked at my job: no shopping allowed)

i think you just want the items where the modulous of year(getdate) - year(EecDateOfSeniority) is zero;

something like this:

with OneSample

AS

(

SELECT CONVERT(datetime,'12/30/2007') As EecDateOfSeniority UNION ALL

SELECT CONVERT(datetime,'12/30/2004') As EecDateOfSeniority ...

well the error you posted is related to NET SEND, and not database mail;

i think your mixing the two up a little bit, and

that NET SEND should...

i was under teh impression that NET SEND doesn't exist on vista or windows 7 machines; could that be the problem?

http://superuser.com/questions/38967/how-do-i-get-the-net-send-messenger-service-working-on-windows-7

sure!

parsename is just a handy built in function. built in functions will almost always perform better than code you build yourself, so if i can squeeze data into it's expected...

looks to me like you'll need 200 update statements, one for each possibility: otherwise you end up with unintended updates.

UPDATE SOMETABLE

SET ABCField =

CASE

WHEN Field1 = '2012' THEN 'Y'

ELSE...

excellent job providing the consumable DDL and insert statements!

Thank you!

here's a neat trick that might not work, depending on your data;

it looks like comma separated, always 4 values, and the...

here's one way to do it:

create a scheduled job that runs every day, but only does real work when the dates match the last day of the month:

here's the formula,...

if you renamed your server at the operating system level, the SQL server might still be remembering the old name;

this is how you fix it:

sp_dropserver 'old server name'

sp_addserver 'new...

yeah the MyPosts link is limited to 150, and i'm pretty sure it's not even in the posted order, either.

I'm 8000+ posts deep, and when i need to recover a...

i'm getting closer:

this query shows me my permissions, as well as the permissions i directly inherit from roles i've been assigned;

it does not handle any recursive role-within-a-role yet;

i'm thinking that's...

ok a follow up to my own question:

in SQL2005,

SELECT * FROM fn_my_permissions(NULL,'DATABASE') for my example above only shows connect permission, but on SQL2008 and above, it shows the "VIEW...