sql server - Updated SQL query returns no data, even with cross joins -

-

After

Then, I have replaced all the old queries in my application to remove * = Is operator In either of these questions, I have a lot of difficulty in finding out why my output is different

This old query was: 

  SELECT URMS_User_Name AS FE_Name, URMS_User_ID as FE_Code, COUNT (MRFS_FE_Code) aS No_Of_Jobs, as well as SCRM_Service_Center_Name Service_Center_Name, CSMSDVLP.fnGetExtertise (URMS_User_ID) TBL_User_Master, TBL_Service_Center_Master, TBL_User_Role, TBL_MR_FE_Schedule where USRL_Role_Code expertise = 'EF' and URMS_User_ID = USRL_User_ID and SCRM_Service_Center_ID = URMS_Service_Center_ID and URMS_User_ID * = MRFS_FE_Code and MRFS_Scheduled_Date & gt; = '28 -Oct-2014 00:00:00 'and MRFS_Scheduled_Date & lt; = '04 -Nov-2014 00:00:00 'SCRM_Service_Center_Name, URMS_User_Name, URMS_User_ID by group URMS_User_ID, and the following is the query:  
  as URMS_User_Name FE_Name, on URMS_User_ID join select FE_Code, COUNT (MRFS_FE_Code) No_Of_Jobs as, SCRM_Service_Center_Name as as SERVICE_C enter_Name, CSMSDVLP.fnGetExpertise (URMS_User_ID) expertise as TBL_User_Master Left URMS_User_ID = MRFS_FE_Code inner TBL_MR_FE_Schedule SCRM_Service_Center_ID = URMS_Service_Center_ID Join Inner TBL_User_Role TBL_Service_Center_Master Join URMS_User_ID = USRL_User_ID Where USRL_Role_Code = 'EF' and MRFS_Scheduled_Date & gt; = '28 -Oct, 2014 00:00:00 'and MRFS_Scheduled_Date & lt; = '04 -Nov-2014 00:00:00 'SCRM_Service_Center_Name, URMS_User_Name, URMS_User_ID by command URMS_User_ID  by group 
 
 The old query data is completely fine, but the new query returns empty rows I tried to connect all with Cross Johns and the same problem. 
 
 However, the odd thing is that if I run queries without any date status, then everything works fine. So, now, I'm confused whether I made a mistake or it's just the old crazy acting operator.

Text after "div class =" itemprop = "text">

Conditions on the external linked tables are in on the clause. NULL has an MRFS_Scheduled_Date in the external-connected record, so with your WHERE section you remove them, thus changing them in an external joining form, where the segment is more restrictive than before, it can not be any results May be the reason for not getting. 

  URMS_User_Name Selection FE_Name, FE_Code, COUNT (MRFS_FE_Code) No_Of_Jobs as URMS_User_ID, as SCRM_Service_Center_Name as Service_Center_Name, excluding TBL_User_Master as CSMSDVLP.fnGetExpertise (URMS_User_ID) Expertise TBL_MR_FE_Schedule on URMS_User_ID = MRFS_FE_Code and MRFS_Scheduled_Date & gt; = '28 -01-00: 00: 00 'and MRFS_Scheduled_Date & lt; = '04 -Nov-2014 00:00: 00 'INNER JOIN TBL_Service_Center_Master ON SCRM_Service_Center_ID = URMS_Service_Center_ID Enter the URMS_USR_UR on the URMS_User_ID at USR USRL_User_ID where USRL_Role_Code =' EF 'Group SCRM_Service_Center_Name, URMS_User_Name, URMS_User_ID ORR by URMS_User_ID;

Comments

Post a Comment

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr
Read more

javascript - data.match(var) not working it seems -

-
OK, I have this small block code, which is to scanned a number on the website, but for some reason There is a hip that it is not scanning at all. var regenges = / \ & lt; Span class = "currency-robux" data-to-"item-private-value-price" & gt; ([\ D,]) \ & LT; \ / Span \ & gt; /; Var ValueCiling = Data. Match (reggae); Value-song = number (value slicing location (",", "")); Is there anything wrong with that? This is related to the if statement if (value sling and lieutenant; = price watching) { < P> A function calls to move from there, but for some reason it does not seem to run at all. So I think the Regex is wrong but I'm not sure how. (There is a variable in PriceWinking , this is a snippet from the code.) On the website, I'm trying to remove it. & lt; Span class = "robux" data-plus = "item-privatesale-price" & gt; 115 & lt; / Span & gt; Keep in mind
Read more

javascript - How can I pause a jQuery .each() loop, while waiting for user input? -

-
Before I continue to get a jQuery .each loop to wait for user input There is a problem in repeatedly repeating This is my code (I have commented on what I would like to do): & lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Top & gt; & Lt; Link rel = "stylesheet" type = "text / css" href = "common_components.css" /> & Lt; Meta http-equiv = "content-type" content = "text / html; charset = UTF-8" /> & Lt; Link rel = "stylesheet" href = "slider.css" & gt; & Lt ;? Php include_once 'common_components.php'; $ Query = $ dbh- & gt; Queries ("SELECT movies_dir FROM settings"); $ Line = $ query- & gt; Obtain (PDO :: FETCH_ASSOC); Date_default_timezone_set ('UTC'); Echo "& lt; title & gt; movie scanner & lt; / title & gt;"; ? & Gt; & Lt; Script src = "jquery.min.js" & gt; &am
Read more