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
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 ?
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...
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' )
SELECT TOP 50 * FROM Table where TableRowId not in (
SELECT TOP 50 TableRowId FROM Table WHERE Col2='something' ORDER BY Col1)
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] ,
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.