I think interviewers should play Jeopardy with the interviewees.

Answer: ambiguous column

Question: What is the error message you get when you don't sufficiently qualify a column reference with the associated table...

Luis Cazares (10/31/2012)

---

Would you buy it? Or would you...

Jeff Moden (11/1/2012)

---

Jason Selburg (11/1/2012)

---

Good idea dwain, but I do not want to/ can not execute the statements.

I need only to check the syntax.

Also, the syntax can be...

Still haven't found the definitive answer but I did think of this approach.

It might work a little better and could conceivably be used with INSERTs, UPDATEs and DELETEs!

DECLARE @sql VARCHAR(8000)...

A pure SQL solution, using Lowell's example might be like this:

DECLARE @sql VARCHAR(8000) = 'SELECT * FROM FROM sys.objects'

BEGIN TRY

EXEC (@SQL)

END TRY

BEGIN CATCH

...

computergirl (10/16/2012)

---

Okay I am kind of new to this and I am trying to create a table and if the user doesn't fill all the fields I need the empty...

Perhaps it is something like this that you seek:

;WITH Dates AS (

SELECT MyDate

FROM (

VALUES ('2012-10-28'),('2012-10-29'),('2012-10-30')) a (MyDate)),

Tally (n)...

matt6749 (10/29/2012)

---

Hi,

Each doctor in my doctors table has a main zip code and an alternate zip code.

SELECT D.*

FROM Doctors D

INNER JOIN ZipCodes Z

ON D.MainZip = Z.ZipCode

OR D.AlternateZip =...

Try removing the...

I believe Jerry's answer is correct.

What you want to do is this:

WHEN MATCHED THEN BEGIN

INSERT INTO @BookChangeTracking(TitleID,OldQuantity,NewQuantity,ChangeDate)

VALUES(bi.TitleID,bi.Quantity,bi.Quantity+bo.Quantity,getdate())

UPDATE SET bi.Quantity = bi.Quantity + bo.Quantity

END

But the MERGE statement doesn't support BEGIN...

While it will, you won't be able to manipulate results in the client.

To do that, you'd need to INSERT into a temporary table within the dynamic SQL. That table,...

We're asking the OP to make it easier for us so let's make it easy for...

No need to be embarrassed and you're welcome.

You'd be surprised how often the simplest issue is uncovered quickly by a second set of eyes. In this case, I happened...

Try this:

DECLARE @tApplXML XML

,@SQL NVARCHAR(max)

,@ParmDefinition NVARCHAR(1024)

,@applnbr int

set @applnbr = 24

SET @sql = N'SELECT @ptApplXML = (SELECT * FROM [database].[dbo].

WHERE [ApplNbr] = @pApplNbr

FOR XML PATH(''database.table''))'

SET @ParmDefinition...

Somewhere I heard that COUNT(*) is optimized for this specific case (not Craig's conditional count).

If you'd like a faster way that doesn't need to do a table scan, this technique...