Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition to the desired output. I think in this...

Ed Wagner (5/29/2015)

---

Sean Lange (5/29/2015)

---

No offense but if your view is like the pseudocode below your issue is only beginning. The performance...

No offense but if your view is like the pseudocode below your issue is only beginning. The performance of this kind of...

TJT (5/29/2015)

---

Hi,

I created a new View using some other Views.

The new View works, but if I try and use a WHERE clause - it just ignores it.

Can someone explain...

Be careful using hour. If the start minute is 59 and the end minute...

On my system I have the cteTally as a view so I can generate up to 10,000 rows with zero reads. It is crazy fast and super flexible.

The issue with...

sarath.tata (5/29/2015)

---

I am trying to generate dates for a roster dynamically in a stored procedure. If my start date is '01/01/2015', end date is '12/31/2015', I should generate dates...

When you want to do math on date or datetime you should use DATEADD. When you want to check the difference between two date or datetimes you should use DATEDIFF....

pspkshah (5/29/2015)

---

Hello friends,

how can I get time difference of the following record please help,

STARTTIME ENDTIME

3:30 PM ...

Any chance you can upload the actual execution plan instead of the estimated one?

So...

mataleao87 (5/28/2015)

---

Hello Masters of SQL,

I have a very bad issue here and I don't know what to make of it.

Backstory:

Last week, we had a a Hyper V Host...

I'm guessing that you expect results. That likely means that something in your query needs to change so you get the results you are expecting....

Hi and welcome to the forums. It would be very helpful if you could post the actual execution plan. Additionally the table definition and index definitions would be really helpful.

Look again...there are NO matches.

Your first query has MLA10168, MLA10182, MLA10183, MLA10193, MLA1051, MLA1052,...

Because you don't have any data that matches your joins. In the screen shot you posted there are...