Viewing 15 posts - 1,066 through 1,080 (of 1,228 total)
mtillman-921105 (10/26/2010)
Steve Jones - SSC Editor (10/26/2010)
I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!
Good, then I'm glad I don't have...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 10:18 am
Or even this...
DECLARE @XML XML;
SET @XML ='
<NewsDTO>
<NewsList>
<NewsID>A4C13A4A-2350-4D21-AB06-9E2946182D39</NewsID>
</NewsList>
<NewsList>
<NewsID>A3613580-99C3-489D-9988-92E5F24BC8F7</NewsID>
</NewsList>
<NewsList>
<NewsID>F934D9F9-A73F-4ACF-B225-8A0ED7BAF8C4</NewsID>
</NewsList>
</NewsDTO>';
WITH...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 9:50 am
There's no need for the funky looping stuff for the update.
DECLARE @doc NVARCHAR(MAX)
SET @doc ='
<NewsDTO>
<NewsList>
<NewsID>A4C13A4A-2350-4D21-AB06-9E2946182D39</NewsID>
</NewsList>
<NewsList>
<NewsID>A3613580-99C3-489D-9988-92E5F24BC8F7</NewsID>
</NewsList>
...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 9:37 am
sharonmtowler (10/26/2010)
the queries took to long and were timing out the reports. the union or union all query returns to rows of data for one style
If the whole query returns...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 9:30 am
mikes84 (10/26/2010)
Now, If John and Jim are both DBAs in the IT department, their records in the Positions table could look like this:
ID, Position, Department
66, DBA, IT
67, DBA, IT
I need...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 9:14 am
Hi Sharon
Try to get into the habit of using table aliases, they make code like this very much more readable:
SELECT DISTINCT
b.DIVISION as COMPANY,
b.SEASON AS SEASON,
b.STYLE as STYLE,...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 9:07 am
harita (10/26/2010)
Hi, allthe code i have now selects only selected itemname but i want to select all he items can some change the code- thanks
WHERE IT.ITEMNAME IN ('xxx','xxx','xxx','xxx','xxx','xxx') AND
If you...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 8:36 am
wardy (10/22/2010)
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 8:20 am
UPDATE t SET (column in t) = somevalue
FROM #temp t
INNER JOIN News n ON n.news_id = t.news_id
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 8:14 am
Prassad Dabbada V R (10/26/2010)
Where is the question? or the topic itself is question?
It's the invisible man skiing.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 7:18 am
hosseini.mehran (10/26/2010)
So what is your suggestion?
Post the whole query. Could a doctor diagnose a sore throat from looking at a single toe?
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 7:14 am
Senthil Varadharajan (10/26/2010)
Hi,Is it possible to find the single user map to different table using SQL Query.
Thanks,
Senthil Varadharajan.
This isn't a properly formed question, it makes no sense as it stands....
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 3:59 am
sanujss (10/26/2010)
Total_No_Of_Items_Sold
I need to create a report summary. We pass a selling...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 26, 2010 at 3:53 am
Paul White NZ (10/24/2010)
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 25, 2010 at 2:18 pm
Jeff Moden (10/24/2010)
Heh... it's actually a darned clever method that you've come up with. And, it has the advantage of being documented! 😛
Sorry it's taken so long to...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 25, 2010 at 2:15 pm
Viewing 15 posts - 1,066 through 1,080 (of 1,228 total)