Thank you for your replies. I appreciate your fast help.

Adi

This is an intent lock. As you remember the server can have locks on few levels - row lock, page lock and table lock. Think of a situation...

Another index might help you, but we can't know for sure. It depends on the selectivity of the other columns and on the values that are being used for...

You really have to give more details about your problem. The way the question is asked, I have no idea what problem you have. Please explain...

Here is one more way:

create table Demo (Col1 varchar(10))

go

insert into Demo(Col1) values ('123453'),('124344ME'),('123453'),('124344ME'),('323390'),('3233MS')

select Col1, substring(Col1,1, CASE WHEN Col1 like '%[aA-zZ]' THEN len(Col1)-2 else len(Col1) end)

from Demo

You could check the file's size and according to the size decide if it should be cycled or not. Take into consideration that you'll need to work with xp_cmdshell...

This is your first query:

select count(Call_status_flag) Total from Table1

where '2013-06-22 00:00:00.000'>='2013-06-22 00:00:00.000' and Call_status_flag='N'

The expected results are 2. The first condition will always be evaluated as true...

You second SQL Statement should produce an error because you don't compare the date to anything. If it is a mistake, pleas rewrite your question and this time write...

The question should be posted in a different forum, because it has nothing to do with Integration services. As for your questions:

1) You can configure each...

I'm not sure that I understood what you want. If all you want is to concatenate the results of the results of both case statements into one column, then...

You can do it with substring and charindex functions:

select substring(ename,charindex(':',ename)+1,len(ename)) from emp

Adi

You can't do any and modification in the database without logging. Logging is essential for the database. Without it the server won't be able to rollback any statement....

You can use the function datediff, which works with 3 parameters – Interval type (minutes, hours, days, etc') Start time and end time. For example

Select datediff(mi,'20130612 10:00:00', '20130612 11:00:00')

Select...

I admit that I didn't use it yet, but I think that you can use resource governor.

Adi

You can try to set the option arithabort on in your application when you open the connection. There is also the possibility of changing it on server level, by...