I got a problem here for the Oracle SQL, <br />one of my quries that :<br />Select <br /> enddate, <br /> enddate-durationtime as starttime...
Thanks a lot
thanks on this select *, case type when 'b' then (select col1 from tableb where col2 = tablea.col2 ) when 'c' then (select col1 from tablec where...
got a question here three tables A, B, C base on the one field in Table A, table A will inner Join the table B or Table C, any idea ? thanks
you can pass the smalldatetime by 'mm/dd/yy 13:30:00' or whatever the time you want
Hey Gaurav , thanks , your help is appreciate
if the SQL2 runs a lot in the loop, see if you can move the SQL2="select owner_zip, owner_email, owner_fax, owner_name_1, owner_state, id as sas...
can you show the query statement used to pull out the data In fact , I had the same problem yesterday, but solved by using a different index, we got...
Hey , thanks for the help
which table can I check for the query statement by using the Object ID, sorry , guys , I just found it here...
Thanks I guess I can run the profiler for half hour , then save all the query name, cost , then do a group by , get the count for each query ,...
need to know 2 things 1 , what query runs most frequently ? or count of the times each query runs in 10 minutes 2 , how much cost for each query...
sorry I typed wrong , ( idet_transferrequestflg ='O' or idet_transferrequestflg ='o' ) And ( Idet_RedeemedFlg = 'N' or Idet_RedeemedFlg = 'n' ) did...
SELECT TOP 50 * FROM Table where TableRowId not in ( SELECT TOP 50 TableRowId FROM Table WHERE Col2='something' ORDER BY Col1) and...
upper(idet_transferrequestflg) ='O' AND upper(Idet_RedeemedFlg) = 'N' AND this upper function slows your query down, my sql server is not case...
sorry , I did not give detailed info , the select statement does the query on 2 table, 1 big one , has 140 columns, 100000 recores, and another...
I have a big stored procedure, it use dynamic string to build the query and run the query by EXEC, but recently this stored procedure is little bit...
CREATE TABLE #Transaction ( [TranactionID] [int] , [UserID] [int] , . . . [RefundDate] [datetime] ) CREATE...
after I created the Index for the #temptable , it is even slower than before. and I think the # temp table is not very big
Separate names with a comma.
