ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,781 through 6,795 (of 10,143 total)

RE: help with select

Mad-Dog (8/9/2011)
this syntax give me the right results but can it be change some how to start with a select first and not with "with cte as"?
THX
As John says, Yes...
^{“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

August 9, 2011 at 5:09 am

#1365757
RE: help with select

How about a little sample data, say 10 rows split across two day boundaries?
^{“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

August 9, 2011 at 2:40 am

#1365673
RE: help with select

Mad-Dog (8/9/2011)
Hi,
i've a table with 2 columns one log_event_num (int) and one log_event_time (datetime).
how i can write a select that will show me every day only one log_event_num per event?
THX
Do...
^{“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

August 9, 2011 at 2:29 am

#1365667
RE: Return a single row instead of multiple

uche_ezeribe (8/9/2011)
...
what i get now is
UserName FirstName LastName VacID vacancy Degree
-----------------------------------------------------------
joyr Joy ...
^{“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

August 9, 2011 at 2:24 am

#1365665
RE: use result from select as where

This will show you a way to do it.
-- test table
DROP TABLE #ContainerMemberDefinitions
CREATE TABLE #ContainerMemberDefinitions (ContainerID INT, Expression VARCHAR(MAX))
INSERT INTO #ContainerMemberDefinitions (ContainerID, Expression)
SELECT 15, '#Nodes.Caption LIKE ''%adsl%''' UNION ALL
SELECT 15,...
^{“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

August 8, 2011 at 9:53 am

#1365319
RE: use result from select as where

How do you know the two rows from the first query are ORred and not ANDed?
Do you have any restrictions over how you execute the SQL i.e. can you create...
^{“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

August 8, 2011 at 8:08 am

#1365234
RE: use result from select as where

Of course. Can you post the parts of the statement you wish to create, with a little more explanation?
^{“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

August 8, 2011 at 7:09 am

#1365191
RE: Today's Random Word!

Daniel Bowlin (8/8/2011)
Ready. Set. Commence Week.
Same time every day Dan. Have you had your shredded wheat?
^{“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

August 8, 2011 at 6:59 am

#1365179
RE: use result from select as where

Do you mean, construct the WHERE clause programatically client-side?
^{“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

August 8, 2011 at 6:52 am

#1365175
RE: use result from select as where

mickdunde (8/8/2011)
Hi there
I've looking for a way how to use result from a select as a where clause to another statement. As an example I have two tables, tblNodes and...
^{“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

August 8, 2011 at 6:15 am

#1365137
RE: MERGE statement to include new column that is an identity column. Don't know how to populate.

hxkresl (8/5/2011)
... I am migrating data into an identity column whose values cannot be wholesale reseeded. I have to maintain the associations between existing rows of information in the...
^{“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

August 8, 2011 at 4:16 am

#1365085
RE: Delete ON Self Join

Cities and states are different entities with different properties. Model them as parent and child tables.
This problem is only the beginning, it will get much worse if you continue...
^{“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

August 5, 2011 at 9:47 am

#1364463
RE: Today's Random Word!

Tom.Thomson (8/4/2011)
crookj (8/4/2011)
proboscis
haustellum
Malaria
^{“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

August 5, 2011 at 2:19 am

#1364141
RE: MERGE statement to include new column that is an identity column. Don't know how to populate.

hxkresl (8/4/2011)
...
merge mogknicker.mog.EnligtenmentSchemaMap as T
...
What?!! No, no. Classy mogs go commando.
^{“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

August 5, 2011 at 2:12 am

#1364140
RE: MERGE statement to include new column that is an identity column. Don't know how to populate.

hxkresl (8/4/2011)
.... Do you have experience or suggestions for getting rid of this error?
Helen
Check that the datatypes of the target table match those of the output columns of the SELECT...
^{“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

August 4, 2011 at 7:26 am

#1363633

Viewing 15 posts - 6,781 through 6,795 (of 10,143 total)