Viewing 15 posts - 151 through 165 (of 984 total)
It sounds as though you want the "DELETE FROM x JOIN y" type of query shown in the example D of the DELETE syntax - https://docs.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql#d-using-joins-and-subqueries-to-data-in-one-table-to-delete-rows-in-another-table
For example:
February 19, 2018 at 8:25 am
SQL Server 2014 Developer Edition is free - but you'll need to register. https://my.visualstudio.com/Downloads?q=SQL%20Server%202014%20Developer
See announcement for more details and links: https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/
February 19, 2018 at 3:01 am
Looks like you've passed blocksize 65563 instead of 65536... or is that a typo on your part?
February 16, 2018 at 5:16 am
Alas, I can't make it this year - I have a gig that weekend. They asked before Bits announced its dates for this year... :-/
February 12, 2018 at 2:25 am
From that input data, what output are you expecting / wanting?
January 30, 2018 at 2:05 am
This makes me wonder what you're looking at, because I saw very little spam when I got here this morning... Admittedly, there are about 25 "possible spam" emails in my...
January 23, 2018 at 8:02 am
If columns 17 & 19 are changed, what do you want to do? Fire the trigger, or not fire the trigger?
Either way, rather than checking all 20 column...
January 23, 2018 at 6:04 am
Something else to think about is what sort of disaster(s)...?
Are you talking about someone accidentally fat-fingering a query and updating all your product costs to be the same...
January 23, 2018 at 5:31 am
January 22, 2018 at 8:28 am
The _00000002_ etc is the column number in the table to which those statistics belong; the last eight characters are the object_id of the table (in hex).
January 17, 2018 at 7:43 am
January 15, 2018 at 3:13 am
January 12, 2018 at 9:19 am
January 11, 2018 at 8:34 am
If SSC did want to do a vote up/down function as well, the...
January 11, 2018 at 8:33 am
OK, so the next thing is for you to show us the schema - what are your table definitions? Is the field "ORDERDATEANDTIME" being stored as a datetime data type?
January 11, 2018 at 6:39 am
Viewing 15 posts - 151 through 165 (of 984 total)