Viewing 15 posts - 1,366 through 1,380 (of 1,825 total)
So have you :
a) Not understood what ive said
b) Ignored what ive said
October 16, 2009 at 3:08 am
If you are going to use DynamicSql then use as Matt suggested , building a sql statement with only one order by condition.
See this link
October 16, 2009 at 3:01 am
The issue is not how much data is returned , but how much work SQLServer has to do to return one column,
If @Order = -2 then...
October 16, 2009 at 2:26 am
alifah (10/16/2009)
hmmm..im so new wif sql..can anybody help me how to reduce the error..
Dont think im being awkward for the sake of it but ...
Look at the tables, look...
October 16, 2009 at 2:16 am
alifah (10/16/2009)
it works but it shows duplicate data..
Most probably because of cartesian join.
October 16, 2009 at 2:04 am
What are your business rules for when Headcount =0 ?
October 16, 2009 at 2:02 am
crfenix (10/15/2009)
There is an index over the column ZipCode.
Which will never the actively used by this query as this
ZipCode like '%' + @ZipCode
Gets all the zip codes ending in @ZipCode....
October 16, 2009 at 1:53 am
The issue is here...
FROM applicant a,program p
join intake i on i.intakeid=a.intakeid
How is applicant joined to program ?
FROM applicant a
join intake i on i.intakeid=a.intakeid,
program p
This will work , but as Gail...
October 16, 2009 at 1:43 am
Please see the link below on how to post performance issues
October 16, 2009 at 1:39 am
A rise in execution time should be expected as you are raising the amount of columns sql server is having to order on, granted the majority will be null...
October 16, 2009 at 1:36 am
Also , and im trying not to be Celko here :-), there is no such thing as the 6'th record.
Do not make the assumption that a table can be...
October 16, 2009 at 1:15 am
If i understand you correct
SELECT [a] , min() b,MAX() maxb, sum([c]) c
FROM tbl3
GROUP BY a
HAVING MIN()<>'c' or MAX()<>'c'
October 15, 2009 at 6:13 am
Please google first (1st result from "sql server what statement is executing")
http://sqlserver-qa.net/blogs/t-sql/archive/2008/02/12/3428.aspx
October 15, 2009 at 5:01 am
Please google first (3rd result for "trigger updated")
http://www.sqlservercentral.com/articles/Triggers/triggerscolumnsupdated/115/
October 15, 2009 at 4:27 am
Viewing 15 posts - 1,366 through 1,380 (of 1,825 total)