EasyBoy (4/23/2014)

---

I have also noted one more thing.

I can't to modify existing index due to business rule. So, i havent used AI_OperatorCBGEstimate_14947. But i have created new index(AI_OperatorCBGEstimate_HAP) with the...

EasyBoy (4/23/2014)

---

I have also noted one more thing.

I can't to modify existing index due to business rule. So, i havent used AI_OperatorCBGEstimate_14947. But i have created new index(AI_OperatorCBGEstimate_HAP) with the...

Eirikur Eiriksson (4/23/2014)

---

ChrisM@Work (4/23/2014)

---

hoseam (4/23/2014)

---

Now that's an easy one cause I created a table for you, so you are working with the data you know. say now the user input...

hoseam (4/23/2014)

---

Now that's an easy one cause I created a table for you, so you are working with the data you know. say now the user input tblDef_RETURNS as table,...

If you're updating two very specific columns, they should exist in one very specific table, surely?

If not,...

Would you do it like this Eirikur or would you...

hoseam (4/23/2014)

---

For now I'm using SELECT ... INTO

SET @InsertSQL = 'SELECT * INTO Hosea_tempTable FROM ' + @TableName +' WHERE (Product_Id = '+ QUOTENAME(@Product_Id, '''''') +' or Product_Id = ''''...

hoseam (4/23/2014)

---

The scenario is this..

I have a product AGP with Fund E01, and other attributes

then later I want to creat another product with the same attributes as AGP...

aar.mba (4/17/2014)

---

I have to convert nvarchar to date data type. and fetch the week number of that particular month from the column

Pls find the sample data

CREATE TABLE #mytable

(

current_week nvarchar(30)

)

insert...

hoseam (4/23/2014)

---

... the perm table name will be passed as a input parameter, then take all the it's data into temp table to update them, then put them back into...

We'll need some sample data and a table of expected results. Read this article [/url]which describes how to create and post your scripts.

GilaMonster (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.

Systems here won't let me anywhere...

A little more info - this is the same question on MSDN:

[Quote]I have one simple query to optimize but somehow after creating couple of index this query is still having...

Greg Edwards-268690 (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

Greg Edwards-268690 (4/22/2014)

---

Ed Wagner (4/22/2014)

---

dwain.c (4/21/2014)

---

Greg Edwards-268690 (4/21/2014)

---

TomThomson (4/20/2014)

---

Greg Edwards-268690 (4/20/2014)

---

Bucket List Challenge - teach Jim to Filet a fish properly.

I'll keep trying, but I may fail...

GilaMonster (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

The question I'm asking is here - http://www.sqlservercentral.com/Forums/FindPost1563832.aspx and the query, to save you a few moments, is this:

select KeyInstn, MAX(dateendedstandard) DateEndedStandard

from ObjectViews..InternalOperCBGEstimate

where dateendedstandard...