ps (12/16/2008)

---

I hope tbl_PBN_debugging table contains only one row per user. LogDate field gets updated...

Hi Sunil

Give this a try...SELECT DISTINCT UserName

FROM tbl_PBN_debugging

WHERE DATEDIFF(dd, Logdate, GETDATE()) < 91

...how many rows do you get?

This is "the number of users who have logged on within...

Hi David

Your question is answered here:

Because the ODBC-Driver makes "{fn CURDATE()}" beeing a char datatype the

conversion of "2006-08-01" to number results in an expression witch can be

convertet to "2006-01-08" as...

Hi Sunil

Please read the link at the bottom of my post, it will show you how to write table creation scripts and insert statements to provide forum users with sample...

Sunil, did you try my code?

i'm gonna stay carbon (dibaxide) neutral here

This is a longshot Michael and I apologise if "sucking eggs" comes to mind...does 2008 have timediff / timeadd functions?

Which setting was it, Panks?

sognibene (12/15/2008)

---

At some point we're going to have to evaluate having a "permanent" tally table in the DB. For now, it's only used in reporting and since it can...

Panks (12/15/2008)

---

I am working on SQL 2000 to 2005 migration project.

One of my proc uses the below script:

SET ARITHABORT OFF

UPDATE Prubond_MVR_Calc

SET MVRpct = (1- SFSurVal * (1 + Leeway) /...

You're welcome. I ran a quick test of both methods with a date range of nearly 40,000 days

DECLARE @StartDate DATETIME, @EndDate DATETIME

SET @StartDate = '12/1/1900'

SET @EndDate = '12/5/2009'

and both methods...

It's impossible to tell without knowing more about your tables, viji. Here's an alternative...

If you have a tally table, then this works a treat:

[font="Courier New"]SET DATEFORMAT MDY

DROP TABLE #myBalances

CREATE TABLE #myBalances (

      [TranDate] DATETIME,

      [TransactionAmount] money,

      [Balance] money)

      

INSERT INTO #myBalances VALUES ('12/1/2008',100,100)

INSERT INTO #myBalances VALUES ('12/3/2008',-60,40)

INSERT...

If you remove the unwanted conditions from the expression, then it's easier to see how it works...

WHERE locationkey IN (

SELECT locationkey

FROM dbo.ClientTbl_DimStores

WHERE...

viji (12/15/2008)

---

sorry i didn't because, for us '%' means 'all' and if storeattribute is '%' the storeattributevalue will also be '%' and there is no column in the database to...