kcj (4/16/2015)

---

I have two string variables each has Varchar(8000)

Declare @VariableA varchar(8000)

Declare @VariableB varchar(8000)

How can I concatenate these two variables without converting them to varchar(max) ?

If...

Alan.B (4/16/2015)

---

Looks like you have duplicate column names in both tables but you are not using a table alias

You query should look something like this:

SELECT a.col1, a.col2, b.col1

FROM a

Join

(

<Subquery>

)...

Have you checked the tempdb, congestion there is a possible cause.

😎

Ink

GF (4/15/2015)

---

SQL 2008

I have a table that has company id, attachment file name, folderexists columns.

First what I need to do is create a series of folder or directories on...

Pretty cool!

😎

IaaS

Sean Lange (4/15/2015)

---

Eirikur Eiriksson (4/14/2015)

---

Sean Lange (4/14/2015)

---

Eirikur Eiriksson (4/14/2015)

---

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...

Forensics

ztoddw (4/14/2015)

---

I admit I don't know for sure that it's more efficient- it just seems like your solution was doing more work than it needed to- although I'm not sure...

Dodge

Just ran your code on a multi instance box (10 running and 4 not running), all showing up in the results, could this be a permission issue?

😎

BTW: the services not...

paul.connors 70350 (4/15/2015)

---

Thanks for the swift reply, I'm thinking along the same lines myself, unfortunately the cursory scan of the event logs etc revealed not much detail at all and...

tarr94 (4/15/2015)

---

Hi,

I'm a bit puzzled. I have a stored procedure with a cursor and while loop. I have two update statements that update the same table. If...

paul.connors 70350 (4/15/2015)

---

Hi

I'm just looking for a little feedback from out there in the wilderness, here's my situation.

5 months ago added locally attached SSD storage

•741148-B21 - HP 200GB 12G SAS...