Forum Replies Created
Viewing 15 posts - 991 through 1,005 (of 1,183 total)
-
RE: Change null values to zeros with PIVOT operator
Either of these should work fine...
SELECT
fcid
,species
,ISNULL([abam], 0) AS [abam]
,ISNULL([psme], 0) AS [psme]
,ISNULL([arme], 0) AS [arme]
FROM
...
______________________________________________________________________
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: question on joins...
Change your join from JOIN to INNER JOIN.
JOIN by itself is a LEFT JOIN which pulls all records from the left table (HOLDING in your case) and only the records...
______________________________________________________________________
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 Update Query
Mark,
DDL is "Data Definition Language" such as
CREATE TABLE [dbo].[AUDIT](
[AUDITID] [int] NOT NULL,
[PARTYID] [int] NOT NULL ………
To get the DDL for existing tables, right click 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: SQL Update Query
Joe,
I understand your point, the question could/should have been posted with more info, but it WAS enough information to give an answer to.
Again, there could have been more useful info...
______________________________________________________________________
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 Update Query
Mark,
It is a Newbie forum. That's why I Only gave one suggestion on future posts. You'll pick it up as time goes buy...
Sorry Joe, Not trying to slam you here,...
______________________________________________________________________
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 Update Query
UPDATE d
SET d.dcol3 = s.scol2
,d.dcol5 = 'Y'
FROM dest_tbl d
INNER JOIN src_tbl s
ON d.dcol2 = s.scol1
WHERE
...
______________________________________________________________________
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: a select question
Read up on the PIVOT keyword in BOL.
🙂
______________________________________________________________________
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: Update issues with subqueries
Happy to help.
______________________________________________________________________
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: Update issues with subqueries
You didn't include the table def for the "CSCounty" table But this should do the trick
UPDATE CSZ
SET SFZipIndexCode = SFMSAindexcode
______________________________________________________________________
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 VS 2005 to Edit SQL RS 2000 Reports?
Yes, it is a bit of useful info.
I only ran across it because we hired a new developer last year (I'll keep my opinion to myself...GRIN) But he thought...
______________________________________________________________________
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 VS 2005 to Edit SQL RS 2000 Reports?
Moe is right on one point. It's really up to you which route you want to go. Either use my method, or continue to use VS 2003 until the upgrade.
It's...
______________________________________________________________________
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 VS 2005 to Edit SQL RS 2000 Reports?
OK, you seem to be doing it right. What I would suggest, is to download "edit" a report that you haven't modifed in 2005 yet. Check it's namespace (xmlns), 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 VS 2005 to Edit SQL RS 2000 Reports?
MOE, I think you're missing my point. 🙂
You can edit the report in VS (any version). Save the file, locate the .RDL file on your PC, open in notepad 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: Using VS 2005 to Edit SQL RS 2000 Reports?
Did you edit the RDL in notepad and change the xmlns="" entry, and then upload through ReportManager?
This should work, I've done it many times.
You can't "Deploy" them from VS.
______________________________________________________________________
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: Adding Variaables To Subject Line
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
Viewing 15 posts - 991 through 1,005 (of 1,183 total)