Stack Overflow
Stack Overflow

Questions tagged [tablename]

143 questions
0
votes
0 answers

Can you reference a table name in a formula based on the value in another cell?

I'm creating a workbook to track stats for a hockey team. On the first sheet I have all of the teams listed along with their players. Each team is a table and the table name is the name of the team (https://i.stack.imgur.com/24pOw.png) On the second…
flessiak
  • 1
0
votes
0 answers

table name is generated in lowercase and underscore when using spring boot and postgresql

package com.example.demoo.domain; import jakarta.persistence.*; @Entity(name = "RedFlag") @Table(name = "RedFlag") public class RedFlag { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "red_flag_id") private…
JeGonise Mohammed Amine
  • 1
0
votes
0 answers

writing an select query when you dont know the full name of a table

Our database runs a report on a job every day, the results of which go into a table which the database creates each day. The problem is the table it creates is HB975_111111, then the next day it will create a new table HB975_111112 and so on. I am…
Carl Butterworth
  • 13
  • 2
0
votes
0 answers

Change tablename of entity on-the-fly

I want to modify the mapping of an entity to a table, the moment I use the model, not at design time. Is this possible? Context: I have an entity 'ProductPicture' mapped to its table with the same name this table is actually an inventory of…
Pascal Declercq
  • 41
  • 4
0
votes
1 answer

How to combine asterix syntax with table abbreviations

Is it possible to combine * syntax with table abbreviations? I want to do something like: "SELECT subfunds.* FROM subfunds S" + " INNER JOIN funds F ON S.id_fund = F.id" + " WHERE F.fund_short IN('" + stSQLFundList + "')" The above code gets a…
user962915
  • 109
  • 1
  • 2
  • 9
0
votes
3 answers

TableName of the result query

When the result of a query exists, I want to know the name of the row(s) that have the correct results: $query = "SELECT Id FROM Programacao WHERE ID = 1"; $curDate = date("Y-m-d H").':00:00'; $query = "SELECT Id FROM Programacao WHERE…
Vinicius Albino
  • 743
  • 2
  • 8
  • 21
0
votes
0 answers

Are table names case sensitive in Heroku Postgres add-on?

I migrate to Heroku Postgres with module.exports = { async up(queryInterface, Sequelize) { await queryInterface.createTable('users', { id: { allowNull: false, autoIncrement: true, …
fjorwb
  • 1
  • 2
0
votes
0 answers

Find table names that contain a specific column entry from another table

Using postgres 9.4 and PGAdmin III: I have a schema with 250 tables. 53 of these tables have a column value (int) that is sourced from another table. I would like to have a list of the table names and the row ID from the 53 tables that may contain a…
Stuart K. Smith
  • 59
  • 8
0
votes
0 answers

Select table name

In sql server I wrote the code below. My table name is Finding and when i finished the query I want to see final situation with "Select * from Findings" code But its show me the first version of the table (with out calculated fields). Can you help…
datamind
  • 1
0
votes
2 answers

Rails 3 Plugin - Active Record table_name_prefix

Im having problem to use table_name_prefix on my projects. I have a main apllication in my project that have others applications as plugins, these plugins works like a subsystem from the main application. To organize the tables on database of the…
Alex
  • 23
  • 1
  • 6
0
votes
0 answers

remove duplicated files moved from database to hdfs with apache_nifi

i have a problem with apache nifi i want to move data from database to hdfs .i have one table year with one column when i move it i found a lot of files contain the same table year . what i have to do to remove the duplicated files i have used the…
ikram
  • 1
  • 1
0
votes
0 answers

How do I use view correctly or redirect table name to second name?

I am programming in C# and using a MSSQL Server for my databases. After years I got now the problem, that I realized my table name is not so good. For example: Old: DB_Orders New: DB_CS_Orders (CS = Computer Science Department) I am basically…
Reke Unhs
  • 9
  • 4
0
votes
1 answer

Using a dynamic table name with month+year (mmyy) SAS EG

Any help please? When displaying the variable vMonth, it is working but when concatenating it with the library name, the following issue is obtained. Program: %LET lastdaypreviousmonth = put(intnx('month', today(), -1, 'E'),mmyyn4.); %LET vMonth =…
hans rhubesch Govind
  • 1
0
votes
1 answer

Delete all tables with a certain prefix name in a SQL 2008 database programmatically

I have 3000+ tables in my SQL 2008 database with names like listed below, that all starts with tempBinary_, that I need to delete programmatically, how do I do that? I don't know if I prefer the solution in a SQL-script or with use of LINQtoSQL, i…
radbyx
  • 9,352
  • 21
  • 84
  • 127
0
votes
0 answers

take dynamic table name for inner join in SQL Query

My SQL Query is, SELECT EAL_TYPE, EAL_ID, ROW_NUMBER ()OVER(PARTITION BY EAL_TYPE,EAL_ID ORDER BY EAL_TYPE,EAL_ID,EAL_ACTION_TIME Desc)SL#, EAL_STATUS, EAL_ACTION_TYPE, EAL_CMPCODE, ESSET_Description, EAL_SHOW_IN_ALERT, …
Arya
  • 504
  • 2
  • 8
  • 31
1 2 3
…
9 10