Viewing 15 posts - 3,766 through 3,780 (of 10,143 total)
pietlinden (1/8/2014)
I got it to work, which is good, but I had to resort to <whisper>a dreaded cursor.</whisper> I know, it's a total cheat, but...
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 9, 2014 at 3:14 am
quindraco (1/8/2014)
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 8, 2014 at 9:27 am
Is [address] the only filter/parameter you are intending to pass in?
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 8, 2014 at 7:49 am
If you are still wondering why the last query in your script returns NULL for the fullfilename (or whatever), it's because you've been inconsistent with your datatypes.
-- Columns BOOK and...
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 8, 2014 at 7:40 am
Smash125 (1/8/2014)
Nice Chris.
Sometimes 😀
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 8, 2014 at 7:05 am
Your sample code generates errors:
Msg 208, Level 16, State 1, Procedure imageFileNameFromAddress, Line 5
Invalid object name 'dbo.imageFileFromBookPage'.
(1 row(s) affected)
(3 row(s) affected)
Msg 208, Level 16, State 1, Line 3
Invalid object name...
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 8, 2014 at 7:04 am
The whole of your output (everything in the SELECT list) is unrelated to anything else in your query. It looks like a bunch of columns but the syntax is incorrect....
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 8, 2014 at 6:48 am
Here's a proposal which reads the source table only once (you didn't see that table spool)
SELECT
[User ID], [Group ID], [Company]
FROM (
SELECT
[User ID], [Group ID] = MAX([Group ID]), [Company],...
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 8, 2014 at 6:12 am
elham_azizi_62 (1/8/2014)
Two tables main1,mytable are common in this fields:mytable.savabegh with main1.name,mytable.linknumber with main1.linknumber
ChrisM@Work (1/8/2014)
... including INSERTs to populate it with some data.
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 8, 2014 at 5:00 am
krishnamohan6669 (1/7/2014)
Found that more MAX I/O Waittime is recorded with spotlight,so trying to increase the virtual file size. should wait and see wether this occurs again.
Jeff is proposing...
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 8, 2014 at 3:33 am
elham_azizi_62 (1/8/2014)
rownumber main2.linknumber main2.savabegh main1.linknumber
1 29027 ...
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 8, 2014 at 3:00 am
tamer.h (1/8/2014)
Thank you ChrisM@Workit works perfectly.
Good, thanks for the feedback.
I'm now trying to copy the result of query to another table in another DB useing INSERT INTO but it...
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 8, 2014 at 2:42 am
elham_azizi_62 (1/8/2014)
main1:linknumber(int),name(varchar)
main2:linknumber(int),savabegh(varchar)
I want to have...
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 8, 2014 at 2:13 am
elham_azizi_62 (1/8/2014)
thanks for your reply guys.I create this sp:
ALTER procedure [dbo].[icanSP_Convert_GetEntityDependencies]...
As Gail has already pointed out, you're unnecessarily overcomplicating your code. Your stored procedure is the equivalent to this:
ALTER procedure...
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 8, 2014 at 2:08 am
skb 44459 (1/7/2014)
I need multiple SubRoutines within One Stored Procedure, so that they can share the Variables and...
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 7, 2014 at 8:17 am
Viewing 15 posts - 3,766 through 3,780 (of 10,143 total)