Hmmm.. thanx

I will again walk through web articles

Hello Friends!!

I walked through some very good articles that cleared my doubts....

Thanks for your pointing

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=26

yes i m imoprting from table so if there is any duplicate records then it may fail....

Yes!!

That i exactly exactly i want..

Thanks for every body!!!!!!!!!!!!!!!!!!!!

Hi

See i am not doing or running such kind of jobs!!

but i heard that through

BEGIN

   WAITFOR TIME '000:00:10'

   EXEC sp_start_job @job_name = 'Job_Name'

END

we can run jobs after every few seconds...

Please...

I explain whole things here

I click in EM >>>Under Managment>>>Jobs>>> Right click Job_Name>>> Properties>>> third tab is schedules>>>> Edit>>>>Under Recurring>>>> click on Change>>>>Under Daily Frequency>>>>> Occurs Every.... here i...

hello

I m confused here ......are you talking about sql server 2005???? we have server 2000

Hello

I think there is no way to get this seconds option for Edit Recurring Job Schedule (through EM)...So i m asking is there any other way to run job...

hey

you are using aggregate function for datatype of varchar....

hi

pls find here

CREATE Proc Em_SubmitReport --'W','10/15/2006','11/09/2006'     

@type varchar(10),

@fromdt varchar(12),

@todt varchar(12)

AS

DECLARE @QUERY VARCHAR(8000)

DECLARE @max-2 DATETIME

DECLARE @min-2 DATETIME

DECLARE @Wek INT

DECLARE @Yrs INT

DECLARE @DateFormat VARCHAR(50)

DECLARE @User INT

DECLARE

Hi

How to appy indexes i didnt get ur point..pls clear me

HI..peter

that i want exactly

hi

i got...

Hello Karl

i ran your code but it is giving me error

declare @cmd varchar(8000)

set @cmd = 'select * from ' + @TableName

exec sp_executesql @cmd

Server: Msg 214, Level 16, State 2,...

Hello Y.V......

I installed with again that DVD but what i am seeing is when i click to start menu there in sql server 2005>> only  configuration tool ............ how to...