Sergiy (3/31/2016)

---

drew.allen (3/31/2016)

---

It's actually MUCH faster to create a table using the VALUES expression, because most of the cost is writing and reading the temp table to tempdb. If...

I recommend ALWAYS using UNC paths.

Drew

Sergiy (3/30/2016)

---

Solution is suprisingly simple.

1. Create a "translation" table:

CREATE TABLE #Mapping (

FromChar NCHAR(1) PRIMARY KEY,

ToChar NCHAR(1)

)

INSERT INTO #Mapping ( FromChar, ToChar )

SELECT 1, 'A'

UNION ALL

SELECT 2, 'B'

UNION ALL

SELECT...

doasidont (3/31/2016)

---

Sorry. Hit go too soon. To continue,

couldn't I use the same 'Where In' clause to qualify (filter) 'Sales'.empID using 'WorkForce' empID? Workforce.empID lists unique ID's. If so,...

Alan.B (3/31/2016)

---

Sergiy (3/30/2016)

---

Solution is suprisingly simple.

1. Create a "translation" table:

CREATE TABLE #Mapping (

FromChar NCHAR(1) PRIMARY KEY,

ToChar NCHAR(1)

)

INSERT INTO #Mapping ( FromChar, ToChar )

SELECT 1, 'A'

UNION ALL

SELECT 2, 'B'

UNION ALL...

Seen eons ago on alt.religion.emacs

Drew

pietlinden (3/30/2016)

---

Looks like DelimitedSplit8K and a "conversion table" would do the job.

the DelimitedSplit8K would split out the string into individual characters, and then you could join that to the conversion...

Sergiy (3/29/2016)

---

You're inserting varchar values 'DY1' DayNo into nvarchar(4) column.

It causes an implicit conversion and consequently, the warning.

If you either change the datatype to varchar(4) or use N'DY1' DayNo...

GilaMonster (3/30/2016)

---

You're not going to get the desired output with a join, left or right.

I don't know what bo universe is, If it accesses SQL server, can you put the...

First, the WHERE clause in your subquery is turning your LEFT OUTER JOIN into an INNER JOIN. The purpose of using the LEFT OUTER JOIN in the first place...

Phil Parkin (3/29/2016)

---

Disagree. This requires an OR.

select a from b where condition1

union (should probably be union...

Use the QUOTENAME function instead of hard-coding the quotes.

I also recommend that you use the XML string concatenator to create a dynamic table value constructor rather than using UNION all....

With LEFT and RIGHT the two sides represent independent sets, but with APPLY the RIGHT side can be dependent on the LEFT side. Since the right side IS dependent...

Eirikur Eiriksson (3/29/2016)

---

Quick thought, there is no need for the subquery as this can written as a normal query

😎

SELECT

C.cust_id

,C.cust_name

,C.cust_state

...

SQL 2016 (3/29/2016)

---

I have a concept question on this code:

SELECT cust_name,

cust_state,

(SELECT Count(*)

FROM orders

...