Viewing 15 posts - 241 through 255 (of 4,820 total)
Try this on for size:CREATE TABLE #TEST1 (
TheDate date,
itemid int,
amount int
);
INSERT INTO #TEST1 (TheDate, itemid, amount)
VALUES ('03/01/2019', 1, 45),
('03/01/2019', 2, 46);
CREATE...
March 13, 2019 at 7:54 am
March 13, 2019 at 7:31 am
Error: ERROR MESSAGE: String or
March 13, 2019 at 7:25 am
March 13, 2019 at 7:19 am
You can try the below query. It wasn't tested precisely because you provided no sample data to work with:WITH CTE AS (
SELECT
A.EMPLID
, B.FIRST_NAME
, B.LAST_NAME
, A.BANK_CD
, A.ACCOUNT_NUM
March 13, 2019 at 7:16 am
I'm puzzled !
Running a database on an older server stoped executing its...
March 11, 2019 at 7:53 am

March 11, 2019 at 7:48 am
Have you given thought to what you just tried to do with a conversion to Integer? You tried to use a string to hold what should probably be a NULL...
March 8, 2019 at 7:39 am
I don't understand why you don't have...
March 7, 2019 at 2:28 pm
Your GROUP BY includes product, and your picture shows two different values for product for destination BJS. That would cause your problem.
March 7, 2019 at 2:03 pm
I'm guessing that given that your data makes no sense, no one is interested in helping you further propagate the nonsense. Take a close look at your first three rows. ...
March 7, 2019 at 1:57 pm
Wrapping your T-SQL code in a stored procedure is a matter of syntax, (look up CREATE PROCEDURE) and the usual benefits are those associated with encapsulation as a general principle. ...
March 7, 2019 at 12:47 pm
Thanks for offering a solution Steve, so the challenge for me is converting the code...
March 7, 2019 at 12:34 pm
Viewing 15 posts - 241 through 255 (of 4,820 total)