Did you name them "sp_"+something?

Try this:

;with LastTest (LTA2, LTA3) as

(select a2, max(a3)

from dbo.test

group by a2)

select A1, B2

from dbo.Test1

inner join dbo.Test

on test1.B1 = test.a2

inner join LastTest

on test.a2 = lta2

and test.a3 = lta3

(That's SQL 2005. ...

Don't think of it as eliminating the need for a co-worker. Think of it as freeing up your co-worker from mindless drudgework so he/she can do something that people...

Keep a database of it. Do inventory every now and again.

A table with which computer it's on, what license level it is, and the activation code, plus the usual...

The data change happens in the data file, but gets logged in the log file.

Think of the log file like a bank account's statement. The money doesn't come out...

Here's a rough draft of what should be a more efficient proc:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[xSynPortalToSolomon_Prog]

AS

--~~~~~~~~~~~~~~~~~~~~~~~~~

-- dcheever adding error handling 11/07

--~~~~~~~~~~~~~~~~~~~~~~~~~

Declare @errorcode int,

@rowc int,

@StartTime SmallDateTime,

@stepMarker nvarchar(300),

@TaskID...

Ah. I get it now. Thought you were having trouble getting the files, and couldn't understand why.

Not sure how to solve that one. Maybe a file converter?

Oracle or another DB for what? An extended range calendar? Why would I bother? Took me about 10 minutes to throw something together in SQL that works...

Stephanie Giovannini (6/18/2008)

---

I bet the 3% who got it "right" just clicked all the answers without looking anything up because the answer "all of the above" is a common pattern...

I haven't seen numbers disappear out of text columns, but I have seen text disappear out of number columns, in that same manner.

My solution was to pre-define the table I...

Let me see if I understand this proc correctly.

It looks like what it does is check a set of tasks and projects, find if they are in certain tables, update...

Your "SQL 2000 Bible" was darn...

You're welcome.

I'm sure it didn't start out that way on your screen, but the attachment is pretty much unreadable when I open it.

Do you have some data for the Param table that will match the data in the sample data from those spreadsheets? I just imported them, and ran your original...