ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,806 through 8,820 (of 10,143 total)

RE: A sproc

DECLARE @startingFrom nchar(33), @destination nchar(33), @RowNum int
SELECT @startingFrom = [YOUR VALUE IN HERE], @destination = [YOUR VALUE IN HERE]
DECLARE @FlightsLook TABLE
( ...
^{“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 12, 2009 at 9:53 am

#943012
RE: Are the posted questions getting worse?

GilaMonster (2/12/2009)
Eeep..
http://www.sqlservercentral.com/Forums/FindPost655667.aspx
I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?
Gees, it took me months of reading to decide on an appropriate...
^{“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 12, 2009 at 8:54 am

#942941
RE: A sproc

feodon (2/12/2009)
But the fff is defined 3 lines beneath the
Insert Into ,
Wasn't that correct ?
and about the GO statement , thank you for giving me such hints
Yes it is, but...
^{“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 12, 2009 at 8:27 am

#942906
RE: A sproc

In addition to the above, the table alias [fff] has not been assigned in this statement:
-- procedure
SELECT * FROM @FlightsLook
JOIN Airlines aaa ON fff.airline_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 12, 2009 at 7:24 am

#942839
RE: Storing the result of a stored procedure to a table

Santhosh (2/12/2009)
Hi
In Linked Server(Access database)
Can we know which columns are having ntext data type?
(when i went through the sproc sp_columns_ex i came to know that
MEMO data type of...
^{“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 12, 2009 at 5:59 am

#942752
RE: Storing the result of a stored procedure to a table

Santhosh (2/12/2009)
Yes I got it...
For these kind of things we initially need to know how many columns the result set will be having right?
Thanks
Yes, and you can easily do 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

February 12, 2009 at 3:39 am

#942681
RE: Storing the result of a stored procedure to a table

This should put you on the right track...
IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL
DROP TABLE #Worksheets
CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30))
INSERT INTO #Worksheets
EXEC sp_tables_ex @ServerName
^{“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 12, 2009 at 3:12 am

#942668
RE: Are the posted questions getting worse?

carriem (2/11/2009)
I'm new to all this and I'm just beginning to learn how to create scripts for reports using SQL and Crystal reports. I found it interesting how some...
^{“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 11, 2009 at 9:16 am

#942258
RE: Are the posted questions getting worse?

GilaMonster (2/11/2009)
Andrew Reilly (2/11/2009)
Is it me or are these posts getting random ?
I've been noticing the same kinda thing. There's really weird stuff getting asked at the moment.
Anybody seen my...
^{“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 11, 2009 at 6:16 am

#942043
RE: error description

See here.
It would also be good practice to examine the query to establish if it can be optimised.
^{“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 11, 2009 at 3:57 am

#941970
RE: better solution than using the full outer join index

Sander A. (2/9/2009)
Interesting solution. But i don't see this working in my situation. In real world the columns of the statistics table and the kpi table are very different. So...
^{“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 9, 2009 at 7:40 am

#940480
RE: Are the posted questions getting worse?

Grant Fritchey (2/6/2009)
Oh there are individuals, but the culture seems different. The Air Force bases were always so clean & orderly & mannered where as, except for boot camp &...
^{“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 6, 2009 at 7:18 am

#939492
RE: Are the posted questions getting worse?

GSquared (2/6/2009)
Chris Morris (2/6/2009)
GSquared (2/6/2009)
Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I...
^{“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 6, 2009 at 7:16 am

#939491
RE: Display query results as a treeview

How about some sample data with that, Rob? 😉
^{“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 6, 2009 at 7:03 am

#939475
RE: Are the posted questions getting worse?

GSquared (2/6/2009)
Iay amay uenflay inay igpay atlinay. And speak/write attrocious Spanish. My French is worse than my Spanish. My English is abysmal, but I speak extremely fluent...
^{“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 6, 2009 at 7:01 am

#939472

Viewing 15 posts - 8,806 through 8,820 (of 10,143 total)