Stack Exchange

I have two tables 1.Product table having columns prod_code alert_limit prod_description 2.Daily_data table having columns prod_code used_today date stock_left How should i join these two tables to get recent records of each product on the basis of date ? I have tried SELECT p.*, d.* FROM product p JOIN daily_data d ON (p.product_code = d.prod_code) LEFT OUTER JOIN daily_data d2 ON (p.product_code = d.prod_code AND (d.date < d2.date OR d.date = d2.date AND d.prod_code < d2.prod_code)) WHERE d2.prod_code IS NULL; but the above is giving me one recent row of the last product added Let's block ads! بخوانید...

I have an SQL select, that gives two rows back. The SQL update gives the error message 1093 back; mysqli error: [1093: Table 'HD_TICKET' is specified twice, both as a target for 'UPDATE' and as a separate source for data] update HD_TICKET, HD_STATUS as T5 set HD_TICKET.HD_STATUS_ID = T5.ID, HD_TICKET.TIME_OPENED = IF(T5.STATE = 'opened', NOW(), HD_TICKET.TIME_OPENED), HD_TICKET.TIME_CLOSED = IF(T5.STATE = 'closed', NOW(), HD_TICKET.TIME_CLOSED), HD_TICKET.TIME_STALLED = IF(T5.STATE = 'stalled', NOW(), HD_TICKET.TIME_STALLED), HD_TICKET.SATISFACTION_RATING = IF(T5.STATE = 'closed', NULL, HD_TICKET.SATISFACTION_RATING), HD_TICKET.SATISFACTION_COMMENT = IF(T5.STATE = 'closed', NUL...

I have a table of 500 million rows on SQLServer 2016. I calculate that each row should take up 12 bytes, total size should be in the order of 6GiB. However the actual size is over 10 GiB. After ruing dbcc showcontig ('[Table]') with tableresults I see the the MinimumRecordSize and MaximumRecordSize is 19 bytes and the AverageFreeBytes is 11.023 bytes. The table is defined as the following. CREATE TABLE [dbo].[Table]( [Key] [binary](7) NOT NULL, [Value] [binary](5) NOT NULL ) ON [PRIMARY] CREATE UNIQUE CLUSTERED INDEX [ClusteredIndex-Key] ON [dbo].[Table] ( [Key] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING ...

I have six SQL Server 2014 servers. I am not using TDE, Transparent Data Encryption, on any server. I would like to be able to take an encrypted backup of a database on ANY server and restore that backup to ANY OTHER server. What actions do I need to take on each server with the service master key, master database key, and certificate? I would like to use the minimum number of keys, certificates, and backup files for these keys and certificates. What actions do I need to take if I add an additional SQL Server 2014 to the group? Thank you all. Server Fault and Stack Overflow have helped me many times in the past. Let's block ads! بخوانید...

We have maintained one MySQL master server and two slave MySQL server. One of the MySQL slave server was down for more than a week. I tried to re-import all the database and restart the slave. But got the error 1594: MySql Version (Master): mysql Ver 14.14 Distrib 5.7.13 MySql Version (Slave): mysql Ver 14.14 Distrib 5.7.13 Replication method: GTID based Steps followed to re-import the DB and start the slave: mysql>stop slave; mysql>reset master; shell>mysql -u root -p < masterdbdump.sql mysql> start slave; Slave status after this: mysql> show slave statusG *************************** 1. row *************************** Slave_IO_State: Waiting for m...

I have a table which has 2 fields OS_ID and OZ_ID. I want to select combinations of OS_ID for different OZ_ID. What would be the query for that? Input OS_ID OZ_ID ---- ---- 1 1 2 1 3 2 4 2 5 2 6 2 7 3 8 3 9 3 Output combination row 1,3,7 1,3,8 1,3,9 1,4,7 1,4,8 1,4,9 1,5,7 1,5,8 1,5,9 1,6,7 1,6,8 1,6,9 2,4,7 2,4,8 ... Let's block ads! بخوانید...