Forum Replies Created
Viewing 15 posts - 946 through 960 (of 1,183 total)
-
RE: Count Distinct
SELECT
dbo.[Web-Registration-Golf].Delegation AS Facility
,ISNULL(COUNT(dbo.[Web-Registration-Golf].StateID), 0) AS Lvl2NonPlayCount
FROM
dbo.[Web-Registration-Golf]
LEFT JOIN dbo.certifs
-- INNER JOIN dbo.certifs
ON...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Data Driven Subscriptions in SQL RS 2005 Standard
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: number parameter with respect to sp
This is a way to have multiple versions of one procedure. For example if you create the three procedures below:
CREATE PROCEDURE dbo.test;1
AS
SELECT 1
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Server 2008 June 2007 CTP
I'm not 100% on this, but I don't think the SSMS will install if 2005 SSMS is already on the machine. I believe, you need to uninstall 2005 SSMS and...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SQL Server 2008 June 2007 CTP
Ravi, in the release notes it states that you may have to manually removed the registry entry. Check the release notes/known issues for details. ...
[EDIT] From the release...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: How do I SELECT a column that STRICTLY matches a list
Lynn, unfortunately your solution seems to take quite a while to run when there are 100,000 + rows.
mrpolecat, your solution runs...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Include DateTime Even If No Corresponding Data
mrpolecat wins a piece of PIE for that one.....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: parsing huge string into stored procedure
OK, this is the 2005 forum, that's why I thought you had it.
As far as the file or string question....I don't know, but I'm someone else will answer that one...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: parsing huge string into stored procedure
Wouldn't VARCHAR(MAX) do the trick?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Can columns in a report be reordered programmatically?
I can't help you there, I've only just started .NET ...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Can columns in a report be reordered programmatically?
My first thought would be to pull the RDL file into memory and manipulate it then save and call the report. Since they're nothing more than XML files, I'm sure...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Using PIVOT without aggregates
Sorry, Anders is correct. You can use dynamic sql, but I try to avoid it...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Using PIVOT without aggregates
If ALL of your label_value's are known then yes, you can. If not, then it can not be done with PIVOT. That's the one downfall with PIVOT that I've come...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Using PIVOT without aggregates
Can you post the DDL for your table and some sample data along with required results? Your question is fairly straight forward, but without sample data it's hard to exactly...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Skipping rows from a dataset in a table on the report
Use two tables instead of Text boxes. Using two identical datasources with a filter on one for >0 and the other with <0.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 15 posts - 946 through 960 (of 1,183 total)