DECLARE @user-id nchar(10)

SET @user-id = '001'

SELECT @user-id AS UserID, p.*, 'Prods This User Hasn''t Purchased' AS Message

FROM Prod_T p

LEFT OUTER JOIN User_Prod_T up ON up.UserID = @user-id AND up.ProdID =...

Jeff Moden (8/15/2016)

---

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives in the original...

I don't see any reason to conflate the last run with the next run. Also, when you query job activity, you need to include the session_id to make sure...

koteravindra (8/8/2016)

---

HI,

suppose if I have 3 columns in index with index order as ASC .

Emplid,deptid,Accountid

10 2 ...

So they're not nvarchar(50) but nvarchar(max)? Yeah, that's a totally different thing. Again, can't imagine why you'd ever need unicode there, let alone "max"!!

Since you don't have quotes around the assigned value, the +000000007000 is first being converted to an int value, and then that value is converted to varchar(10). Naturally your actual...

Again, there should be no issue at all indexing on an nvarchar column (although I can't imagine why you'd actually need unicode for that type of data).

Can you post the...

There are no decimal places in the value: SQL can't possibly know to "adjust" for 2 decimal places from a varchar value. Therefore, if you need such an adjustment, make...

skippyV (8/5/2016)

---

ScottPletcher (8/4/2016)

---

Given that there is no clustered index now, you might as well clus to match this query, something like below. If you have DATA_COMPRESSION available, be sure...

Probably this (?):

SELECT d1.StudentID, d1.VehicleID, d1.VehicleType

FROM (

SELECT *, ROW_NUMBER() OVER(PARTITION BY StudentID, VehicleID

ORDER BY CASE WHEN VehicleType...

Here's a quick example of what Drew's talking about. Naturally adjust the ORDER BY clause as needed to get exactly the output you want:

IF OBJECT_ID('tempdb.dbo.#StudentTransportOrder') IS NOT NULL

...

Given that there is no clustered index now, you might as well clus to match this query, something like below. If you have DATA_COMPRESSION available, be sure to use...

I think CROSS APPLY (or OUTER APPLY if you want NULL if no match is found) will do it, but of course I can't test it without useable data.

Btw, if...

Robert Domitz (8/4/2016)

3. Is "von Helsing" the same as "VONHELSING" or just "HELSING"? In the latter case, the originating system sliced off the "von" as a middle name!

The...

You certainly don't want to just store the entire name in one long, indistinguishable string. Trying to accurately parse that out later is virtually impossible.

As to the different rules/formats,...