Thanks a lot for your help..

you scripts help me for my requirement, instead of creating the table directly i am passing the command value into variable from there i am...

Hi

select J.name, JS.command, from msdb.dbo.sysjobsteps JS

join msdb.dbo.sysjobs J on J.job_id=JS.job_id

where name=@sessionjobname (predefined variable)

The above query returns command column data as

DELETE FROM SE_MODULE WHERE (SE_MODULE_DATE <...

Thanks a lot..!!

Hi

Thanks a lot for your help..!!

i am getting the following error message after adding the above specified statements.

Msg 207, Level 16, State 1, Line 1

Invalid column name 'Count'.

Please help...

if exists (select * from ::fn_listextendedproperty('MS_Description', 'schema', 'dbo', 'table', 'EMPLOYEE', 'column', 'EMP_NUM'))

BEGIN

exec sys.sp_dropextendedproperty 'MS_Description', 'schema', 'dbo', 'table', 'EMPLOYEE', 'column', 'EMP_NUM'

END

exec sys.sp_addextendedproperty 'MS_Description', 'DESCRIPTION OF THE COLUMN.', 'schema', 'dbo',...

Hi

Thanks a lot for your Help..!!

One small clarification, here i want to select the records only the count value greater than zero.

Please let me know what are the things...

Yes, he wants to pass the table name, column name & column value.

Thanks

Surendra

Hi

I am passing only the column value.

for example the table CUSTOMER is primary key with PK_CUSTOMER on CUST_KEY column and referencing the X number of tables as foreign...