Can anybody see if this query can be written better?
SELECT a.AccountNbr, a.AccountName,
(SELECT SUM(b.DebitAmt) FROM b.Transactions as b WHERE b.acctid = a.acctid
AND DatePart(yyyy, b.TransactionDate) = 2004) as Debit,
(SELECT SUM(b.CreditAmt) FROM Transactions...
Does anybody know how to get ServerVariables(LOGON_USER) in ASP.NET?
I have an intranet application in classic ASP wherein I get the ntlogin of the user using ServerVariables(LOGON_USER) and then check their access rights to the application. This way, the user does not need to enter separate...
I have an text input field in my form that requires a valid date input (for birthdate). How would I do a date validation of this field in Javascript?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.