ChrisM@Work

Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 10,143 total)

RE: View with errors still saved, and still works

Right-click on the view and select 'Script view as...', see if it's what you are execting.
Why would you want to convert this into a view?
Why does it have an ORDER...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 25, 2014 at 7:01 am

#1691854
RE: Insert with self reference

This should help you on your way. Post back if you are unsure of how to convert it into an update.
SELECT
po.[user_id], po.gen_userlevel, po.gen_supervisor, po.gen_approvelimit, po.gen_email, po.company_id,
'#' '#', --...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 25, 2014 at 2:03 am

#1691782
RE: Avoiding Row work in SQL - Part 2

mike 57299 (2/24/2014)
Luis Cazares (2/24/2014)
You can't chage that code to make it set based. You need to change the code from usp_make_record to accept several rows at a time.
Other than...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 9:35 am

#1691624
RE: script error

ramyours2003 (2/24/2014)
help me to resolve in sql 2005
Identify the simplest component of your problem and tackle it. Try running this:
CREATE TABLE #DBROLES
(
DBName SYSNAME NOT NULL ,
UserName SYSNAME NOT NULL ,
db_owner...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 7:27 am

#1691542
RE: Subtract value 2 from value 1 in sql

WITH cte AS (
SELECT userid, parentid
FROM user_detail
WHERE userid = '100002'
UNION ALL
SELECT t.userid, t.parentid
FROM user_detail t
INNER JOIN cte on cte.userid = t.parentid
)
SELECT
d.userid,
[DUE] =...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 7:04 am

#1691518
RE: script error

ramyours2003 (2/24/2014)
thanks for the replies can pls resend the script by modifing
Posters are always encouraged to participate. Have you tried moving the variable declaration?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 6:54 am

#1691510
RE: script error

FETCH NEXT FROM DBName_Cursor INTO @dbname
.
.
.
.
declare @dbname varchar(200)
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 6:33 am

#1691501
RE: Help with taking this script from primitive to dynamic

You're welcome - and it's great to hear that you are benefiting so much from visiting ssc 🙂
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 6:30 am

#1691498
RE: Help with taking this script from primitive to dynamic

pharmkittie (2/24/2014)
Thanks for your answer Chris. I very much appreciate the time you took to read my examples and write up a solution.
No worries. No solution yet...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 4:45 am

#1691479
RE: Help with taking this script from primitive to dynamic

-- Please use table aliases so folks can tell which columns are from which tables.
-- why do you have brackets around some of the columns? e.g. ([1_1]),([1_2]),...
-- Are all those...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 4:21 am

#1691470
RE: Avoiding Row work in SQL - Part 2

mike 57299 (2/23/2014)
Ok all,
...a cursor of data that I want to write out...
Could you be a little more specific e.g. how many rows? What's the client?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 2:03 am

#1691440
RE: t-sql 2008 nested case statements

wendy elizabeth (2/23/2014)
I have a question about understanding nested case statements in sql server 2008:
The sql looks like the folloiwng:
select numberofcases
from inventory
where inventory_cnt >...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 24, 2014 at 1:54 am

#1691436
RE: Are the posted questions getting worse?

GilaMonster (2/21/2014)
ChrisM@Work (2/21/2014)
GilaMonster (2/20/2014)
PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 21, 2014 at 9:26 am

#1691202
RE: Dynamic PIVOT HELP

Try EXEC (@QUERY)
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 21, 2014 at 7:24 am

#1691095
RE: Dynamic PIVOT HELP

Replace EXEC @QUERY with PRINT @QUERY and post the resulting message here.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 21, 2014 at 6:50 am

#1691076

Viewing 15 posts - 3,601 through 3,615 (of 10,143 total)