I deleted the user and created a new one and now it works. I did read some post about user mapping issuse and that may have been the problem.

Thanks

• This reply was modified 1 year ago by  kat35601.

I show

openssl ciphers -v | awk '{print $2}' | sort | uniq

SSLv3

TLSv1

TLSv1.2

TLSv1.3

Thanks

Perfect, It works great Thanks

That works like a dream...Thank You

SELECT          date        = CONVERT( varchar, omprequestedshipdate,...

Correct no day shift data wanted the hard coded date I am using to get if you will today's information I don't want to have to change the date manually.

• This reply was modified 3 years, 12 months ago by  kat35601.

SELECT

ISNULL(Transactions.item, Snumbers.item) AS item

,count(serial) AS qty

,tuser

,sum(ISNULL(M1_KF.dbo.PartUnitSalePrices.imhUnitSalePrice,0)) as TotalPrice

FROM Orbedata.dbo.SNumbers

LEFT OUTER JOIN OrbeData.dbo.Transactions ON snum = serial

left JOIN M1_KF.dbo.PartUnitSalePrices ON Orbedata.dbo.transactions.item = M1_KF.dbo.PartUnitSalePrices.imhPartID

WHERE tdate >= '12-28-2020 17:00' and tdate <= DATEADD(HH,...

• This reply was modified 3 years, 12 months ago by  kat35601.

The query will be run each day and what was produced each day for the entire week would show for example  day one we built 400 of part a1 and...

I am not following I need to include for 12 hours 5pm to 5am the next day and then not include data from 5am till 5pm the same day so...

I could do it with subqueries.

SELECT Datepart(wk, ompcreateddate + 84)                 ...

I understand  your comments on 1 thru 4 and will update that before I move it over.

number 5 > just add 84 days to the date the order was created...

Drew that works very well. Thanks You

SELECT pt.impPartGroupID
    ,sl.omlPartID
    ,sum(sl.omlExtendedPriceBase) AS Total
    ,sum(sl.omlOrderQuantity) AS qty
    ,sum(sl.omlOrderQuantity) /...

[Brackets] worked Thanks

I tried this but it did not work. the column does change to x2013 but the data rows for that column become 2013 etc

select

week_,2013 as x2013,2014 as x2014,...