skumar.klm (3/2/2010)

---

I want to select top 10 records from a table,this time another user select top 10 records.

my question is how to avoid first top 10 in second selection.

this 2...

Roust i'm still trying to get a working example going, it's early and pre-cafienne for me.

perforance like this will be slow because you are using a scalar function 15K times;...

if column 1 was was an identity(), or column 4 is a calculated column, your original statement would have worked with no errors...maybe you left something out? identities and calculated...

ZeeAtl you need to find the traceid by select * from sys.traces

then:

...

i used Lynns approach and stuck the results in a temp table;

no -4 offsets at all when i did that:

--create the tmp table

select getdate() As dt, getutcdate() as utcdt, datediff(hh,...

Al I'm seeing the same thing; i even changed it so that the calculation was in the loop, instead of as a function; i still got -4 offsets sometimes, but...

Ryan i think you'll want to left join the whole sub query and use a calculated column to return whether there was a complaint or not; i did not see...

i think that by using the REPLACE function for every space, and then adding one to it, you can get thecount of the words, because they are seperated by spaces;

example:

select...

harshalnag did this help you or did you do something different?

just a couple of basics; if the job starts but takes longer than 3 minutes to complete,the next scheduled job will not run, and the schedule will not resume until/...

awesome language skills, Aeterna; looks like it is Turkish.

My Google-fu was weak;

using google translator gave me this:

i think we'd...

here's my best guess;

if you are going to update the main table, you need to update it from the virtual table INSERTED, which might be joined to other tables...

easy...you just have to explicitly use the EXEC or EXECUTE command:

CREATE PROCEDURE MyProc (@tblname sysname)

AS

BEGIN

SET NOCOUNT ON

--ack! someone used this proc! send an email

--current incarnation of EmailEventSend has no parameters

EXEC...

yeah, pre-caffeine coding messes me up almost every day; I know how the little things can getcha.

glad you got it now!

at a minimum, you are missing the AS keyword:

CREATE MyProc

AS--buncha code

CREATE PROCEDURE [dbo].[EmailEventSend]

--Send Email Notification

AS

BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name='Basic',

@recipients='mike@somewhere.com',

...