Viewing 15 posts - 1,066 through 1,080 (of 1,228 total)
GilaMonster (10/25/2010)
Tom.Thomson (10/25/2010)
I'm definitely one of those who prefers a quick solution without work. Essentially I'm extremely lazy.I think most good developers are to some degree.
Well I... nah I...
October 26, 2010 at 10:23 am
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...
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...
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>
...
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...
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...
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,...
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...
October 26, 2010 at 8:36 am
wardy (10/22/2010)
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
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.
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?
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....
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...
October 26, 2010 at 3:53 am
Paul White NZ (10/24/2010)
October 25, 2010 at 2:18 pm
Viewing 15 posts - 1,066 through 1,080 (of 1,228 total)