WayneS

Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 5,588 total)

RE: Dynamic Query

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 5, 2010 at 8:17 am

#1202778
RE: Read XML and Insert into Table with condition

First question: are you working in SQL 2008? I ask because you posted in a SQL 2008 forum, yet your xml code looks like SQL 2000 era. If you're in...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 5, 2010 at 6:04 am

#1202664
RE: insert error check

TRACEY-320982 (8/4/2010)
The data does not exist in main table
INSERT INTO MAIN_TABLE
SELECTCOLUMN1, COLUMN2
FROM TEMP_TABLE
WHERE NOT EXISTS
(SELECT * FROM MAIN_TABLE) W
WHERE
W.COLUMN1 = COLUMN1 AND
W.COLUMN2 = COLUMN2)
So i am doing a where...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 9:37 pm

#1202476
RE: Are the posted questions getting worse?

Jack Corbett (8/4/2010)
Just made my first "real" forum post in awhile. Had to pick a thread where Mr. Celko has already weighed in. http://www.sqlservercentral.com/Forums/Topic963903-391-1.aspx
Then it looks like you went...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 9:30 pm

#1202474
RE: Delete N Level Parent Child in Single Table

You can't use a CTE in SQL 7/2000 (which is the forum that you posted in).
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 9:26 pm

#1202470
RE: Pivot Table

In addition to what has already been mentioned, you might want to check out the cross-tabs and pivot articles (Parts 1 and 2) - links are in my signature. Part...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 9:25 pm

#1202469
RE: How do you do RBAR - Record Sets

Ken,
You're not going to find too many people here very wild about your cursor solution. There are many of us that will be willing to help you get rid of...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 3:05 pm

#1202393
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/4/2010)
I vote no. I like my watch. I don't want to have to buy a new one that has 10 digits.
Plus I have this cool clock:
Okay,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 2:46 pm

#1202385
RE: using a view in the SQL script of a Stored Procedure

I think the problem with using a view in a select statement is if the view doesn't have all of the columns that you need, and you end up joining...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 2:26 pm

#1202377
RE: MVC as it relates to SQL

Ray, thanks for that link. I'm also trying to look into MVC.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 12:52 pm

#1202323
RE: setting up a 2 node cluster

Perry Whittle (8/4/2010)
Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored drives...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 9:46 am

#1202162
RE: Modify Script - with no Temp Table

Yes. Did you even try to do this?
WITH TableCTE (ClientID, ProductName, ProdSize, MeasuredDate) AS
(
select ClientID, ProductName, CAST(Avg(ProdSize) AS DECIMAL(9,2)) as ProdSize,
convert(varchar(4),dateadd(month, datediff(month, 0, MeasuredDate),0),100) + convert(varchar(4),year(dateadd(month, datediff(month, 0,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 9:40 am

#1202160
RE: Help Re-writting Query to remove SubQuery

One slight improvement on Lutz's function:
CREATE FUNCTION [DSUSER].[BDP_WPS_Approvals] (@lWPSID AS INT)
RETURNS TABLE
WITH SCHEMABINDING
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 8:33 am

#1202117
RE: multiple updates

Sure. Just know that this will cause more transactions in the log file, and since you were concerned about the size of that...
Since you're continually updating the tables until they...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 7:55 am

#1202095
RE: multiple updates

I don't see anything wrong with it.
Another way would be:
declare @rowcount int
set @rowcount = 1
while (@rowcount > 0) begin
begin transaction
update top (10000) ...
set @rowcount...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

August 4, 2010 at 7:36 am

#1202087

Viewing 15 posts - 3,706 through 3,720 (of 5,588 total)