Viewing 15 posts - 631 through 645 (of 4,087 total)
A foreign key references a unique key. It doesn't necessarily have to be the primary key.
Drew
March 4, 2019 at 10:07 am
Assuming that the data is already summarized by month, you just need to COUNT(<some field> ) OVER(PARTITION BY <partition fields> ORDER BY <date field> ROWS BETWEEN 11 PRECEDING AND CURRENT...
March 1, 2019 at 1:26 pm
First, this is not the best way to post sample data. I've created a quick and dirty method of doing it, because I'm a bit short on time.
February 28, 2019 at 4:15 pm
The closest thing is Merge Replication. I've never used it, so I can't tell you much more.
Drew
February 28, 2019 at 10:42 am
February 27, 2019 at 12:48 pm
February 27, 2019 at 12:31 pm
February 27, 2019 at 11:48 am
February 27, 2019 at 10:00 am
You haven't gotten a response, because you haven't supplied readily consumable sample data and expected results. (A picture is not consumable.) If you follow the instructions in the first link...
February 26, 2019 at 10:04 am
February 26, 2019 at 9:54 am
I don't think that you want to be using a sub-query at all. Try the following.
UPDATE L
SET LOTTABLE05 = I.LOTTABLE05
FROM WMWHSE1.ITRN I
JOIN...
February 26, 2019 at 9:36 am
I would...
February 25, 2019 at 1:24 pm
CREATE TABLE #COUNTRY_CODES (
country varchar(10),
code varchar(10)
);
INSERT INTO #COUNTRY_CODES (country, code)
VALUES ('australia', '55555'),
...
February 25, 2019 at 12:24 pm
February 25, 2019 at 10:37 am
February 22, 2019 at 2:08 pm
Viewing 15 posts - 631 through 645 (of 4,087 total)