Operating System error (5) access denied is the result of using sp_attach_db 'path to visual studio project'.

I removed all the read only files and folders along that path but became...

Did not think to do it. let me try...

I installed Sql server 2012 smss before I installed sql server 2012 express and had no problems.:-) Rousseau10

Working on an MVC 4 and MVC4 mobile project.

I ask because I only want to put sql 2012 express with management studio express on a dev machine, but want it...

SSCrazy Eights. Wow, I knew there had to be a solution, and Patrick I am still gonna run your code to check it out!:-D:cool:

great resource. Working with it now! Seems just what I was looking 4.Thanks!!

Can you help me using a CTE?, I am trying to understand what their purpose is exactly and how and when to use them

I tried distinct to no avail. Yes it is a 1 tomany relationship, so how can I just add column b.submissionbatch so my result without the records going up.

Is there...

I already finished that assignment before I saw the replies. Thank you very much. I did read and understand the suggestions and will come back to it on my next...

Yes thelast 2 both worked both worked! thanks so much. It seems like no matter have much I learn, there is still so much about tsql I do not know....

did not your code above will try it!

my boss says i am filtering wrong and needs to be done today. naturally he will only point at the flaws in the...

below wont work.

select * from dbo.tblDM_AuditEncounter

where DM_AuditNurseID =

case when 7

then year(AE_AuditDate) = 2011

else

then year(AE_AEncounter date) = 2010

end

I just need the syntax to not gove me an error. the ddl is in a temp table

I still need to narrow it so it gives me 25 distinct gmpis (i have dups). I got excited a little bit too soon, I tried distinct after both selects...

Jason,

I want to shoot myself, before I started this I new I would may need

ROW_NUMBER() OVER (PARTITION BY ae.DM_AuditNurseID ORDER BY ae.GMPI) AS Row_Counter .

But when I started getting...