Further on the install, I've had no problems installing 2012 alongside existing 2014 unlike previous versions.

😎

jay-h (4/14/2015)

---

Eric M Russell (4/14/2015)

---

syoc (4/14/2015)

---

Anyone use a bait computer, leave the table, stare at it from a crack in the bathroom door waiting for it to be taken so...

ztoddw (4/14/2015)

---

This way is probably more efficient-

declare @STRING varchar(1000);set @STRING='100010111100010001';

select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))

from (select n=number, sub=substring(@STRING,number,len(@STRING))

from master.dbo.spt_values where type='P'

and (number between 1 and len(@STRING))) t

where (n=1 or substring(@STRING,n-1,1)<>'0')

and...

geoforu (4/14/2015)

---

Hi,

I was using sql server 2014 trial version. We bought sql server 2012 now.

How can we setup sql server 2012 ?

Will...

Did you mean 0x3A99?

😎

Soot

Yet Another DBA (4/14/2015)

---

Do you really think...

Don't be shy Luis, you can ask:-D

😎

Good points Steve and unfortunately far too common. A good Kensington Lock Kit costs around $20, interesting to see a raise of hands here, how many use those regularly?, and...

Revenant (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

TomThomson (4/13/2015)

---

Jeff Moden (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

djj (4/13/2015)

---

Revenant (4/13/2015)

---

Ed Wagner (4/13/2015)

---

whereisSQL? (4/13/2015)

---

Ed Wagner (4/13/2015)

---

eccentricDBA (4/13/2015)

---

Ed Wagner (4/13/2015)

---

Fun...

ramana3327 (4/13/2015)

---

Hi,

I am working in testing environment.

Some one deleted all data from all most all tables in a particular database. I want to find when that happened and which login...

ScottPletcher (4/13/2015)

---

Eirikur Eiriksson (4/13/2015)

---

ScottPletcher (4/13/2015)

---

Here's an alternative approach, also using CROSS APPLY, that can take advantage of the (presumed) clustered index on prefix.PREFIX_VALUE; no guarantee, but it might perform ...

jgale 70688 (4/13/2015)

---

Thank you for the replies.

Both solutions did work. However, the data I'm working with is slightly more complex than my simple example. My main data table is a...

Flag

ScottPletcher (4/13/2015)

---

Here's an alternative approach, also using CROSS APPLY, that can take advantage of the (presumed) clustered index on prefix.PREFIX_VALUE; no guarantee, but it might perform better.

SELECT p_cross_apply.PREFIX_VALUE, SUM(d.DATA_VALUE)...