Using linked servers (http://msdn.microsoft.com/en-us/library/ms188279.aspx) you should be able to access tables directly given appropriate authorizations.

You can try something like this:

SELECT DoctorID, LastName, FirstName

FROM (

UPDATE Doctors

SET NumImpressionsInSearches = NumImpressionsInSearches + 1

OUTPUT INSERTED.*

...

The syntax is in this article along with perhaps a better way:

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

Ray M (11/15/2012)

---

Wouldnt the size of the database be the MDF size + the LDF size?

No one minds helping, but if you want us to do your job for you,...

In addition to MickyT's suggestion, you could do a catch all query or the dynamic SQL method suggested in this article by Gail Shaw:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Watch out for SQL injection if the...

Jeff - Working through it now but its pretty deep and I expect it will take me awhile.

Great explanations though!

I'm going to try to see if I can adapt the...

Boy! Did that end up being a whole lot messier than I thought it would be when I got started on it!

Nevertheless, here's an alternate solution (I think):

DECLARE @StartDT...

I'm not getting exactly the desired results you posted but maybe this will give you a hint.

;WITH CTE AS (

SELECT TOP 1 ID, TEXT1, aDate, TEXT2

...

Hari Seldon-821789 (11/15/2012)

---

You're the first person who's ever commented on the name, but then I don't post a whole lot of questions. I'm also known as Demerzel on other...

I have a GenerateCalendar FUNCTION (rewritten by Jeff Moden) that can also be used for this. Thought I'd share it below.

The query using it is pretty simple but the...

P74 (11/14/2012)

---

hi dwain.

it didn't quite do the job for some records such as 'STI850-200 ' or '25-53492-22 ' where it drops the first digit...

very close to Lynn's results however.

thanks...

You can try this. It looks like the results you're after but why you'd want such bizarre results eludes me (enlightnment requested :-)).

SELECT PntKey=ISNULL(PntKey, Cd2PntKey)

,PntQty=CASE...

Here's another way that seems to work with Lynn's set up data:

SELECT PartNum, RIGHT(PartNum,

LEN(PartNum) + CASE PATINDEX('%[^0-9]%', PartNum)

...

Here's an article for the recursively challenged exploring rCTEs by example:

http://www.sqlservercentral.com/articles/T-SQL/90955/

Hope it is helpful.

ChrisM@Work (11/7/2012)

---

Sony Francis @EY (11/7/2012)

---

Try this

SELECT *

FROM TableA a

LEFT OUTER JOIN TableB b ON a.LoanID = b.LoanID

WHERE b.ColumnA <> 'Y'

When we use INNER JOIN it will consider only commom...