SOME USEFUL WEB SITES
For nice articles,
http://www.eggheadcafe.com
http://aspnet.4guysfromrolla.com
TRANSFER BIG FILES
They have the TransferBigFiles.com ready in just a weekend. Check this article.. Cant believe it... but true.. Good Job from them.
YouSendit.com can also do it but the guys behind TransferBigFiles said it's not reliable and pretty limited functionality.
http://blogs.axosoft.com/hamids/archive/2005/06/07/1202.aspx
FREE XP THEMES
Wanna download some good themes for Windows XP Check out the following link. you can get many themes for free. I tried Windows Vista and Royale theme. Royale theme is good but Vista is kinda ok. but worth trying it once. Image
http://www.softpedia.com/catList/26,1,1,1.html
Wednesday, September 21, 2005
Tuesday, August 30, 2005
SQL F1
-- FOR LAST DAY OF MONTH
SET @CurrentPeriodEndDate = CONVERT( VARCHAR, Month(@EndDate)) + '/' + CONVERT( VARCHAR, @LastDay) + '/'+ CONVERT( VARCHAR, YEAR(@EndDate))
-- FOR START DAY OF MONTH
SET @CurrentPeriodBeginDate = DATEADD(mm, DATEDIFF(mm,0,@EndDate), 0)
--EXAMPLE FOR USING ORDER BY IN UNION STATEMENT
SELECT C.COMPID,C.COMPANYNAME
FROM (
SELECT COMPID, COMPANYNAME, 1 As OrderCol
FROM COMPANY WHERE CUSTID = 0
UNION ALL
SELECT COMPID, COMPANYNAME, 2
FROM COMPANY WHERE TYPE = 'New'
UNION ALL
SELECT COMPID, COMPANYNAME, 3
FROM COMPANY WHERE TYPE <> 'New'
) C
ORDER BY C.OrderCol,C.CompanyName
Subscribe to:
Posts (Atom)
LinkWithin
