Viewing 15 posts - 16 through 30 (of 46 total)
In the sp we are doing a bunch of statistics related aggregations on user and date, so it was repeatedly querying the same tables, and many times the same records...
September 2, 2009 at 6:56 am
I would like the table to display all four fields or however many the query returns dependent on the parameters however it only display the first field.
Do you mean "display...
August 18, 2009 at 10:57 am
Requirements. Gotcha.
I don't have an elegant solution, but you could add both a single and a multi parameter to the report and make them both nullable. Then in...
August 17, 2009 at 2:52 pm
I too have had that problem, and all I've been able to determine is that RS gets stupid from time to time.
If you are certain your parameters are...
August 17, 2009 at 2:37 pm
Out of curiosity, why would you need to switch btw single and mult? Can't your users just select a single value from the multi-value dropdown?
August 17, 2009 at 2:33 pm
Thanks for the help people. I'll have to compare the two methods once we get the database fully loaded, but right now the left outer joins are a bit...
May 8, 2009 at 2:29 pm
My employer doesn't permit me do that (the object names in the sample are fake). Looking at the execution plan the two biggest cost % are an index scan...
May 8, 2009 at 12:21 pm
I feel that since getting a second monitor at my workstation, I have become more productive. It is just so convenient to have multiple things open at once. ...
March 20, 2009 at 7:28 am
I think unions are great! Sometimes there are record sets you just can't join..:D JK
As a couple of peole have stated, the American auto industry is exhibit A as...
March 6, 2009 at 7:33 am
I've never done this, but you might be able to use OPENROWSET() to select from your DBF file and stick that in a view.
February 11, 2009 at 2:49 pm
latingntlman,
An FYI that made me nuts the first time I had to import Excel to SQL. Excel uses Unicode data types for text fields, so in the SQL table...
February 3, 2009 at 10:17 am
If you are executing the dtsx package as a sql job, make sure that the credentials under which the job is running have modify permissions on the folder in which...
February 3, 2009 at 10:02 am
I just wanted to throw out an FYI that tripped me up with something similar to this. We are running 64 bit servers and there is no 64 bit...
February 3, 2009 at 9:22 am
I have a copy of SQL Server 2005 T-SQL Recipes (Wrox) that has tons of code samples for just about everything. The samples are really basic though, but give...
December 29, 2008 at 11:12 am
...does anyone remember that show Small Wonder? It just popped in there, and I couldn't keep it to myself.
December 19, 2008 at 7:56 am
Viewing 15 posts - 16 through 30 (of 46 total)