I agree. I hardly ever use object explorer to find objects. It probably would be nice to have SQL Search, but I don't.

Instead, years ago I built a...

I'm sure there's other ways, but here's what first came to mind:

create table #Appointment (AppStartDate datetime, AppEndDate datetime)

insert into #Appointment values('1/1/2014 8:30am', '1/1/2014 9:45 am')

select

*,

floor((CONVERT(float, AppEndDate) - CONVERT(float, AppStartDate))...

You can still use either suggestion above by feeding them a work table instead:

select Subject, sum(Mark) Mark

into table2

from table1

group by Subject

-- now you can use table2 wherever you saw...

This is terrible of me to butt in. Jeff can correct me...

"Why Refills table should not have CustId from customer table"

Indeed: On the Refill table, put PrescriptionID in and...

Jeff or Paul:

I didn't see the source code for the CLR function. I also didn't read all 473 posts before mine, so maybe there's a link to it somewhere..

Paul,...

In line with that issue, are there tools out there to write Apect Oriented Procedures?

jddddd2,

Just happens for my case that if the row is different, the newest row is plastered onto the other copy. But you're right...if the requirements need to look at...

So, the answer would be, "try reinstalling it". It worked the second time..go figure

wonderful. Thanks!

Thanks everyone!

RBarry says "Varchars only store that space that you are actually using"

but

Jeffrey says "whatever size you allow is the size that is going to be used"

Could I have some clarification?

Thanks.

I've meticulously tried to get my varchars to match what I expect the data to look like. I'll now just set everything to 8000 and save myself a few...

In the case where there's no unique ID, I would think another option would be

select distinct * from Employee

into EmployeeCopy

Since I'm typing this before I've had coffee, it could be...