Same thing I was going to ask. In the view this column will contain either a null...

CptCrusty1 (5/24/2012)

---

SELECT DISTINCT P.PRE_DTT_PRESERVATION_ID,

CASE horizondm_dev2.dbo.LookupValue_dev(D.EVI_DEV_MEDIA_TYPE)

WHEN 'ORIGINAL STORAGE'

THEN 'Original: '+ EVI_DEV_BC_Barcode +' SN:'+ EVI_DEV_SN

WHEN 'WORKING STORAGE'

THEN 'Working: '+ EVI_DEV_BC_Barcode +' SN:'+ EVI_DEV_SN

WHEN 'For Remediation'

THEN 'For_Remediation: '+ EVI_DEV_BC_Barcode +' SN:'+...

Actually, you didn't eliminate the NOLOCKS hint, you just hide them in the view.

What is with the hint any way? You do know the issues with using the hint,...

This is the last LEFT OUTER JOIN from your view:

LEFT OUTER JOIN MOC_DT.dbo.TCN_Xref tcn

ON tcn.recid = (SELECT

MIN(recid)

...

Can you post the DDL for the view? Our biggest problem is that we can't see from here what you see there. Makes it really hard to give...

You are reading this query wrong:

SELECT *

FROM TABLE_1 T (nolocks)

WHERE ISNULL(ISDELETED,0) = 0

EXCEPT

SELECT *

FROM vw_TABLE_1

It will only show you records from TABLE_1 where ISNULL(ISDELETED,0) = 0 that aren't in...

First, welcome to SSC and MS SQL Server.

I had to go the other way for a while (MS SQL Server to Oracle) and was confused to CASE used for flow...

Like this (you were half way there).

select

ID_NUM as ID_num,

LAME1,

RESP_CODE as RESP_CODE1,

cast(QUERY_COMM as nvarchar(max)) as...

For the OP. We really could use more information from you to help you improve this function. We need the DDL (CREATE TABLE statements) for each of the...

Sarsoura (5/22/2012)

---

This function gets the score up to now for students (we are using categories and some of the categories have deletelowest to specify drop lowest of assessments in...

Cadavre (5/24/2012)

---

Fizzbuzz is your evil interview? Really? It's as old as dirt (as are the solutions) 😛

WITH t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2 AS (SELECT...

Instead of a web application, perhaps a One-Click application. It is delivered to the users desktop by the web, but it actually sits on the users desktop. Been...

Perhaps Service Broker could be used. I would have to do some investigating to be sure, but it sounds like another viable alternative.

I would identify the tables that you need to delete records frm and delete them from the tables directly.