ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,476 through 8,490 (of 10,143 total)

RE: Are the posted questions getting worse?

Bob Hovious (4/16/2009)
How could I have forgotten "Bride of the Thread?"
I LOVED Kate Beckinsale in the last remake. 😛
What? Only in that one movie?
^{“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

April 16, 2009 at 8:20 am

#978888
RE: Prevent locking a database

Pieter (4/14/2009)
I am aware that SELECT INTO causes the meta-data to be locked and make it unavailable for review.
Hi Pieter, there was a discussion about this quite recently which...
^{“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

April 16, 2009 at 5:57 am

#978735
RE: CASE function for Null values

SELECT ISNULL(ITPolicyName, 'No Policy Assigned') AS Category,
COUNT(*) AS TotalNumber
FROM table1
GROUP BY ISNULL(ITPolicyName, 'No Policy Assigned')
ORDER BY 2
^{“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

April 16, 2009 at 2:57 am

#978662
RE: Need Some Help in Query

Pakki (4/16/2009)
You should start thinking about writing the query in SQL 92 format.Thanks.
Using this excellent suggestion, try the following:
SELECT R.RID, F.from_dos, T.ICDCOD
--MIN(CONVERT(DATETIME, F.from_dos, 12)) AS EARLYRDATE
FROM R7541f6 F
INNER JOIN DISABILITYCALIMS...
^{“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

April 16, 2009 at 12:34 am

#978625
RE: Are the posted questions getting worse?

RBarryYoung (4/16/2009)
So tired... Answered ... so many ... posts... must get... sleep. then answer... more posts... zzzzzzzzzzzzzz...
Hey get some rest Barry! Like the first part of your article,...
^{“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

April 16, 2009 at 12:14 am

#978619
RE: Problem with UPDATE subselect

adonavon (4/15/2009)
Hello, I was wondering if anyone could help with this T-SQL problem that is stumping me.
Here is the current UPDATE statement that works; the subselect only returns 1 result...
^{“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

April 15, 2009 at 3:38 pm

#978463
RE: Help me in writing query

dheer (4/15/2009)
I have one table name CALIMS and i want to select 2 columns
SELECT RID ,DATE
FROM CALIMS
WHERE DAG='Y'
and again want to select the data from the same same talbe...
^{“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

April 15, 2009 at 11:38 am

#978281
RE: Select a column into diferents columns depending of the value

You're welcome!
There's no option for marking a thread as "answered" - they're all kept open for reference. Also, someone could come along yet with a killer solution.
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

April 15, 2009 at 10:52 am

#978253
RE: how to compare values in t-sql 2005

Thank you for providing the sample data. Your requirement is very difficult to understand, there is probably a language difference. Can you please provide a sample of what you expect...
^{“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

April 15, 2009 at 10:11 am

#978217
RE: Select a column into diferents columns depending of the value

Aha, gotcha! Thanks for the clarification. Blonde moment. Try this:
DROP TABLE #temp
CREATE TABLE #temp ([ID] INT, Meal VARCHAR(20), [Order] INT)
INSERT INTO #temp ([ID], Meal, [Order])
SELECT 1, 'Tomato Soup', 1 UNION...
^{“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

April 15, 2009 at 9:48 am

#978193
RE: Select a column into diferents columns depending of the value

@puyinc (4/15/2009)
There is no formal relationship between FirstOnes (entrances) and SecondOnes (Main Dishes). The resultant query will be something like a Restaurant's Menu, where one column will be Entrances...
^{“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

April 15, 2009 at 8:49 am

#978140
RE: Are the posted questions getting worse?

Alvin Ramard (4/15/2009)
Chris Morris (4/15/2009)
Anyone for pork chops?
Maybe. How are you cooking them? ANSI or ASCII?
Bit by bit - and of course they need those dandy RBARS on...
^{“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

April 15, 2009 at 7:47 am

#978075
RE: select query modification

bvinay57 (4/15/2009)
Hi
i am retriving data using myeclipse7.1 editor in this editor ISNULL(STATE, 'all') or COALESCE(STATE, 'all') these functions are not working.wat can i do.
I'm very sorry bvinay, I have...
^{“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

April 15, 2009 at 7:39 am

#978065
RE: Are the posted questions getting worse?

Anyone for pork chops?
^{“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

April 15, 2009 at 7:25 am

#978055
RE: How to use an OUTPUT parameter and check if a record exists

krayknot (4/15/2009)
If you are using any variable(s) as an OUTPUT varialbe in stored procedure, it means that variable will carry the output of the stored procedure.
Are you saying 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

April 15, 2009 at 7:24 am

#978054

Viewing 15 posts - 8,476 through 8,490 (of 10,143 total)