Viewing 15 posts - 2,101 through 2,115 (of 2,894 total)
The above link is about how to present your problem to this forum to attract relevant answers in timely matter. Otherwise you will need to wait for someone who has...
February 24, 2012 at 3:17 am
February 24, 2012 at 2:36 am
roryp 96873 (2/23/2012)
select j1.child
from job j1
where j1.parent in (
select...
February 23, 2012 at 10:46 am
SQL_Surfer (2/23/2012)
I tired that. But this won't return anything.
Can you supply ddl of tables involved and some data setup?
February 23, 2012 at 7:49 am
If you want the best performance possible I can advise you to do the following:
Create a separate table to hold InstrumentId and LastUpdateTime
Create light-weight triggers (after insert, update) on all...
February 23, 2012 at 7:19 am
Your requirements are not very clearly defined in any of your post, that is why you question is not attracting much attention on the forum. Also, the code you've included...
February 23, 2012 at 7:12 am
you cannot do what you've asked for, but your query does not need to have two sub-queries:
CREATE VIEW vw_slowview
AS
select quick.Instrument_Id,
MAX(quick.TimeDateUpdated) AS TimeDateUpdatedSlow
from
(SELECT Instrument_Id, TimeDateUpdated FROM dbo.tblFutures_Options
UNION ALL
SELECT Instrument_Id, TimeDateUpdated FROM...
February 23, 2012 at 6:48 am
May be I'm missing something, but requested YYYYMMDD is the ISO format supported by CONVERT:
SELECT CONVERT(VARCHAR,GETDATE(),112)
The above will convert any DATETIME value into VARCHAR formatted as requested!
Then you can cast...
February 23, 2012 at 5:13 am
Divine Flame (2/23/2012)
Divine Flame (2/23/2012)
If you just need to reset the ID column (with names in order) so you can simply add an IDENTITY column in...
February 23, 2012 at 4:56 am
Yes, you are right.
Raising error with severity less than 10 is the mechanism to return messages back to the caller. If called from within TRY block they will not transfer...
February 23, 2012 at 4:51 am
Why not to use IDENTITY?
The following code will do it, but will only work properly if your Names are unique:
UPDATE t SET Id = n.Id
FROM #temp t
JOIN (SELECT Name, ROW_NUMBER()...
February 23, 2012 at 4:43 am
Do not re-raise the error in your CATCH block, then calling stored proc will have no idea about any error happened in the called proc.
February 23, 2012 at 4:14 am
kiran.rajenimbalkar (2/23/2012)
..So request you just Provide me the solution or what should I do in the cursor for taking less time while updating.
Is is not possible using cursor.
If you...
February 23, 2012 at 3:25 am
Gail is right, if you have reuired results stick with the working query.
But, if still want to do:
SQL_Surfer (2/22/2012)
How can I rewrite the version 1, without putting "b.BMonth= 2...
February 23, 2012 at 3:15 am
Viewing 15 posts - 2,101 through 2,115 (of 2,894 total)