Lynn Pettis (12/11/2008)

---

Okay, I can take the heat, however consider this; 3 automobile accidents over 15 years of commuting from the south side of Colorado Springs to Denver and driving...

Sarfaraj Ahmed (12/11/2008)

---

Create Table Temp(

nameX VARCHAR(10),

moneyX int

);

INSERT INTO temp VALUES('a',10);

INSERT INTO temp VALUES('a',5);

INSERT INTO temp VALUES('a',15);

INSERT INTO temp VALUES('b',5);

INSERT INTO temp VALUES('b',20);

My question is:

How can I calculate the average maximum...

Think I'll walk home across the fields.

No problem, here ya go...

[font="Courier New"]DECLARE @ReasonCode VARCHAR(100)

SET @ReasonCode = '1,2,4,8,16'

DROP TABLE #Reasons

CREATE TABLE #Reasons...

Jeff Moden (12/11/2008)

---

Heh... I think it's a bit odd that anyone would write code to make commenting it out easy when they refuse to comment code to make it easy...

The two obvious choices are:

Resolve the values in @ReasonCode into a table or table variable, or convert the whole lot into dynamic sql.

There are some nifty methods of doing the...

sujiakm (12/11/2008)

---

select * from OPENQUERY([system2-PC\sqlserver2005],'select getdate()')

&

select * from OPENQUERY([system2-PC\sqlserver2005],'select * from sysobjects')

Both Works fine..

I have create the linked server on the default instance as [system2-PC\sqlserver2005]

and I want to run a...

Start simple...does this work?

select * from OPENQUERY([system2-PC\sqlserver2005],'select getdate()')

Remember, OPENQUERY requires that the linked server is already set up, can you confirm that it is by querying against it directly?

Reckon this should do it:

[font="Courier New"]--Create table with currency rates:

DROP TABLE #tblRates

CREATE TABLE #tblRates(

        [currency_id] [int] IDENTITY(1,1) NOT NULL,

        [currency_type] [varchar](10) NULL,

        [currency_rate] [decimal](18, 6) NULL,

        [rate_date] [datetime] NULL

)

INSERT INTO #tblRates

SELECT 'GBP',...

So, you want to get the closest date to your reference date @Date_Reported from table A - then get the closest match to the date found in table A, in...

Try

ORDER BY ABS(DATEDIFF(dd, rate_date, @rate_date))

If there are several rows with the same rate_date then you might need the result from DATEDIFF in hours or even minutes.

Lynn Pettis (12/10/2008)

---

Instictive is the key. I was heavy into Shoto Kan Karate many years ago, and I know that is what saved my life one day. I...

Only one problem there Kelvin - you've restricted it to a single ProductID.

Hi Mark

This requirement isn't unusual, and won't take long to fix. We do need a level playing field though, which you, and any contributors to this thread, can work to...

Garadin (12/9/2008)

---

Garadin (12/9/2008)

---

Chris,

Although it does seem like it might be more efficient due to the derived tables, the execution plans are virtually identical (once I add the aliases to your...