1,720 reputation
621
bio website
location Ukraine
age
visits member for 2 years, 9 months
seen 4 hours ago

Jan
31
awarded  Outspoken
Jan
22
comment UPDATE … FROM … syntax for iSeries for a MS SQL Server developer
In each case your statement is simply UPDATE ... SET ..., not UPDATE ... SET ... WHERE .... Therefore it will affect every row, as it has no filter. (You do have a WHERE clause there but it applies to the subquery. You can't filter the outer query's rows from within a correlated subquery. Well, if iSeries did allow that, that would be very extraordinary. And confusing.)
Jan
15
revised Select rows based on latest date with multiple joins
incorporated the query in question
Jan
15
suggested suggested edit on Select rows based on latest date with multiple joins
Jan
14
awarded  Civic Duty
Jan
7
comment joining two tables and counting joined rows
Your query seems to return the expected result for the data samples shown. Please show an example where the query doesn't work as expected.
Jan
3
comment databasename_indx.ndf file not referenced but can't delete
@MartinSmith: I think the issue is about whether the .ndf can be deleted/truncated/whatever without resorting to purging old data, i.e. whether it actually contains data or not.
Jan
3
revised SQL server agent job built on SSIS package not working
typos, orthography, product name corrections, formatting
Jan
3
suggested suggested edit on SQL server agent job built on SSIS package not working
Dec
23
revised Cast to date is sargable but is it a good idea?
removed a duplicate word, capitalised a name
Dec
23
suggested suggested edit on Cast to date is sargable but is it a good idea?
Dec
17
revised SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
minor formatting & grammar, some punctuation & typos
Dec
17
reviewed Reviewed Cassandra - Query a column with collection type
Dec
17
comment Cassandra - Query a column with collection type
The only manual I've found so far doesn't seem to provide a direct answer to this, but perhaps this syntax would work: SELECT * from data_points WHERE properties['band'] = 'Beatles';?
Dec
17
suggested suggested edit on SQL Server: How to get the responsiveness of a trigger, without blocking the transaction that fires the trigger?
Dec
13
comment In SQL Server, how to launch a python script from an insert trigger?
If you are firing the Python script from the trigger, you will be firing it while the transaction is still not committed. The script will not know whether the transaction is going to complete successfully or not.
Dec
6
awarded  Critic
Dec
6
reviewed No Action Needed Is there are way to use Fine Grain Auditing to record Varray bind values?
Dec
3
comment Why does SQL Server require the datatype length to be the same when using UNPIVOT?
(Possibly unrelated but...) Same strictness is applied when comparing column types of the two parts of a recursive CTE.
Nov
23
comment How to do pivot for a particular result?
Have you tried PRINTing the @query instead of executing it to see what it looks like in the end? That could give you some ideas about what specifically could be going wrong when building the dynamic query.