Keep in mind that there's another trick, which doesn't include cut or paste.

Type in

Select * from Mytable

highlight the above, then right-click and "Design query in editor". Click Ok...

ALZDBA (4/1/2008)

---

Indeed, changes to the underlying table's column order will make a bitmapped trigger buggy, and there is no way you can avoid it becomming buggy ...

Best is to seal...

matt stockham (4/2/2008)

---

My (limited) understanding was that the NS functionality was going to be moved into Reporting services. Whether that functionality changes or requires a different edition I couldn't...

J -

Note...

Lisa Slater Nicholls (4/5/2007)

---

hi Kathleen,

I'm not from MS and this comment isn't specifically about your licensing structure... but...

>>

I was on an interview recently and talked about our report solution...

It's just a tad bit messy. Performance issue prone from what I can see. It evokes building Excel files from macros, etc.... Hard to troubleshoot, etc...

I guess...

before you go singing my praises -

Sadly - the definition of Proper case IS "every word starts with upper case letter, and then lower case". So - it's...

(shiver)

Did someone...

Here you go:

SET NOCOUNT ON...

Marios Philippopoulos (4/2/2008)

---

The interesting thing I saw was that in .NET - PI() is a constant, whereas PI() in T-SQL is a non-precise function, and POWER() seems to suck as...

Try using the new ROW_NUMBER() feature

;with PatientvisitCTE as (

select appointmentID,

pt_id,...

No problem - but I guess I need to stay impartial in my "referee" role. That was your "free...

The inner query is missing a FROM, and the group by would need to move into it. You should then make it a derived table and move it to...

Jack -

I'm hoping you're not including SSNS in the list? 'cause Notification services is going the way of the Dodo bird.... And that's not just from Standard...

Look at the scripting options - a lot of that "junk" you mention can be turned off. Of course - as has been mentioned - not all of it...