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

Feb
7
comment SQL Calculated Field in both SELECT and GROUP BY clause
@11684: It does, why?
Feb
7
comment SQL Calculated Field in both SELECT and GROUP BY clause
Unless you also know about CROSS APPLY.
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 approved 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 approved 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 approved 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 approved 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?