Viewing 15 posts - 871 through 885 (of 5,502 total)
A rephrase of the original question without providing any additional information doesn't really help any further.
And no, it still doesn't make sense to me.
However, even if there might be no...
November 5, 2011 at 2:29 pm
Based on what formula should the percentage value be calculated?
November 5, 2011 at 2:25 pm
It's hard to help based on the information provided so far.
Please read the first link in my signature and provide some sample data (together with table def and expected results)...
November 5, 2011 at 2:07 pm
What exactly is your question?
In general, formatting should be done at the presentation layer.
If it needs to be done using T-SQL, there are several options.
Which one could be used in...
November 5, 2011 at 2:05 pm
I forgot: you might also want to add an index on dt with balance included to improve performance. Otherwise there'll be additional sort operations that should be avoided.
November 5, 2011 at 10:42 am
Here's a slightly different approach based on the CROSS APPLY method.
One thing making the code more complex is the "interpretation" of the very first balance being the start balance of...
November 5, 2011 at 10:39 am
bitbucket-25253 (11/5/2011)
Have you looked at this article by Jeff Moden. It might give you enough info to solve your problem.
Ron, I don't think it's a running total scenario. It...
November 5, 2011 at 7:40 am
Based on your sample data, what would be the expected result?
November 5, 2011 at 7:23 am
Can you add a computed persisted column based on the run_time column to hold the date value only and add a unique constraint to it?
Probably a better performing solution than...
November 5, 2011 at 6:11 am
dm_tapas (11/1/2011)
Somebody has written from client side. Now it is giving problem to client . so they ask me to tune...
November 1, 2011 at 4:18 pm
Unfortunately, it's a rather common issue...
It seems like the SQL agent does not have appropriate permissions to execute the package.
One recommended solution is to add a proxy account with the...
November 1, 2011 at 2:44 pm
Did you try to insert the xml data into a table with an indexed xml column?
AFAIK, SQL Server does not calculate any statistical information on a variable. Therefore, it can't...
October 31, 2011 at 3:58 am
CELKO (10/27/2011)
October 28, 2011 at 10:41 am
Why don't you throw in a statement like "Well, we might need to look into alternative tools then. Have you (the vendor) ever heard of RedGate products?" 😛
October 27, 2011 at 10:52 am
It sounds like a Running Total scenario. Google might help to return a more detailed information.
Depending on the SQL skills available, the "quirky update" method might be an option,...
October 25, 2011 at 3:09 pm
Viewing 15 posts - 871 through 885 (of 5,502 total)