ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,281 through 8,295 (of 10,143 total)

RE: Creating view from stored procedure results

Hi Jacob
Sure it will work - I think you can use the same trick to get NEWID() into a function. Many sites however don't allow it (openrowset, linked servers etc).
Cheers
ChrisM
^{“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

January 5, 2010 at 10:14 am

#1099055
RE: Creating view from stored procedure results

Sometimes...
Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource'
^{“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

January 5, 2010 at 10:01 am

#1099044
RE: how to evaluate a string is true ??

sunpalozzi (1/5/2010)
New issue, I am testing the script. I defined the condition field to be varchar(500) in the table. I queried out the table into a cursor. ...
^{“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

January 5, 2010 at 7:03 am

#1098924
RE: Help with a join

What have you tried so far? Read the link in my sig.
^{“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

January 5, 2010 at 6:59 am

#1098916
RE: Creating dynamic sql stored procedure

chandrashekar.2512 (1/5/2010)
Hi Chris,
i am really sorry i did not get your point, But one thing i would like to tell you is i am not an expert...
^{“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

January 5, 2010 at 6:26 am

#1098889
RE: Creating dynamic sql stored procedure

chandrashekar.2512 (1/5/2010)
Thanks Jack,
I have attached my table and structure details in as txt file. please find it.
As you told i have created tables structure, since i have 5 to...
^{“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

January 5, 2010 at 2:15 am

#1098799
RE: Normalize data using Pivot WITHOUT using Aggregate function

Jeff Moden (1/4/2010)
The reason why it took so long is because, in the presence of a triangular join, it must spawn over 405,000,450,000 rows. To put it more succinctly,...
^{“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

January 4, 2010 at 9:27 am

#1098505
RE: Creating dynamic sql stored procedure

Lynn Pettis (1/4/2010)
Agree I do, with Jack.
Please provide the table structure, sample data, expected results, and what you have done so far to solver your problem.
oot thgir etiuq!
^{“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

January 4, 2010 at 7:29 am

#1098415
RE: Creating dynamic sql stored procedure

chandrashekar.2512 (1/4/2010)
Dear all,
I need to create dynamic stored procedure in which,
i need to select id from one table,should be passed to where condition of another sql statement. This should work...
^{“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

January 4, 2010 at 7:19 am

#1098406
RE: Need help with a SQL Query

Please provide sample data scripts. The link below will show you how to do this.
^{“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

January 4, 2010 at 6:45 am

#1098381
RE: Include count of zero in query

SwePeso (1/4/2010)
Thank you. I thought I should post the link so that no more double unneccessary work is done.
I suggested your approach first, but after som clarifications, I saw that...
^{“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

January 4, 2010 at 6:37 am

#1098377
RE: Normalize data using Pivot WITHOUT using Aggregate function

Hi Justin
This solution has a triangular join, notorious for scaling poorly - but over a day! Blimey. The solution I posted earlier doesn't, so may be worth a try. If...
^{“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

January 4, 2010 at 6:34 am

#1098375
RE: Include count of zero in query

SwePeso (1/4/2010)
Also see
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137844
Nice answer, Peso.
^{“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

January 4, 2010 at 6:09 am

#1098366
RE: Include count of zero in query

Hi Steven
Please modify the code below to provide sufficient sample data to return your required result set.
-- Set up test data
-- “CompetencyImportanceData“
-- For each JobID, the table contains ImportanceScoreBand values...
^{“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

January 4, 2010 at 5:35 am

#1098352
RE: Creating view from stored procedure results

grngarlapati (1/4/2010)
Hi,
I have a tool in .NET which accepts only views but i have some procedures which returns some result sets but Id is common in all the result set...
^{“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

January 4, 2010 at 4:43 am

#1098341

Viewing 15 posts - 8,281 through 8,295 (of 10,143 total)