Probably, I'd...

Koen Verbeeck (5/16/2012)

---

Lynn is right. You need to open the advanced editor of the source component and set the IsSorted property to TRUE. Then you have to indicate which columns...

Koen Verbeeck (5/16/2012)

---

MisLead (5/16/2012)

---

Lynn,

Actually I...

Sounds like parameter sniffing. I don't have the links handy, so you will need to try searching this site with those keywords. Or, hopefully, someone with the links...

You actually need to use a left outer join and deal with a null value. It would help if you could post the CREATE TABLE statement, some sample data...

I'd still use the TIME data type. If you do have hours that go from 20:00 to 05:00, I would deal with that in code. If all you...

Here is my solution. Give it a test. Oh, with the values given by the OP, I get 12:03 not 12:07.

DECLARE @StartDate DATETIME,

...

megan_c99 (5/16/2012)

---

Hi,

I'm working on a project that requires us to store an employee's work schedule.

For example our company allows the following work schedules:

8:00 a.m. to 5:00 p.m.

8:30 a.m....

CELKO (5/16/2012)

---

>> Once again, you and your high horse ride in. <<

Gee, ANSI/ISO Standards, etc are "high horse" to you? Does that say a lot about your professionalism and expertise...

Once you have the elpased time in minutes, the following will format it to HH:MM. This code assumes a positive elpased time. If the computation can go backwards,...

TravisDBA (5/16/2012)

---

Lynn Pettis (5/16/2012)

---

TravisDBA (5/16/2012)

---

Scrums are silly IMHO. People with health, foot or leg issues, or disabilites for that matter, should not be be told or forced to stand in...

TravisDBA (5/16/2012)

---

Scrums are silly IMHO. People with health, foot or leg issues, or disabilites for that matter, should not be be told or forced to stand in scrum meetings. That's...

saidapurs (5/16/2012)

---

Hi Brandie,

I apriciate your responce & i agree with you but issue is i am not yet wrote any SP in my life. so while...

james.jensen1350 (5/16/2012)

---

Thanks for the reply Lynn. I tried that and id did not work.

However, I did just now try a FULL OUTER join and moved the condition in the...

james.jensen1350 (5/16/2012)

---

I have two tables:

t1 (dow smallint)

t2 (custId int, dow smallint, data1 varchar(128), data2 float)

I then insert 7 records into t1, one for each day of the week (1-7).

Now, I...