Viewing 15 posts - 646 through 660 (of 3,543 total)
=IsNothing(First(Fields!TOLERANCE_CHECK.Value, "NetUnitPricingReport"))
July 23, 2014 at 7:09 am
If your file ends with a 'rows affected' line or extra CRLF then AFAIK you will not be able to import using the format file as the line does not...
July 23, 2014 at 2:47 am
Jeff Moden (7/21/2014)
July 22, 2014 at 2:07 am
halifaxdal (7/17/2014)
Msg 8114, Level 16, State 5, Line 1Error converting data type varchar to bigint.
If the files were output by SSMS set to output to file then your data will...
July 21, 2014 at 7:12 am
WITH cte (cs_id,USERID,assgn_dtm,complet_dtm,diff_of_days,rownum) AS (
SELECTcs_id,USERID,assgn_dtm,complet_dtm,DATEDIFF(dd,assgn_dtm,complet_dtm),
ROW_NUMBER () OVER(PARTITION BY CAST(assgn_dtm as date),CAST(complet_dtm as date) ORDER BY assgn_dtm)
FROM#temp_tbl
WHEREcs_id = 1000090
ANDuserid = 1000031
)
SELECTcs_id,USERID,
SUM(CASE WHEN rownum = 1 THEN diff_of_days ELSE 0 END),
SUM(2-rownum)
FROMcte
GROUPBY cs_id,USERID
July 18, 2014 at 7:27 am
sgmunson (7/11/2014)
Turns out my last attempt was actually almost right.....It produces the exact result you specified.
Nice 🙂
July 12, 2014 at 2:47 am
The scripts would be the T-SQL necessary to create the tables and data to test the query with, for example
The table DDL would be like this
CREATE TABLE PURCHLINE(PURCHID char(12),ITEMID char(6),QTYORDERED...
July 11, 2014 at 10:49 am
matfurrier (7/11/2014)
I'm grateful for all the help.
However, all the scripts that I have tried here are returning me the same result.
I still do not understand why the...
July 11, 2014 at 7:32 am
sgmunson (7/11/2014)
...save for the ORDER BY clause that appears just after the GROUP BY in the subquery, which doesn't need to be there and SSMS won't like it anyway...
My bad...
July 11, 2014 at 7:29 am
SELECTfs_accno,
SUM(CASE WHEN fs_cost_center = '205produ' THEN amount ELSE 0.00 END) AS [205produ],
SUM(CASE WHEN fs_cost_center = '206produ' THEN amount ELSE 0.00 END) AS [206produ],
SUM(CASE WHEN fs_cost_center = '208produ' THEN amount ELSE...
July 11, 2014 at 7:06 am
SELECT I.ITEMID AS ITEM,
I.INVOICEID AS NF,
I.TRANSREFID AS OC,
RECENTES.FINALIDADE,
CONVERT(decimal(10,2), I.COSTAMOUNTPOSTED/RECENTES.QTD) AS VALOR_RATEADO
FROM INVENTTRANS I
LEFT OUTER JOIN (
SELECT PL.ITEMID, PL.PURCHID, PL.DATAAREAID, PL.DIMENSION3_ AS [FINALIDADE],
SUM(PL.QTYORDERED) AS [QTD],
ROW_NUMBER() OVER (
PARTITION BY PL.ITEMID, PL.DATAAREAID,...
July 11, 2014 at 6:51 am
LEFT([string],LEN([string]) - CASE WHEN RIGHT([string],1)='/' THEN 1 ELSE 2 END)
July 10, 2014 at 6:26 am
Koen Verbeeck (7/1/2014)
Ashif Shaikh (7/1/2014)
no, for me the jobs is creating the output file from job- step -> advance -> output
Ah yes, you need to use jobtokens for that.
July 1, 2014 at 7:21 am
Jeff Moden (6/30/2014)
Eirikur Eiriksson (6/30/2014)
jcrawf02 (6/30/2014)
[music]Jeff sees you when you're sleeping, He knows when you're awake....[/music]...he's reading all your posts
and counting your mistakes
so you better...
😎
... sooooo, throw the packages out,
you...
July 1, 2014 at 1:49 am
SQLRNNR (6/30/2014)
David gave him most of the answer already but he didn't try to do anything with it other than say it doesn't work.
Actually Lynn's solution looked like my first...
June 30, 2014 at 9:02 am
Viewing 15 posts - 646 through 660 (of 3,543 total)