Ed Pollack (6/19/2014)

---

raghava_tg (6/18/2014)

---

create table #temp (id int, data varchar(80))

insert into #temp (id, data)

select 1, 'a,b,c'

union all

select 2, 'x,y'

union all

select 3,'j,k,l'

select * from #temp

i want to create a output...

barry 50045 (6/19/2014)

---

Anybody,

Does anyone know of a way that I can pull all of the data from all of my tables in my Sql Server Express 2008 database and convert...

GF (6/19/2014)

---

Thank you Craig and Sean,

The problem was user error.

There were in fact no duplicate but at the time I was certain there were.

I was at the end of an...

Ed Wagner (6/19/2014)

---

jasona.work (6/19/2014)

---

Ed Wagner (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Stuart Davies (6/19/2014)

---

Sean Lange (6/19/2014)

---

SQLRNNR (6/19/2014)

---

JAZZ Master (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Ed Wagner (6/19/2014)

---

crookj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

djj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

crookj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

Stuart Davies (6/19/2014)

---

rhythmk (6/19/2014)

---

Stuart Davies...

Seems a little odd but here are two ways you could do it. The first is a **ACK**Scalar Function**ACK**, the second is much the same logic but as an inline...

rxm119528 (6/19/2014)

---

For id 1 the the destination table is loaded fine till the startdate of 1012012.

suppose if the load fails after that for soem reason and meanwhile the source...

Thanks Melanie. I imagine it is painful when this amount of spam infiltrates.

djj (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Stuart Davies (6/19/2014)

---

Sean Lange (6/19/2014)

---

SQLRNNR (6/19/2014)

---

JAZZ Master (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Ed Wagner (6/19/2014)

---

crookj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

Management...

Predator

Then either you don't have any duplicates or you didn't do a very good explaining the issue. This works perfectly with...

I would recommend not using floats here. You should use an exact datatype like numeric instead. Once you start doing calculations and stuff using floats you will get rounding errors...

Ahh so I did. Then it seems the UNION query you posted would be a good...

harsimranjeetsinghwasson (6/19/2014)

---

What protocols or list of steps can be followed while pushing and pulling data from intranet to internet,

where data in intranet is peculiar and important than data on internet.

For...

It looks like the only difference is that the first query will have consys.ParentLevelId = 5 and the second one 6? Just adjust your join condition slightly.

SELECT DISTINCT C.SubSystemID

, c.SubSystemName

,...

Ed Wagner (6/18/2014)

---

Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

sing4you (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Ed Wagner (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Stuart Davies (6/18/2014)

---

bcsims 90437 (6/18/2014)

---

Rice...