Use parenthesis around the two LIKE conditions:

select *

from resource

where [date] > '02/02/2010'

and ( [Alan] like 'In%' or [Alan] like 'R%' )

Maybe I'm wrong, but I see an Update.

Can't it be the cause of the duplicate key error?

ColdCoffee (4/27/2010)

---

Oh man, you beat me third time in the same thread. Feels good that i can also code like you..it really is an honor to be on par with...

It's a "trick" to generate on the fly a string with concatenation of all the values...

ColdCoffee (4/27/2010)

---

Gianluca Sartori (4/27/2010)

---

Aaah! You fell victim of the "google translator" bug!

I think you wanted to translate "You're welcome", that's "Prego" in Italian.

"Sei il benvenuto"...

Here's your query, Jason.

Hope you find it helpful.

--CREATE TABLE

IF OBJECT_ID('Tempdb..#meterReading') IS NOT NULL DROP TABLE #meterReading

CREATE TABLE #meterReading(

[mReadingCallReference] [int] NULL,

...

Aaah! You fell victim of the "google translator" bug!

I think you wanted to translate "You're welcome", that's "Prego" in Italian.

"Sei il benvenuto" means literally "you...

Whoops! Sorry for echoing, Ken.

The order of execution is determined by the query optimizer. Look at the query plan and you'll find out the execution order of each step and how it is implemented.

Generally...

It's not difficult to build the query dynamically:

DECLARE @sql nvarchar(4000)

SET @sql =

STUFF

...

ColdCoffee (4/27/2010)

---

hey buddy, i did not understand fully your requirement, but i have a pivot query which might interest you..

SELECT datax , [1] StatoImp1, [2] StatoImp3, [3] StatoImp3 FROM...

Jason, post your table scripts, some sample data and the desired output and I'll be glad to help.

This should do the trick for you:

--CREATE TEST TEMPORARY TABLE

IF OBJECT_ID('Tempdb..#Test') IS NOT NULL DROP TABLE #Test

CREATE TABLE #Test (

[datax] [smalldatetime] NOT NULL ,

[StatoImp] [bit] NOT NULL ,

[Imp] [smallint] NOT...

Hi Alessandro,

it's nice to find other Italians on this site.

can you please clarify what values do you expect in every column? What would the results look like with the...

Some readings for you:

How to post performance problems[/url]

Consistency problems with NOLOCK

TIMEBOMB - THE CONSISTENCY PROBLEM WITH NOLOCK / READ UNCOMMITTED