PSB sure did get a lot more than bargained for!!

🙂

It looks like you're trying to pass in the date parameter as a character string. I don't think that's necessary. Have you tried doing this?

DECLARE @DeleteDate datetime

SET @DeleteDate...

I had a client who took a database offline and deleted the transaction log file for one of their production databases (someone recommended they do this, and I can't recall...

Something similar to this with a couple of added complications came up the other day. Took two of us a couple hours to do with a self-join. Wish...

I'm glad they spotted this and outed the plagiarizer.

CREATE TABLE #temp(SalesPersonID INT, Sales NUMERIC(10,2))

INSERT INTO #temp

(SalesPersonID,Sales)

SELECT 1000,2080.25

UNION

SELECT 1001,10083.35

UNION

SELECT 1002,2900.78

SELECT...

You were probably the highest man hourly wise and the client had you and 1 or 2 other people on their final list. More than likely they just wanted...

I kind of asked some specific questions but feel free to use this thread to share your experiences working as a contractor.

The good work for me comes and...

It means you have articles marked for replication which is keeping portions of your transaction log from being reused...and also is the reason the log file grew to such a...

I overlooked the number column. What causes that to change from 1 to 2?

Edit....I figured it out by looking at it again. My first solution isn't accurate for...

I think this meets your needs. Probably other (better?) ways of doing this too.

SELECT sr.SeqNo,dt.StartYear,dt.EndYear,number,sr.name

FROM @tblJobHist_source sr

INNER JOIN ( SELECT MIN(StartYear)StartYear,MAX(EndYear)EndYear,Name

FROM @tblJobHist_source dt

GROUP BY name

...

😀

Doh...I seem to always forget that. Change the last line to this:

EXEC sp_executesql @finalquery, N'@StartDate DATETIME, @PartTypeMP VARCHAR(1000)',@StartDate = @Start_Date, @PartTypeMP = @Part_Type_MP

I'm with you...the last sentence ("all you really need to do...") threw me off. I thought you were implying just add a try/catch in .Net and be done with...

So...are you saying the records you were expecting to see in tblActualPrice aren't there? Do you know for sure that your query returns results?

Once you execute the proc, go...