Viewing 15 posts - 7,216 through 7,230 (of 10,144 total)
GilaMonster (10/7/2010)
Alvin Ramard (10/7/2010)
I thought the next version of SQL was going to be 2011.
Not necessarily. No release date or name has been announced. The reason people have...
October 8, 2010 at 2:14 am
Alvin Ramard (10/7/2010)
CirquedeSQLeil (10/7/2010)
Steve Jones - SSC Editor (10/7/2010)
Plus beer's and BBQ...
October 7, 2010 at 9:04 am
Daniel Bowlin (10/7/2010)
Funny hat day at work.
Bowler.
October 7, 2010 at 7:10 am
WayneS (10/7/2010)
Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspxTime to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.
IMO,...
October 7, 2010 at 6:46 am
Brandie Tarvin (10/7/2010)
Chris Morris-439714 (10/7/2010)
INNER JOIN SOP30300
ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE AND RM20101.DOCNUMBR = SOP30300.SOPNUMBE
Are you absolutely sure that RM20101.DOCNUMBR should match to SOP30300.SOPNUMBE ?...
October 7, 2010 at 6:00 am
That's nicely condensed, Ken. I'd been working on a version
;WITH CTE1 AS (
SELECT BookID, StudentID, LoanDate, ReturnDate,
RowNum1 = ROW_NUMBER() OVER (ORDER BY BookID, LoanDate),
RowNum2 = ROW_NUMBER() OVER (PARTITION...
October 7, 2010 at 5:54 am
nadersam (10/7/2010)
Thanks
Create function [GetTableData] (@TableName varchar(50),@RowID integer)
returns table
AS
Declare @MySQL varchar(100);
Set @Mysql=...
October 7, 2010 at 5:06 am
christine.koh (10/6/2010)
If select the top(100000) records to update, will it continue to update the next top(100000)?
No, you would have to run it again. That's the point.
christine.koh (10/6/2010)
October 7, 2010 at 2:59 am
Tom.Thomson (10/6/2010)
Ray K (10/6/2010)
So whose towns have the best brew-pubs?Dunbar, East Lothian, Scotlan has The Eagle Inn (pub) with alses brewed locally by the Bellhaven Brewery
Belhaven gets my vote -...
October 7, 2010 at 2:53 am
So, what's this all about?
INNER JOIN SOP30300
ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE AND RM20101.DOCNUMBR = SOP30300.SOPNUMBE
Are you absolutely sure that RM20101.DOCNUMBR should match to SOP30300.SOPNUMBE ? Look at the join...
October 7, 2010 at 2:36 am
Here's a pretty version of your query which is much easier on the eye.
SELECT
'1060' AS bukrs,
'ZO' AS blart,
CONVERT(VARCHAR(35), RM20101.DOCDATE, 112) AS bldat,
CONVERT(VARCHAR(35), RM20101.POSTDATE, 112) AS budat,...
October 7, 2010 at 2:33 am
Brandie Tarvin (10/6/2010)
And on another note. Remember this: "It's just a rabbit."
Foodsource. <<Licks paws nonchalantly>>
October 6, 2010 at 9:07 am
Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).
October 6, 2010 at 8:49 am
vijay1327-891581 (10/6/2010)
1: Remove count(*) and replace it with count(any one INTEGER type column). Here all you are doing is checking if there is any row > 0
Since the two...
October 6, 2010 at 8:37 am
Ken McKelvey (10/6/2010)
Also, the trunc and sysdate functions suggest this is an ORACLE query.
Darn. :blush:
Wish I'd caught this, what a waste of a lunchtime.
October 6, 2010 at 7:46 am
Viewing 15 posts - 7,216 through 7,230 (of 10,144 total)