ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,031 through 9,045 (of 10,143 total)

RE: A t-SQL statement store results in an excel sheet

nabajyoti.b (1/2/2009)
i am well aware of what SSIS can do.
But i wanted to direct two variables to an excel sheet.
In that case, the article will show you how, with examples.
^{“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 2, 2009 at 4:40 am

#920179
RE: Doubt in sql-functions

venki.ffcl (1/2/2009)
dear friends,
Can i use if condition in function ?
Please give me a example
thank you
Can you explain how you expect to benefit from putting a simple query into a function?...
^{“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 2, 2009 at 4:38 am

#920177
RE: A t-SQL statement store results in an excel sheet

nabajyoti.b (1/2/2009)
what is a t-sql statement to store the sql results in an excel sheet.
suppose i have two valieables @s-2 and @b-2
normally i use select @a to display the value...
^{“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 2, 2009 at 4:18 am

#920173
RE: Joining Query Results To Exploded Query Results (w/o Cursor?)

larsosman56 (1/1/2009)
Hoping for some assistance. I have been working this for weeks, looking into recursive CTEs, cursors, etc.
My first query returns a result set, but I want to pass...
^{“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 2, 2009 at 3:56 am

#920168
RE: Help with datetime sql

Adi Cohn (1/2/2009)
When you use function in the where clause on the column, the server can’t use any index that was created on that column. Although the queries...
^{“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 2, 2009 at 3:41 am

#920161
RE: SQL Help Required!!

sarran.achari (1/1/2009)
Thanks for your help Gurus.
You're welcome. Is your problem solved?
^{“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 1, 2009 at 5:21 am

#919938
RE: SQL Help Required!!

I reckon this should do it.
[font="Courier New"]DROP TABLE #Temp
CREATE TABLE #Temp ([Month] CHAR(8), Country CHAR(2), [Tran] INT)
INSERT INTO #Temp ([Month], Country, [Tran])
SELECT 'Jul 2003', 'US', 1271 UNION ALL
SELECT 'Jun 2003',...
^{“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 1, 2009 at 4:27 am

#919928
RE: SQL Help Required!!

Can you post a sample of what you expect your output to look like?
^{“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 1, 2009 at 3:55 am

#919922
RE: My Website's ready!

Brandie Tarvin (12/31/2008)
ACK!
I can't spell? THE HORROR!!!
Thanks, Andrew. I'll get that fixed. @=)
Good lord Brandie, how do you find the time to do all of this stuff?
It's a...
^{“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

December 31, 2008 at 5:05 am

#919554
RE: CTE Constant

josemyj (12/30/2008)
These values are chosen arbitrary by the decision support department depending of the way the butterflies move through the window when it rains...
So they are randomly chosen from a...
^{“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

December 30, 2008 at 8:51 am

#919088
RE: CTE Constant

How does SQL Server get these values? One at a time? As a file/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

December 30, 2008 at 8:30 am

#919078
RE: CTE Constant

josemyj (12/30/2008)
I didnt said they were consecutive, it was just an example. I have a 4000 rows table whose primary keys are used for filtering that way.
No 4000 columns... Only...
^{“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

December 30, 2008 at 6:32 am

#918986
RE: CTE Constant

josemyj (12/30/2008)
And sorry if my english is confusing, not native language.
No need to apologise, we'll get there.
Your first post said you wanted a temporary table or CTE to provide consecutive...
^{“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

December 30, 2008 at 5:24 am

#918945
RE: CTE Constant

So...you need a simple list of integers, from 1 to about 2000? Is there anything else?
^{“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

December 30, 2008 at 4:33 am

#918916
RE: CTE Constant

josemyj (12/30/2008)
¿What do you think about this?
;with CTETable (Field) as
(
Select 1 union all Select 2 union all Select 3 ... union all Select n)
)
select * from CTETable;
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

December 30, 2008 at 4:06 am

#918910

Viewing 15 posts - 9,031 through 9,045 (of 10,143 total)