Viewing 15 posts - 2,806 through 2,820 (of 15,381 total)
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...
May 29, 2015 at 9:19 am
Ed Wagner (5/29/2015)
Sean Lange (5/29/2015)
TJT (5/29/2015)
Sorry, solved - small issue on my end
No offense but if your view is like the pseudocode below your issue is only beginning. The performance...
May 29, 2015 at 9:15 am
TJT (5/29/2015)
Sorry, solved - small issue on my end
No offense but if your view is like the pseudocode below your issue is only beginning. The performance of this kind of...
May 29, 2015 at 8:41 am
TJT (5/29/2015)
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...
May 29, 2015 at 8:25 am
pspkshah (5/29/2015)
thanks, I have just made slite change in that, in place of minute, I take hour.
Be careful using hour. If the start minute is 59 and the end minute...
May 29, 2015 at 8:01 am
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...
May 29, 2015 at 7:59 am
sarath.tata (5/29/2015)
May 29, 2015 at 7:27 am
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....
May 29, 2015 at 7:20 am
pspkshah (5/29/2015)
how can I get time difference of the following record please help,
STARTTIME ENDTIME
3:30 PM ...
May 29, 2015 at 7:15 am
rocho09 (5/28/2015)
Ohhh I see, so sorry my mistake. Here is the Execution Plan.Thank you for your comments.
Regards
Any chance you can upload the actual execution plan instead of the estimated one?
So...
May 29, 2015 at 7:09 am
mataleao87 (5/28/2015)
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...
May 28, 2015 at 2:17 pm
daniel.globalstudio (5/28/2015)
I see, thanxs very much
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....
May 28, 2015 at 2:10 pm
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.
May 28, 2015 at 1:34 pm
daniel.globalstudio (5/28/2015)
thanx, but don´t understand, i see that there are matches in the two first querieshttps://drive.google.com/file/d/0BwS3pZe3vTTxZmtrQXpvbmhXT3M/view?pli=1
Look again...there are NO matches.
Your first query has MLA10168, MLA10182, MLA10183, MLA10193, MLA1051, MLA1052,...
May 28, 2015 at 1:29 pm
daniel.globalstudio (5/28/2015)
Hi, thanx very much.this is my query screen
https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png
Why my result is empty?
Because you don't have any data that matches your joins. In the screen shot you posted there are...
May 28, 2015 at 11:48 am
Viewing 15 posts - 2,806 through 2,820 (of 15,381 total)