Versions des environnements
Network:
Windows 2003 Server
>> but I have to solve another issue with skipping/ignoring completely empty weeks.
>
>What issue? It looks like we don't have all requirements yet. <s>
True, but I try to focus on the core of the problem and not the extra stuff.
>It sounds like you should determine min and max dates, then round to whatever period you use (week, months). Determine the number of days and start with REPLICATE(".",nDays). Then use STUFF() at position dDate-DMin+1 to replace the dot with character code. This would need to happen in a loop.
Wow, that's a completely different look at it that I never considered. VERY interesting.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement