Mar
16
awarded Good Question
Mar
12
answered Error "The object invoked has disconnected from its clients" - automate IE 8 with python and win32com
Feb
20
comment Getting ID of item after posting to a document library
what is a valid slug path in this scenario? i keep getting errors when i try and do this but i dont get any info about what is causing the error stackoverflow.com/questions/35523373/…
Feb
20
asked Adding items to SharePoint document library with web service
Feb
17
comment Why do my RAW (.nef) files have a reddish hue in Picasa 3?
@PhilipKendall I had not downloaded this despite having a nikon for years (picasa used to fork fine) but just did now and i think my raws may actually look even better through this!
Jan
26
awarded Popular Question
Nov
17
awarded Caucus
Aug
13
awarded Notable Question
Jul
31
revised occupancy reports for hospitals
added 1226 characters in body
Jul
31
answered occupancy reports for hospitals
Jul
31
answered sql - Query to return duplicate rows with some differing entries
Jul
30
comment Insert into Select does not insert the same data order correctly
someone asking this question:stackoverflow.com/questions/14424929/… "Preserving ORDER BY in SELECT INTO"
Jul
30
answered Add a default value in group by select in case a specific value is not present
Jul
30
answered SQL: Get the first value of a GroupBY Clause
Jul
29
comment Select every date where date is equal to today's date minus 1 day - Not working with dateadd on Month/year - T SQL
Just to clarify- leaving the column being filtered by untouched allows it to make use of the index, but are you saying that the are special optimizations for casting of datetime to date? (assuming as it must be used a lot)
Jul
29
answered Select every date where date is equal to today's date minus 1 day - Not working with dateadd on Month/year - T SQL
Jul
29
comment SQL Read Table Between dates, if nothing exists still write as empty
it is a new table that you add to the database. which database engine are you using? normally your alternatives to adding a table like this are using a cursor or doing this outside of the DB. maybe there is some new methods in later db engines that give other options.
Jul
29
comment PARTITION BY Name, Id to compare and detect problems
You are very welcome, i hope it helps. you have a working SQL fiddle that pretty clearly specifies everything. questions here are meant to be specific rather than ongoing support with a task.
Jul
29
comment SQL Read Table Between dates, if nothing exists still write as empty
You need to create the date table, its like a number table: dba.stackexchange.com/questions/11506/… if you give some example data in tables (preferreably in SQLFiddle: sqlfiddle.com) with expected output it will save a lot of time.
Jul
29
comment PARTITION BY Name, Id to compare and detect problems
This is because its not null its an empty string, you just have to code for that too. I have updated the answer but please mark this question answered and ask a new question is you are having subsequent issues like this.
1 2 3 4 5