Eric, thanks for the reply - I get that, the tool isn't the deciding factor, or where most of the time should be spent. I chose to go with SSIS, because...

This seems like the good case for the PIVOT expression. How far away is the below example? I've assumed "tbl_lookup" = "tbl_time" in your above example.

IF...

Thanks xsevensinzx, Jeff and Chris. I appreciate the confirmation there's nothing obviously wrong with the data placement in the diagram above, besides the lack of detail. I was being asked...

This is a controversial subject - the term for the structure is "One-True-Lookup-Table" (OTLT). It's a valid model, but I'm confident it's not the enterprise-grade best-practice it might look like.

Hi pamenta,

You say the query should bring up all names that match "a criteria entered on a screen"; what do you mean by this? Is this query being...

I believe you'd want to use windowing functions for this. Here's an example:

declare @temptable table(
     eventdate date
)
insert into @temptable(eventdate)
select '20150101'
union all select...

You're missing an "i" in rx.positive.

Also, your CASE statements should be returning 0 or 1 as integers (without the single quotes, which is identifying them as strings...

Here's a quick attempt at doing what I think you're after - does this do as expected?
select
    mytable.ID
    , mytable.date
    , mytable.[field 1]
   ...

Here's code that I think would do the trick, you would get better performance using windowing functions to do this, but my head's not in the game for that right...

Hi gary1, that schedule looks good to me. Is there any history being logged for the SQL Server Agent job? If not, is the SQL Server Agent started? If it...

pietlinden (12/20/2016)

---

To what entity to the e-mail, address, and phone number belong? Presumably a person. A student? They certainly don't look like they belong in the Fact table...