sql - Adjust Date to match saved day of week -

-

i have table stores startdate , name of day of week start date falls on. don't know why, bad design didn't create , can't change it. of course, have dates don't match day of week. make worse, day of week correct , start date incorrect. need adjust dates each row's startdate falls on row's dayofweek. can assume startdate minimum value target date first [dayofweek] after set startdate.

so example have rows (8/23/10 mon, 8/29/10 sun):

startdate    dayofweek ----------------------- 2010-08-23   monday 2010-08-23   tuesday 2010-08-29   thursday

in row 2 can see date supposed tuesday it's monday. need end this:

startdate    dayofweek ----------------------- 2010-08-23   monday 2010-08-24   tuesday 2010-09-02   thursday

i struggle when working dates, sql not strongest skill either. thanks.

stealing geofftnz's setup, , hoping "clever" method thinking of:

declare @baddata table(startdate datetime, [dayofweek] varchar(20)) insert @baddata values('2010-08-23','monday') insert @baddata values('2010-08-23','tuesday') insert @baddata values('2010-08-29','thursday')  select * @baddata  ;with nums (     select 0 n union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 ) update b set startdate = dateadd(day,nums.n,startdate)     @baddata b         inner join     nums         on             datename(weekday,dateadd(day,nums.n,startdate)) = [dayofweek]  select * @baddata

for third row, i'm getting date in september, not august, think result right , sample result incorrect?


Comments

Post a Comment

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table
Read more

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

ssh client with paramiko (python) -

-
# sshpy v1 s0urd # simple ssh client # irc.gonullyourself.org 6667 #code import paramiko import os ssh = paramiko.sshclient() ssh.set_missing_host_key_policy(paramiko.autoaddpolicy()) privatekey = os.path.expanduser('/home/rabia/private') mkey = paramiko.rsakey.from_private_key_file(privatekey) ssh.connect('78.46.172.47', port=22, username='s0urd', password=none, pkey=mkey) while true: pick = raw_input("sshpy: ") stdin, stdout, stderr = ssh.exec_command(pick) print stdout.readlines() ssh.close() when try run more 1 command error: attributeerror: 'nonetype' object has no attribute 'open_session' looks it's because @ end of while loop ssh.close() (thus closing session).
Read more