Viewing 15 posts - 2,746 through 2,760 (of 5,109 total)
At a guess, your column is not wide enough and you have disabled the growth property of the cell/column.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
I think the problem is a language barrier, however, I'm not entirely sure what you mean by your statements:
if Date in alias b is less than frdate than Amount...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
I may be recalling incorrectly, but, I think that SUM at that point will still be within your grouping. You should just be able to do:=Fields!PtCount.Value / Sum(Fields!PtCount.Value)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Firstly, what is the reason for having the nolock on you table? Is the table's data static, are no changes are happening on it while you are running this query?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
That's because what you're doing there is incorrect syntax. Your statement there is to return the data from the database @pDB, as in, the database is called "@pDB". You can't...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
That query doesn't look like it'll run either. Firstly, in your query, you refer to something not having the value ?0. What is "?0"? It's not a a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
What do you have your agent job set to on completion on step failure? I'll hazard a guess that you have it set as proceed to next step, rather that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Just a (unformatted) query isn't going to tell us anything about why your query is performing badly, and pictures of your query plan aren't useful (we can't interact with them)....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
What specifies what days show column B. Is it purely that it has a value of your parameter @p_date? If so, what you're looking for is a CASE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 2,746 through 2,760 (of 5,109 total)