It's a part of a complex query.

It sometimes results in 2-3 seconds and sometimes more than 20 seconds.

will that be one of the possibilities of delaying the result?

Thanks

Both are working.

but i am unable to understand  

WHERE @Check LIKE '''%' + CustomerID + '%'''

this query. what's process behind this.

hi,

I need to know, which r the tables affected (contains) a particular item that's referred in the Master table.

i.e., ItemID - 0580 in Master Table.

      This ItemID may be reflected...

Transaction Log has been set as Unrestricted Growth. It Auto grows frequently. We have 100 users on our Intranet applications. The Log File grows and fills the hard disk space....

SQL Temp Table Creation :

CREATE TABLE #temptable (Details Varchar(50), Monthname  Varchar(15), Qty decimal, Value decimal(18,2), Companyid varchar(10), Closingflag numeric, Sno numeric, Head numeric)

Hope this be helpful.

Hi,

Thanks, But I have stored it as html file and i need it from Internet explorer

and not from excel. please help me.