Hi

go throw below link.

http://www.codeproject.com/Tips/584680/Using-comma-separated-value-parameter-strings-in-S

if your data is changing daily then it will cost u crating index.

for more detail there a link

http://beyondrelational.com/quiz/sqlserver/tsql/2011/questions/advantage-and-disadvantage-of-using-indexed-view-in-sql-server.aspx

Hi Use

Not exist .

as it uses contain search.

http://msdn.microsoft.com/en-us/library/ms188336.aspx

AND

<> (Not equal or =equal) uses match search .

NULL is undefined data that is why in match search...

Shadab Shah (8/30/2012)

The question which i am going to ask will prove that i how newbie i am.

Basically indexes increases the performance will searching which is nullified while inserting ....

Hi create project

Office in Visual studio .

Create excel micro as per your requirement .

Please refer below link

http://msdn.microsoft.com/en-us/library/8553caee.aspx

Hi

try like below

(civilianYears == "--" || TRIM(civilianYears) == "" || ISNULL (civilianYears)) ? NULL(DT_I4) : (DT_I4)civilianYears

thanks for correcting me as i donot having SQL 2000 for testing

I responded on what is standard .

sandeep

please provide more detail where and what scenario you are getting the issue...

hi i don think so as ms give 2 version backward comparability and 2000 is more then 2 version old for ssms 12

question is still not clear

hi sunny

look into

system table sysjobhistory

For more info read

http://msdn.microsoft.com/en-us/library/ms174997(v=sql.100).aspx.

If still need help let me know.

thanks

hiC rusty hop u will get it by reading below code