Viewing 15 posts - 4,381 through 4,395 (of 13,855 total)
We are planning to create a dedicated server for SSIS. SQL 2016 will be...
May 30, 2018 at 6:44 am
You could also add the decoded monthname to the CROSS JOIN:
CROSS JOIN
(
SELECT m = 1,
mth = 'January'
...
May 30, 2018 at 5:21 am
May 29, 2018 at 11:40 am
It's not that difficult, but there are some tricks required.
1) Define the flat file source rows as single columns
-- So every source file row is (initially) treated...
May 29, 2018 at 7:46 am
May 29, 2018 at 6:18 am
May 29, 2018 at 6:01 am
May 28, 2018 at 2:32 pm
May 28, 2018 at 12:31 pm
Hi,
is there any Chance to get this working?
CREATE TABLE [dbo].[Table_1](
[id] [int] IDENTITY(1,1) NOT...
May 28, 2018 at 10:37 am
As you have not provided DDL, I cannot post the exact solution. But here is an idea for creating running totals for 'missing' months by left joining from a calendar...
May 28, 2018 at 8:25 am
I facing some problem at the time inserting the data,
for example:
I insert the one...
May 28, 2018 at 7:01 am
May 27, 2018 at 4:04 pm
Is it possible...
May 26, 2018 at 8:14 am
Are the environments the same? I may be wrong but it looks like...
May 24, 2018 at 1:42 pm
I have 2 environments running on the same version of SQL, exact same tables...
May 24, 2018 at 1:31 pm
Viewing 15 posts - 4,381 through 4,395 (of 13,855 total)