Use a reporting tool. This...

Eskandari (8/5/2013)

---

The basic problem is this:

Consider the case that we are looking for a particular term, for example, the word network.

A word can be located anywhere, such as the subject...

Erland Sommarskog (8/5/2013)

---

No, that old syntax for RAISERROR (which has been deprecated since SQL 6.0 released) does not work in SQL 2012 in any compatibility mode.

Ironically, SQL 2012 includes a...

Please...

Mike Dougherty-384281 (8/5/2013)

---

zerko (8/4/2013)

---

Select * From Employee /*

Update Employee

Set LastName = 'Smith'

--*/

Where LastName = 'Smeith'

So I can now write quite a complex update statement if needed, it's protected in...

Have a look here[/url].

As Elliott suggests, this is really a T-SQL performance question.

Unless you are suggesting that the proc runs more quickly when executed in SSMS than in SSIS?

If this is the case,...

select from table1

where exists (select 1 from table1 where col1 = 'd') and exists (select 1 from...

Your first post mentions one table. Now you are mentioning many - how was I supposed to know this?

I made a mistake in trying to help you, because you did...

Nothing is displayed the way you have tried because you are saying:

'Give me all rows where col1 is d and col1 is i'

Col1 cannot simultaneously contain both values - hence...

ssurekha2000 (8/3/2013)

---

i have a table with 5 fields

field1 will have values as 'd' and 'i'

if the field1 of table has both the values then only the data shld e displayed

but...

JoNTSQLSrv (8/2/2013)

---

PATINDEX is just retrieving the index...

I see.

You can probably get quite close through the use of PATINDEX and diligent use of wildcards. Have you tried this?

If you can guarantee that the database is and will be in a...

Presumably you are using some sort of front-end application (Winform/Web) to get this info from the user. This validation should be done there and not by SQL Server.