And if possible how to create search box using this parameter with placeholder

sorry asking u 2 much help

If you dont mind can i get a clear picture what should i do with this below statement

5. Enter ="%" & Parameters!YourParam.Value & "%" replacing "YourParam" with the actual...

sorry guys ignore just missed one end 😛

i am getting this value from sysjobhistroy table from msdb there its in int format if u can give me solution where i can filter that table thats fine

thanks for u r time getting below error

Msg 208, Level 16, State 0, Line 10

Invalid object name '#validdatesasints'.

/****** Script for SelectTopNRows command from SSMS ******/

SELECT TOP 1000 [ServerName]

,[IsExisting]

,[IsEnabled]

,[IsScheduleEnabled]

...

i have 0 in that so do i need to write case

t

this was not working its returning conversion error unABLE CONVERT ERROR

its recovery model is full and the problem is there are duplicate entries in db

i am looking for programming and querying.

Thanks.

thanks its working

h

h