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 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...
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 ...
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...
Has anyone had any experience with using an Oracle stored procedure as a dataset for reporting services? If so, can you tell me how you set it up to return the data to reporting services?
I want to do this, but i know you cannot do like in SQL Server where you can end the stored proc with a...
Hi,
I am lost. I need to know if something like the following is possible:
<?php
if($flamt>0) {
"<img src='http://www.mydomain.com/affiliate/scripts/sale.php?TotalCost="{$flamt}"&ProductID=001' width=1 height=1>";
}
if($blamt>0){
echo "<img...
Hi,
I am trying find out why an piece of code will not execute in PHP. I am just learning, so I don't understand why this is happening.
I installed Firebug for Firefox on my PC so I can debug the PHP code. I have an include that calls another file, but it does not seem to actually get...
Hi,
I am just learning PHP and I have an issue with a site where an include for a file that once showed up at the end of a transaction no longer shows up.
What does not make sense to me is there is a piece of code that checks to see if an email went out and if so, it is supposed to "include"...
Sorry, but I am a bit stupid with the new SQL Server versions.
I set up a SQL 2008 on my PC, but had problems loading a sample database. I ran SELECT @@Versions and it returned Version SQL Server 2000.
Can someone explain why this would be and how do I upgrade it to 2008?
Thanks and sorry...
Hi,
I know how to do a not in if I am just dealing with one field, but what if I have the following situation; how should I handle that?
I have two tables that would link on id, transaction_code and Transaction_date. For any record, any of these fields could be different. for example...
I have a table like this:
field1 field2
a aa
a ab
a ac
b ba
b bb
c ca
c cc
c cd
I would like it to look like this:
field1 field2
a aa,ab,ac
b ba,bb
c ca,cc,cd
What is the best way to do this in...
Hi I have an issue where i have sets of enroll segments like this:
MemID EnrollID EffDate TermDate
A1 enr1 01/01/2006 03/31/2006
A1 enr2 05/01/2006 06/30/2006
A1 enr3 07/01/2006 12/31/2078
A2 enr1 02/01/2006...
Hi I have a view where if I run the query with in it, it runs in 3 seconds, but if I try to run the view, it seems to never end.
Any ideas as t why this might happen?
Thanks,
Harvard
Hi all,
I have a situation where I have records that could show multiple times in a query due to multiple claim ids. However, I have set up a field as a Y/N flag where I only want to flag one as Y, the others I want to be N. It does not matter which is selected as Y, but just one.
Example...
I need to create a macro that will always move to the last cell in a spreadsheet that has data. To give you an example, one time that last cell might be at row 15 and another at row 200 and another time at row 130, etc.
When I record a macro, it basically hardcodes the cell references, so the...
I have an excel spreadsheet that imports data from SQL Server via the Import External Data query. I want to change the server, but can't find anything on how to do this.
Anyone have any ideas?
Thanks,
harvard
Can someone tell me how to do the following?
I have a group of records where there is a header table and a detail table. The header and detail share a common ID, of course. The detail table has a status field where it can be ok or deny. I want to find all records in the header where all...
Does anyone know if there is a way to compare two lists and find all items in one that is not in another? I prefer not to use VBA, but if I must, i will.
Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.