Wayne!  Were you changing data in EM??? 

 Jamie,

I knew I had this somewhere in my notes, and I found it this a.m.  Current Date should be CTRL-SemiColon; Current Time is CTRL-Shift-SemiColon (a.k.a. CTRL-Colon).  At least, these...

Jamie,

I knew I had this somewhere in my notes, and I found it this a.m.  Current Date should be CTRL-SemiColon; Current Time is CTRL-Shift-SemiColon (a.k.a. CTRL-Colon). 

HTH - Linda

Brenna, try

SET @strSQL = @strSQL + ' DateDiff(d,CS.AdmSrvDate, + GetDate() + )'

Just a couple less single quotes.

HTH

Hello, ISHANN99:

With update portion included:

create table tableB (Fullname varchar (50))

insert tableB values ('John Brown')

insert tableB  values ('Chris Smith')

insert tableB  values ('P De Souza')

insert tableB  values ('P De Silva')

create table tableA...

Frank, I'm here every single day, Monday through Friday. This well-run forum has been an excellent resource for developing my SQL Server DBA skills. I would like to say...

#1 for sure.

Thank you for your response, Niko. In the interim I discovered the system db's (duh! Must have been blind the day I posted that question...). I posted in the Yukon...

I have Beta 2.  So EM is available in Beta 3, I suppose?  Thank you for the reply, Jamie!

OK, as of 9:15 a.m. today in sunny California, there are 30 views on my question but no replies!  Come on, SOMEONE must have some...

First point, quite right.  It's more a concern of so many "layers" of different views being more difficult to maintain when structure changes occur, as opposed to maintaining a function...

Thank you, michanne.  Since my initial post I've been doing some benchmarking and unfortunately the view is still much faster than the identical rowset acheived using a function.  Oh well,...

Many thanks, Nikop!

Thank you Dave, that helpful link answered the rest of my questions.  I browse this forum all the time but that was one I happened to miss.

Thanks PW, good info!