Sean Lange (12/18/2013)

---

From the sample output you posted you don't have any duplicates. There are unique values in one of those columns (I can't tell from the garbled display which...

Gillian_Pappas2002 (12/18/2013)

---

Hi.

I have the following code which is correctly selecting my data, but it is giving me duplicates and I can't use a distinct, or Max to be able to...

Hi

You can also avoid Key lookup if you use the clustered key column (Column1) in the where condition instead of Column2, of course if it suits your case, so that...

KWymore (12/17/2013)

---

Ford Fairlane (12/17/2013)

---

Whats your performance been like since...

Hi

You have an existing index

CREATE NONCLUSTERED INDEX [IX_Player_partnerIddtCreated] ON [dbo].[Player]

(

[partnerId] ASC,

[dtCreated] ASC

)

INCLUDE ( [playerId])

If you take a look in your execution plan you'll see a missing index. You...

Hi

What is the status of the protocols: TCP/IP, Named pipes and Shared memory?

Nice question, thanks.

select house_no

from test1

where...

Now corrected, pls check it.

OK,

What about this?

select house_no

from YourTable

where house_no between '4-12-1000' and'4-12-1500'

and SUBSTRING(house_no,6,10) not like '%[^0-9]%'

Try this code

select house_no from YourTable

where house_no between '4-12-1000' and'4-12-1500'

AND ISNUMERIC(SUBSTRING(house_NO,6,4))=1

and CONVERT(INT,SUBSTRING(house_NO,6,4)) BETWEEN 1000 AND 1500

Regards

IgorMi

You can use

order by house_no asc

and get the desired ordering

How do you plan to execute the sp_configure if you don't have a sql...

This should help you http://microsoft-ssis.blogspot.com/2011/04/how-to-configure-foreach-loop-container.html

Yeah, interesting question. Thanks Carlo.