Viewing 9 posts - 661 through 670 (of 670 total)
you can group by fields that are not in the select clause. Results won't make much sense, but sql allows this.
SELECT a,b
FROM #temp
...
August 25, 2009 at 9:22 am
you could put it in a subquery if you really need to
SELECT [Nett] / 6.5 AS [Payable]
from (select Tran.Amount+Tran.Discount+Tran.Taxes AS [Nett]
...
August 25, 2009 at 9:11 am
Graham,
thanks for the info. This is what I was looking for. It looks like I can use your 1st option
May 14, 2009 at 11:56 am
RBarryYoung (5/10/2009)
You are getting this error because SP_HELP_JOB calls "sp_get_composite_job_info" which in turn tries to use INSERT..EXEC to capture the output from "xp_sqlagent_enum_jobs".
I understand why I'm getting the error. ...
May 11, 2009 at 6:17 am
in the DB2CLI.INI file, there was a setting that looked like this:
Patch1=131072
This code translates to "Describe time stamps as a char(26)". This setting was only on the box that...
June 10, 2008 at 6:40 am
We resolved this issue. Everything was the same except the ODBC Driver's ini file. The ini file on the one that didn't work was setup to treat timestamp...
June 6, 2008 at 12:26 pm
We are still having an issue with this. The interesting thing is when we eliminate the date range in the criteria, the datetime formats are different.
Server that...
June 5, 2008 at 1:56 pm
Awesome article. Alot of useful examples even though it's just the tip of the iceberg
May 7, 2008 at 7:04 am
Can you provide the SSIS package. It's difficult to see the screen shots and to follow
January 9, 2008 at 7:33 am
Viewing 9 posts - 661 through 670 (of 670 total)