We have tables name with Date fields, Like table_name_yyyy_mm_dd. Wanted to analyze tables older than two days using procedure and come up with below proc. But Looks like select command with not …
Vague error when trying to add a foreign key to an existing table
I need to add a new foreign key to my table called starList. It currently does not have a foreign key relationship with the table called planetList. So I ran this command: ALTER TABLE [dbo].[starList] …
Column UID missing in custom TYPO3 v10 extension
While updating my TYPO3 project from v7 to v10, I encountered some difficulties with my custom extensions. Due to that I just tried to rebuild the demo extension from the official TYPO3 website: https://docs.typo3.org/m/typo3/book-extbasefluid/10.4/en-us/4-FirstExtension/2-create-folder-structure-and-configur…
Cheapest way to assign rows in order of sequence
I have a project where I have a list of barcodes, and I need to associate them to record numbers in the correct sequence based on a second column. My data looks like this: Coupon Code | Code Type | …
get top values in select
I have next ordered table: types count soft 7 lite soft 5 middle soft 4 hard soft 3 other 2 I need to select top values, sum of witch is 15+ (in my case 7+5+4 > 15) …
Invalid Number ORA-01722
I have problem in my query that I always get this kind of error ORA-01722: invalid number Whatever I try to doesn’t work. The query is here SELECT * FROM ( SELECT p….
merge values in select
I have next part of query: SELECT types, count FROM … Result is next: types count soft 3 lite soft 2 middle soft 7 hard soft 2 other 5 what I need is to merge results …
Combining sql queries together
I am trying to simplify my current query code. Is there a simpler way of combining both queries into one? Here is what I have tried so far. Although it seems really messy and clunky. This query …
Planning to Move TFS (Team Foundation Server 2013) from existing domain to new domain
I am planning to move my current TFS (Team Foundation Server 2013) environment from one domain to another domain, currently I am reading Microsoft articles on moving but i am planning to clone the …
Why were all rows deleted when trying to delete old rows with date query
I have a table with column name date of type timestamp I’m trying to delete old rows with the following query: delete from my_table where date<(now()-'30 days'::interval) but all rows are deleted. …