Viewing 15 posts - 16 through 30 (of 59 total)
I am new to SSIS, so after reading it so far... i need to install business intelligence development studio to build SSIS solution to bring data from One SQL Server...
August 4, 2015 at 11:26 am
When i do it... it takes all values from left table and only those values from right table where id and date is matching.
July 27, 2015 at 6:28 pm
Table1:
SELECT 1AS ID,'May-2014' AS date,7 AS I1
UNION ALL SELECT 1,'May-2014',4
UNION ALL SELECT 1,'May-2014',5
UNION ALL SELECT 1,'Jun- 2014',2
UNION ALL SELECT 1,'Oct-2014',1
UNION ALL SELECT 2,'Jan-2013',10;
Table2:
SELECT 1AS ID,'May-2014'...
July 27, 2015 at 2:20 pm
No. There will always be 52 rows (as 52 weeks are there). In coding i can use current month.
June 23, 2015 at 11:16 am
Actually ordering in ssms is being done through this way. But when i am pasting same query in excel pivot tables then this is giving data in normal order as...
June 23, 2015 at 10:53 am
I have attached the file above to show what i need. Hope this helps. Thanks
June 23, 2015 at 9:06 am
Attached is the new file which has data in present format and required format. I tried to do through SQL and data comes in ordered way but as soon as...
June 23, 2015 at 8:50 am
Based on this query i am trying to modify it for those case where C# (18) for 2015 exist say for (w5, d1, i1, t1, 8) but 2014 data doesn't...
June 19, 2015 at 2:05 pm
Is there any other way i can explain my query? or if somebody is trying please respond.
June 19, 2015 at 1:49 pm
Viewing 15 posts - 16 through 30 (of 59 total)