Which is equivalent to this:

SELECT WorkForce.empID,

WorkForce.empName,

WorkForce.zip,

Sales.prodID,

PayTypes.payType,

Products.prodType,

Sum(convert(int,Sales.salesTot)) AS [SumOfsalesTot] --This wass missing a parenthesis

FROM WorkForce

INNER JOIN Sales ON WorkForce.empID = Sales.empID...

Keep in mind that the join algorithm can change any time the circumstances change. You don't have any guarantee that the same query will always use the same algorithm.

More than assuming that the PK should be the clustering key, it's because the clustered index should be the first index in any table, and the PK needs an index...

Can you share some sample data and expected output?

When you mention single email per line, do you mean using a carriage return or setting a new row?

Which of your variables...

Ditto.

0010 1010

doasidont (3/30/2016)

---

Thank you. Yes, I am using SSMS. Just installed it (SS Express) a week or so ago and am learning SS as I go. Should have...

Rocket

dba-wannabe (3/29/2016)

---

I'm sorry I wasn't clear.

I'm not asking anyone to look through the code. I'm asking what causes it to run differently when run as a function...

CSVs have no data type defined. You define the data types in the connection manager. If you can only use float, you can convert the data type with a Data...

You have some misplaced parenthesis. Formatting your code might make it easier to debug.

SELECT WorkForce.empID,

WorkForce.empName,

WorkForce.zip,

Sales.prodID,

PayTypes.payType,

Products.prodType,

Sum(convert(int,Sales.salesTot)) AS [SumOfsalesTot] --This wass missing a parenthesis

FROM WorkForce

INNER...

Jeff Moden (3/28/2016)

---

Exactly. And, there's some...

I'm guessing that Jeff is thinking on taking a similar path to this, but wants to be sure about the possible restrictions.

You'll notice that I'm using datetime2(3) instead of datetime....

Shouldn't the policy send the username column like this?

CREATE SECURITY POLICY rls_CustomerFilter

ADD FILTER PREDICATE dbo.rls_customer_check(username)

ON dbo.CustomerAccessList;

GO

ben.brugman (3/25/2016)

---

Probably most...