Viewing 15 posts - 3,346 through 3,360 (of 6,486 total)
Jack Corbett (5/13/2008)
May 13, 2008 at 1:37 pm
GSquared (5/12/2008)
declare @FirstDate datetime, @LastDate datetime
select @FirstDate = CONVERT(VARCHAR(10),DATEADD(m,-7,GETDATE()),101),
@LastDate = CONVERT(VARCHAR(10), GETDATE(), 101)
SELECT
t1.Date_Taken, t1.Time,
t1.Main_ID, t1.WATER_ULEVEL
FROM dbo.tblSEL t1 INNER JOIN dbo.tblLocation t2
ON t1.Main_ID=t2.Main_ID
WHERE t2.Location='PRK'
AND t1.Date_Taken>=@FirstDate AND
t1.Date_Taken<=@LastDate
ORDER BY t1.Date_Taken, t1.Time
Interestingly enough...
May 13, 2008 at 1:23 pm
Jack Corbett (5/13/2008)
GSquared (5/13/2008)
Yes,...
May 13, 2008 at 1:12 pm
serge.laot (5/13/2008)
SELECT LEN(fieldname) FROM table;
you...
May 13, 2008 at 12:56 pm
developmentalmadness (5/13/2008)
- the Table-valued functions need to materialize their entire recordset before being able to return anything, so they can quickly "swamp" the memory area.
This is true for...
May 13, 2008 at 11:59 am
Solomon Rutzky (5/13/2008)
JohnG (5/13/2008)
inexplicably not able to handle outputting Varchar(MAX), being stuck instead @ varchar(8000), so you can't play with the full specturm should you need to.
That's a real bad...
May 13, 2008 at 11:41 am
developmentalmadness (5/13/2008)
May 13, 2008 at 9:33 am
I've tested with it rather extensively, and I think it's got a way to go before it becomes really useful. Although the resource management has been getting better, it still...
May 13, 2008 at 7:51 am
Jeff Moden (5/12/2008)
May 12, 2008 at 8:49 am
Keep in mid the "default" seems to be cookie-based (so moving from one machine to another will "reset" your options).
May 12, 2008 at 8:44 am
karthikeyan (5/12/2008)
Thanks for highlighting some good points.
Table doesn't have a single clustered index. But it have non clustered index on mid.
Will it help to resolve this running total issue ?
Janine,
Thanks...
May 12, 2008 at 8:05 am
Wyatt Eurich (5/12/2008)
I find that problems such as typo’s that occur in case-insensitive languages, harder...
May 12, 2008 at 7:49 am
MR - why don't you post what you came up with, and let's see if we can't make it behave somehow....
May 11, 2008 at 10:17 pm
ahh..criteria math. Try this
WHERE
case when criterion1 then 1 else 0 end +
case when criterion2 then 1 else 0 end +
...
May 11, 2008 at 5:15 pm
I don't believe you can return a cursor, and quite honestly - it's a good thing. What is it you're trying to do?
Perhaps a table variable, perhaps a temp...
May 11, 2008 at 10:41 am
Viewing 15 posts - 3,346 through 3,360 (of 6,486 total)