Viewing 15 posts - 5,326 through 5,340 (of 49,571 total)
Scripts will only give you results when you run them.
What do you mean by 'daily'?
It has to run every day?
It has to return only one day's results?
It has...
July 14, 2015 at 3:41 am
BL0B_EATER (7/14/2015)
GilaMonster (7/14/2015)
BL0B_EATER (7/14/2015)
GilaMonster (7/13/2015)
Brandie Tarvin (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is...
July 14, 2015 at 3:39 am
A having clause is a predicate. So of the form HAVING <Expression> = <Expression>
Hence what you've got will give a syntax error
To be honest, I think more information is...
July 14, 2015 at 3:36 am
Please don't post multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1702565-392-1.aspx
July 14, 2015 at 3:33 am
petermaddin (7/14/2015)
July 14, 2015 at 2:53 am
Maybe go ask your boss for clarification? You're not really giving us enough information on the task to help.
July 14, 2015 at 2:48 am
BL0B_EATER (7/14/2015)
GilaMonster (7/13/2015)
Brandie Tarvin (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is the degree...
July 14, 2015 at 2:45 am
Unless you had some monitoring, it's unlikely that you'll be able to tell what the memory usage was at a point in the past. That said, it was probably SQL...
July 14, 2015 at 2:38 am
SQLRNNR (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Congrats on the latest degree. Was this...
July 13, 2015 at 9:51 am
Write a select which gets the results you want. Write it so that it will return the values you want the updated table to have. Then, once you have that,...
July 13, 2015 at 9:38 am
Try first writing it as a select with a FROM and a derived table in the FROM clause (not a subquery in the SELECT). Once you have that correct it's...
July 13, 2015 at 9:18 am
As the eror states, SUM requires one parameter, you've specified two.
Sum(DayCount,0)
You need to move the ,0 to the end and add another bracket.
p.s. you can copy from inside a code...
July 13, 2015 at 8:30 am
mtlsql (7/12/2015)
Why are you using a table variable (with it's attendant row estimation problems) over a temp table?
What's a attendant row estimation problem? Never heard of it...
Attendant (adjective)
- being...
July 13, 2015 at 7:49 am
Viewing 15 posts - 5,326 through 5,340 (of 49,571 total)