Viewing 15 posts - 11,206 through 11,220 (of 13,879 total)
Something like this might do it:
select t1.MonthYear, t1.Location, Coalesce(t1.Metric1, t2.Metric1) Metric1, Coalesce(t1.Metric2, t2.Metric2) Metric2
from t1 join t2 on t1.MonthYear = t2.MonthYear and t1.Location = t2.Location
August 13, 2011 at 5:52 am
sudhakar.siram (8/11/2011)
hi guys give solution to my...
August 11, 2011 at 2:22 am
Please explain why you want to use a 'temp variable' rather than a table variable. What do you think the difference is?
August 10, 2011 at 10:33 am
Paul?
Please provide sample source data & an idea of what the required results are (follow the link in my signature for advice on how best to ask for help).
August 10, 2011 at 9:38 am
ChrisM@Work (8/10/2011)
Try adding COUNT(*) OVER(PARTITION BY Residence_Address) to your first query.
From this, it sounds like you have managed to understand the initial post. I salute you sir 🙂
August 10, 2011 at 9:01 am
Thank you.
Eugene, your answers make a lot of sense, thanks for taking the time to respond.
Phil
August 10, 2011 at 7:34 am
Can you change the format of the spreadsheet?
Or perhaps add a new worksheet which formats a copy of the data nicely, ready for import? If you do it right, it...
August 9, 2011 at 12:54 pm
hemani2000 (8/9/2011)
Hi,I am getting the following error message when I run my SSIS package with more than 200,000 records to go through LookUps and FuzzyLookUps but it w
A bit too...
August 9, 2011 at 9:47 am
Elliott Whitlow (8/9/2011)
Phil Parkin (8/9/2011)
Elliott Whitlow (8/9/2011)
August 9, 2011 at 9:39 am
sahoong (8/9/2011)
August 9, 2011 at 9:36 am
I don't think that this is a problem with SSIS. That error is an FTP error. Have you tried FTPing the file manually, by some other mechanism, just to check...
August 9, 2011 at 9:27 am
Elliott Whitlow (8/9/2011)
August 9, 2011 at 9:23 am
sahoong (8/9/2011)
I have this task to accomplish
Please take last night’s full backup and convert it to a standard Microsoft SQL backup file, compress the file and then FTP it to...
August 9, 2011 at 9:15 am
Aparna-1 (8/9/2011)
I have a script task that invokes a webservice. The response of the webservice is saved as a string.
I then call an execute sql task to save the...
August 9, 2011 at 2:34 am
Viewing 15 posts - 11,206 through 11,220 (of 13,879 total)