Viewing 15 posts - 11,191 through 11,205 (of 13,872 total)
Randy Doub (8/15/2011)
August 15, 2011 at 3:04 pm
Just adding an alias isn't enough.
Ah indeed. No doubt that fact would have become obvious very rapidly during development. I knew it was too early for me to have been...
August 15, 2011 at 7:59 am
BUT, wait untill JC will see your post... [w00t] You will then know that your table is not a table [BigGrin]
Wow, Jesus monitors this forum too?
:hehe:
August 15, 2011 at 5:21 am
greg.bull (8/15/2011)
Thanks Phil,Supplementary Question:
If all of these rows were in 1 table - could you think of a solution ? Maybe something like selecting from itself ?
Regards, Greg.
Sure - I...
August 15, 2011 at 3:02 am
Dates don't quite work that way. Try this:
select * from Sales.SalesOrderHeader
where OrderDate between '2004-01-01' and '2004-12-31'
In fact, because dates in SQL Server generally have a time component, this may be...
August 14, 2011 at 10:23 am
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
Viewing 15 posts - 11,191 through 11,205 (of 13,872 total)