Viewing 15 posts - 5,431 through 5,445 (of 13,876 total)
EXEC dbo.ShopperSkuHistory
WITH RESULT SETS
(
shopper_id char(32) NOT NULL,
skus ...
July 7, 2017 at 12:47 pm
This is a good solution architecture, IMO. If different customers have different file formats, there really is no way of getting round the fact that you need different packages to...
July 7, 2017 at 12:44 pm
Well done on getting to the root of that issue.
July 7, 2017 at 12:41 pm
Also, I hope that you and your users know and accept that (NOLOCK) means that you may experience the following symptoms:
1) Missing data
2) Reading the same data more...
July 7, 2017 at 10:31 am
You are on the right path.
Instead of
EXEC proc
You need
EXEC proc with result sets
as suggested by the error message. You need to describe the expected result...
July 7, 2017 at 10:28 am
July 7, 2017 at 8:59 am
July 7, 2017 at 8:56 am
July 7, 2017 at 8:38 am
July 7, 2017 at 6:49 am
July 7, 2017 at 6:31 am
The data type is INT.
Conversion...
July 7, 2017 at 6:30 am
July 7, 2017 at 6:03 am
That's an unusual source format. What is the datatype of your Created_Date column and how did you perform the conversion?
July 7, 2017 at 5:59 am
July 6, 2017 at 1:45 pm
July 6, 2017 at 1:42 pm
Viewing 15 posts - 5,431 through 5,445 (of 13,876 total)