Lynn Pettis (8/27/2014)

---

Why did people post code? It would have been nice to see what the OP had tried first since this looks like homework even though the OP...

Robert Heynen-454800 (8/27/2014)

---

I tried that first...didn't work

I researched a bit and found something called a surrogate pair, where if the char number is higher than a certain range, it introduces...

Quick question, what version and edition of sql server (select @@version) are you on?

😎

Then, that in itself is a change to the...

Further on this, the code in my initial post...

keshabsingh (8/27/2014)

---

Run this script

create table #table1(steps int)

insert into #table1(steps)values(1)

insert into #table1(steps)values(3)

insert into #table1(steps)values(4)

insert into #table1(steps)values(5)

select steps from #table1

drop table #table1

You will get this

steps

1

3

4

5

I want this way.

stepFrom stepTo

1...

Jeff Moden (8/27/2014)

---

rodjkidd (8/27/2014)

---

jcrawf02 (8/27/2014)

---

rodjkidd (8/27/2014)

---

One of the PM's near me is having a meting at his desk. Explaining something to another person. They are almost replying with umhum with...

Ooops, wrong number:-D

😎

I don't think your approach is clumsy, in fact if you add a POC (Partition Order Cover) index on the table, this method is very hard to beat!

😎

-- create table

if...

Talib123 (8/27/2014)

---

While running missing index script I came across a few indexes that use XML and Geography data types. Never really used these before and am looking for advice.

XML and...

GilaMonster (8/27/2014)

---

Of course not, you would never:-D

... just trying to show the complexities of doing this kind of search. The 'best' way (IMHO) would be to normalise...

Something like this?

😎

DECLARE @SAMPLE TABLE

(

id_Contract INT NOT NULL

,nm_ContractType VARCHAR(25) NOT NULL

...

Apart from being a futile effort using the nolock hint with update / delete, it is...

Good point, that will ferment into a false positive;-)...

Robert Heynen-454800 (8/27/2014)

---

I am trying to write to a file using .Net. In one column, I am wrapping the output in a unicode char(164)

i.e.

select char(164) + ColumnText + char(164)

The...