Hi there~<br /><br />I need a help on SQL queries in order for me to show out the previous past 3 months or 6 months information.<br /><br />Eg: If i...
Haha.. Sure a lot of times one. But important is we learn from mistake right? [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] Feel great...
Thanks KHTan for showing me the missing part of the coding.[<img src='/community/emoticons/emotion-2.gif' alt=':D' />] Sorry Frank for the silly...
SELECT YEAR(MIN(OrderDate)) AS [Year] , MONTH(OrderDate) AS [Month] , dbo.ISOweek(OrderDate) -...
Thanks KHTan for your codings~ It works nicely.. Thanks a lot~ ^_^
CREATE FUNCTION in BOL? Mind I ask what is BOL? How can I see the explanations??
Thanks KHTan~ It can manage show the example desired output. But when I apply to my real data, let's say the Order Date is 28th January 2007, it...
Thanks KHTan for your advice.The coding manage to produce the outputs already but the week is wrong. Cause supposely date 01.02.07 is consider Week...
Get the week number for the given date,<br />DATEPART(WEEK, OrderDate)<br /><br />subtract the week number for the first of the month,<br />-...
SELECT YEAR(DATEADD(WEEK, DATEDIFF(WEEK, 0, OrderDate), 0)) , MONTH(DATEADD(WEEK, DATEDIFF(WEEK, 0, OrderDate), 0)) , DATEPART(WEEK, (DATEADD(WEEK,...
Hi there~ I need some help on this problem. How should I write the SQL coding so that I could know the order that I get on that particular date is in...
Separate names with a comma.
