Viewing 15 posts - 691 through 705 (of 1,250 total)
On that note, I've been spoiled by the heavy hitters on this site.
It must be said Jeff, that you are one of the heavy hitters on this site.
May 18, 2015 at 8:15 am
SQLRNNR (5/12/2015)
whereisSQL? (5/12/2015)
BWFC (5/12/2015)
Intelligence
Business
Oxymoron
Subjective
Objective
Lens
May 12, 2015 at 8:46 am
Hi, welcome to the forum.
You've not given us a massive amount to go on there. If you can post some sample data it will give us a much better...
April 30, 2015 at 6:01 am
Whether you mis-understood or not:
EXECUTE Parameter_1 1;
That one line has shown me exactly what I was doing wrong.
Thank you very much for your assistance.
April 15, 2015 at 4:40 am
Cadavre (4/15/2015)
Are you just trying to do: -
INSERT INTO @resultsEXECUTE Parameter_Recipient @login;
??
Basically yes. I want to take the results from Parameter_Recipient, when run for a given login (it...
April 15, 2015 at 4:08 am
Eirikur Eiriksson (4/14/2015)
Grant Fritchey (4/14/2015)
And this makes 14,001 posts. My fingers are tired.Did you mean 0x3A99?
😎
I thought that too....Unless he posted really fast over night:-D
April 15, 2015 at 12:46 am
djj (4/2/2015)
Eirikur Eiriksson (4/2/2015)
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
Basement
Cellar
April 2, 2015 at 5:29 am
with cte_emp as
(
select
m_employees = max(employees)
,company
from CompanyEmployeeArchive
group by company
)
select
e.Company
,dateinserted
,employees
from CompanyEmployeeArchive e
join cte_emp ce on ce.company = e.company
where ce.m_employees < 100
group by e.Company,dateinserted,employees
This is another option.
April 2, 2015 at 5:27 am
Ed Wagner (3/20/2015)
BWFC (3/20/2015)
Ed Wagner (3/20/2015)
crookj (3/20/2015)
Ed Wagner (3/20/2015)
djj (3/20/2015)
RefinementOil
fracking
Drill
Sergeant
Arms
The Man
March 20, 2015 at 7:47 am
Viewing 15 posts - 691 through 705 (of 1,250 total)