Viewing 15 posts - 61 through 75 (of 105 total)
I'm using sql_statement_started and sql_statement_completed. Microseconds would make sense. When you say "vote it up" where do you do that? Appreciate the help.
April 16, 2015 at 10:19 am
Cool and I'm assuming you have to restart sql services?
March 30, 2015 at 10:34 am
Appreciate the help. It was user error. =) My query was missing some data. SSRS side the multi-value parameter did not include null values. Any...
March 24, 2015 at 12:12 pm
3.46 but the actual query sql statement is 3.45 which is the correct value.
March 24, 2015 at 10:12 am
I'm getting below value.
3.46000
March 23, 2015 at 5:29 pm
I was originally casting it as a decimal value, but SSRS is rounding the second decimal place value, so I thought I would try using a string to try and...
March 23, 2015 at 5:09 pm
No particular reason I can use char(), but I don't think that is the reason for it rounding a char value in SSRS?
March 23, 2015 at 4:59 pm
I guess my real question is there a way to publish an excel pivot table onto ssrs without having to write the sql pivot code in ssrs?
March 10, 2015 at 4:42 pm
I tried the trace no love. It does not catch anything I can use. I read some where that in PowerPivot in excel you click on analyze\connections\properties\definition and...
March 10, 2015 at 4:05 pm
I get a result of 0. Looks like a ASC null value? Is there a way to cast a ASC value null to certain char() data type? ...
January 16, 2015 at 1:08 pm
Thanks Scott, I think I got it. I did what you did, but I used a pivot statement to get my rows of column names as columns so can...
January 14, 2015 at 12:42 pm
I'm not concerned about the records I'm updating in the update statement, I'm trying to get the actual update statement to be constructed dynamically and have it execute. Hope...
January 9, 2015 at 12:17 pm
Thank you all I appreciate the feedback. I go a lot of good ideas.
January 8, 2015 at 1:12 pm
Thanks all for your input really appreciate it. I think I have good idea of what people are getting at and makes sense.
January 8, 2015 at 10:40 am
Thanks guys for the informative information! Phil thanks for the link that makes a lot of sense. Appreciate the information.
June 20, 2014 at 10:13 am
Viewing 15 posts - 61 through 75 (of 105 total)