Viewing 15 posts - 16 through 30 (of 48 total)
I really dont get it. I queried sp_autostats(HBA_PERSNL_MODD) which is the table that was showing the column with no statistics and it happens that the column actually do have statistics...
January 14, 2014 at 3:20 pm
Found the solution to the horizontal blank lines after playing around with it. To remove such blank spaces, just right click the Group row details of the detail row to...
January 7, 2014 at 9:36 am
Thanks chris. I will check out your solution. You and Sean have been so helpful.
E.O
January 2, 2014 at 1:25 pm
I made it a CTE as in below:
CTE (comments, matter_uno) AS
(SELECT case when isnull((SELECT top 1 i.comments
...
January 2, 2014 at 10:38 am
Thanks Chris for responding to this query. I have been able to solve the problem.
EO
December 30, 2013 at 11:35 am
Thanks, Sean earlier pointed it out in an earlier response. However, I have this code from another table which I would want to add as a column to the table....
December 23, 2013 at 10:32 am
Thanks Chris. Your suggestion works perfectly fine. The APPLY is really the magic wow!!!
EO
December 23, 2013 at 7:51 am
Yes, I am expecting one row for matter name.
I just have a workaround on it and that is to remove the sum in the grouping in the code and...
December 23, 2013 at 5:04 am
Sean,
I tried your suggestion and I have this error message. What should I do?
Msg 144, Level 15, State 1, Procedure sp_Bank_Work_Report1, Line 18
Cannot use an aggregate or a subquery in...
December 23, 2013 at 3:49 am
Thanks SSC veteran and SSC Champion for your suggestions and also performance tips. However Sean, I would like to know the format that you used to get the SQL to...
December 20, 2013 at 1:19 pm
Thanks so much for your replies. I later solved the problem by applying an index in one of the table columns.
EO
December 19, 2013 at 12:24 pm
Please my intention is to show the code that I have problem with in a different colour but it didnt work. so please ignore the colour code.
I want to know...
December 19, 2013 at 12:01 pm
It is not a stored procedure. What I want is for the user to be able to select multiple offices in the report. I initially included a portion of the...
December 10, 2013 at 2:59 pm
There's actually no problem with the code for single value. I want to know how to tweak the code to work for multi-select so users can choose all offices. I...
December 10, 2013 at 2:51 pm
Viewing 15 posts - 16 through 30 (of 48 total)