jhinch (4/23/2014)

---

I apologize for not using the proper forum etiquette. This was my first post ever, and I overlooked the etiquette section before posting. I will follow the...

jhinch (4/23/2014)

---

I have two select statements; one for open purchase orders, one for open customer orders. I would like to be able to combine the query based on i.item...

You don't specify any columns in your select statements.

INSERT INTO PARCS_DB.dbo.tbl_Utilities_CUB_LiveValue

(Value)

SELECT

FROM RTPCUBHIST_001.runtime.dbo.v_live

WHERE Tagname IN ('BOA001_STM_TOTAL.Total','BOA002_STM_TOTAL.Total','FQI_DW_A_01.Total')

The select portion needs to know what column(s) to...

Just shoot me if I ever work in a place that uses that implementation!!! Even the author agrees it...

pdanes (4/23/2014)

---

Sean Lange (4/23/2014)

---

Can you simply cast your stuffed column as a varchar?

SELECT VLTO.SkupinaAutoID, cast(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(STUFF

...

Can you simply cast your stuffed column as a varchar?

SELECT VLTO.SkupinaAutoID, cast(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(STUFF

...

Short...

Steve Jones - SSC Editor (4/21/2014)

---

CDC is an enterprise only feature as well. That can be an issue.

The CDC stuff can get complex and be cumbersome to deal with, especially...

djj (4/23/2014)

---

Thank you!

I find reading MS help a bit confussing as there are a lot of see something else. If you are lucky they even include a...

Krishna1 (4/22/2014)

---

I need the insert of table a and c to be successful even though insert to be fails.

code sample

drop table a

go

create table a

(a1 integer identity, a2 integer)

go

drop table...

djj (4/23/2014)

---

Eirikur Eiriksson, I read the info and it does not give a reason.

technet

It is recommended that SET @local_variable be used for variable assignment rather than SELECT @local_variable. For more...

jennigirl (4/22/2014)

---

Now I am trying to figure out how to combine these two queries.

SELECT I.PartNumber, I.Description, I.TimeDateCreated as [Date Part Created], OI.TimeDateCreated as [Last Req Date]

FROM Item I

OUTER...

john.p.lantz (4/22/2014)

---

We ALTER'ed a table - increasing the size (numeric 12 to numeric 17). It took over 40 minutes to run on a table that has 10 million rows....

gbritton1 (4/22/2014)

---

Perhaps the question is more, "What is minimum number of rows threshold where a PK starts to pay off?"

Seems to me, if a table only ever has 1 row,...

t-sql doesn't have a double but you can easily get the results you are looking for.

1/([NUM_STOP]-1.0) AS [TL Equivilent]