Search results for query: *

Thank you SQLBill. I appreciate it.

I think you just solved my puzzle. I can work with this. Thank you very much.

Yes, but the powers that be are very particular about what views can be created and stored as well as whether they feel like bothering, so in the long run, it is easier just to create two queries. That's life when you don't have control over things. :-(, but I am cool with it as it means less...

Well This is why I posted here. It isn't that easy. I know how to write SQL, however this is a special case due to this tool we use for users to write their own queries. It is limited to keep them from building queries that would bring down the system. Anyway, thanks for trying.

Yes, but I want it to show a listing like the following: Entry 5 Exit 3 I am working with a SQL tool that our clients are using and it is very limited. So I was trying to figure out a simple way of producing this. I may just end up being that I have to create two queries, one for Entry and...

Thanks for the responses. Here is what I am trying to achieve... I have two tables like this: Enroll table Enrollid EntryID Exit ID 1 111 121 2 112 3 123 128 4 124 156 5 125...

Hi Everyone, I need to know if this is possible? SELECT CASE WHEN IDI.ID = E.ENROLLID THEN 'Entry' WHEN IDE.ID = E.EXITID THEN 'Exit' END AS Test FROM Enrolled E INNER JOIN TestTable IDI ON E.EnrollID = IDI.ID INNER JOIN TestTable IDE ON E.ExitID = IDE.ID If not, is there a way to do...

Hi, Hi have a table that is grouped and setup similar to this... Dates..............................Lots.............Sets 01/01/2013 06:25:20..........1................A1 01/02/2013 04:25:20..........1................A1 01/03/2013 05:10:18..........1................A1 01/03/2013...

I did notice that and made a change to it. It does work. Thank you for your help.

Interesting. I never thought of doing it that way. I will give it a try. Thanks.

Gap in time only. I can probably figure out the rest myself. I just need to know how to identify where there were 8 minutes or 1 hour gaps. Thanks

I am trying to do a comparison of material loaded to different machines at different times/dates. I need to find 8 minute gaps and 1 hour gaps in dates. Here is an example of data: <code> Row_id Date LotID Amount Machine 59ACD 2013-07-10 08:50:21.000 209...

No, that would be wrong because then you have overtime for monday. It would need to be counted with the next Friday's total. Thanks

I will give that a try. However, I don't understand why you have date + 3. Should that not be Date + 7? Thanks for your reply.

I will give it a try. Thanks.

Hi Everyone, I also posted this under Oracle, but I know more about SQL Server, os it should be easy to translate any differences... I have something like the following... Date ........ Hours ........ 980X 03/08/13 ........ 4 ........ 98 03/08/13 ........ 2 ........ AM 03/08/13 ........ 2...

Hi Everyone, I have something like the following... Date ........ Hours ........ 980X 03/08/13 ........ 4 ........ 98 03/08/13 ........ 2 ........ AM 03/08/13 ........ 2 ........ NULL 03/08/13 ........ 3 ...

I ended up not using a subreport. I did check that the subreport ran ok on it's own. Thanks

Hi, I have two datasets, one from SQL Server and the other from Oracle. The Oracle dataset is for the main report and the other is for a subreport. I am new to Reporting Services, so I don't have a clue how to get through this... In the subreport, I have created two perameters. One for...

Thanks for the info. I will give it a try.