Hi Luis

I am going to read and inwardly digest Jeff Moden's Spackle article[/url] that you is linked to in the thread you pointed to, and see if that suggests anything.

Many...

Man, it worked. I could have sworn I'd already tried that.

A slight twist though, and an extra confusing factor - the original file was actually Unix format, with only line-feed-terminated...

Hi experts

Here is the complete test table definition with primary key and enhanced data. I have replicated the existing patients twice but with new IDs (starting with a Q or...

Yes, that's absolutely right. I need to add some cases to the test data.

Sorry for not replying earlier, but...

In response to John Mitchell,

There are multiple records for each PatientID, each covering a separate date range. (We know that the date ranges can never overlap, though they will...

Dear experts

Here are the records I would expect a working query to return, highlighted in bold. I am taking an As At date of the 1st of June 2015 (2015-06-01):

PatientID...

Hi experts

To answer Kevin's question, the table I am getting the data from is a read-only view maintained by another team and originating from a non-relational database of doubtful integrity!...

Hi guys,

Thanks for the replies so far.

I obviously need to brush up my approach to asking questions! Here therefore is some DDL for a test table (thanks to Jeff...

Hello Gail

Just got an email from the DBA saying that he had shrunk the DB as a maintenance measure after rebuilding the indexes. I thought - based purely on what...

Re possible duplication of effort, I am co-ordinating with the DBA, who has just taken over the management of the DB. (I am more of an applications person, though I...

Hello Gail

Hmm, fair enough. I forgot to mention that the database in question only has simple logging enabled, so elapsed time since previous log backup shouldn't be an issue.

I have...

Hi Andrew

Thanks for the quick response, and sorry about being a bit sketchy on the details. You guessed absolutely right, though. I had a feeling CTEs would come into the...

Bill Talada (8/29/2014)

---

The parser is very forgiving of formatting. If you think of 4-part names as each part being independent and as overriding a default scope, it will make...

Hello John

You're right, it does work. To my mind, it oughtn't to, though. The parser should throw out the "dbo. " as an incomplete name.

Makes me nervous when stuff like...

IMHO The immediate visual effect is clean and fresh. Putting the above mentioned improvements in would make a good thing better though.

The exercise, I suppose, is to maximize the total...