... smoking something from Amsterdam and drinking strong clear thing from Eastern lands of Europe...

:hehe:

su88rao (5/16/2013)

---

this is for table1 i,e t1

P1nvarchar(255)Checked

S1nvarchar(255)Checked

B1nvarchar(255)Checked

H1 -b1intChecked

H1 -s1intChecked

S2 -b1intChecked

S2 -s1intChecked

J1 -b1intChecked

J1 -s1intChecked

and this is for table 2 i,e t2

P1nvarchar(50)Checked

S1nvarchar(50)Checked

B1nvarchar(50)Checked

Funnvarchar(50)Checked

Valint Checked

Locnvarchar(50)Checked

and i...

Yes, you can. In another column:

SELECT CASE

WHEN CARS.Model LIKE '%Ford%'...

Query you posted refers to the table with name...

Have you read the article http://www.sqlservercentral.com/articles/Best+Practices/61537/?

Post DDL of your tables, sample data insert script and expected results based on these data. Nothing more.

I don't think that will get you too far here...

You don't need to post the same question into three different threads.

i have 2 tables

one call it as dbo.t1 and another dbo.t2

t1:

P1 S1 B1 H1 S2 J1

______________________________

b1 s1 b1...

There is no need to duplicate post.

All replies better to go to original one:

http://www.sqlservercentral.com/Forums/Topic1453408-391-1.aspx

There is no need to duplicate post.

All replies better to go to original one:

http://www.sqlservercentral.com/Forums/Topic1453408-391-1.aspx

It's all here:

http://msdn.microsoft.com/en-GB/library/ms191543.aspx

Can you post the code you are running?

Somewhere in this code you are...

Hi and welcome to the forum.

Unfortunately it's too unclear requirements and details.

Could you please read "forum etiquette" article in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you provide details as per above I'm...

TJT (5/15/2013)

---

I am trying to create a variable like the following in a WHERE clause

DECLARE @test-2 AS VARCHAR(90)

SET @test-2 = '2003 OR Cars.year = 2004 OR Cars.year = 2004'

SELECT Cars.year

FROM...

Something tells me that CROSS APPLY (with index seek on FK_StationId (I guess it's indexed in real life)) will be quite faster than using second windowed function which would cause...

First of all, it will be more helpful if you would supply your sample data in a runable/executable way, something like this:

...