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
...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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]
...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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. ...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 5, 2008 at 1:56 pm
Awesome article. Alot of useful examples even though it's just the tip of the iceberg
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 7, 2008 at 7:04 am
Can you provide the SSIS package. It's difficult to see the screen shots and to follow
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 9, 2008 at 7:33 am
Viewing 9 posts - 661 through 670 (of 670 total)