http://www.techonthenet.com/sql/tables/create_table2.php I have a very complex query that pulls in information from ~10 tables, I’d like to then print those results to a table. Here’s my attempt: Where [DATA OUTPUT TABLE] is intended as the new table name and [Data Export] is the name of the query…
Tag: sql
SP2-0552: Bind Variable “NEW” is not declared
I am trying to learn pl/sql triggers. I am trying to create a simple trigger by tracking tutorial http://www.tutorialspoint.com/plsql/plsql_triggers.htm but I got below error. I searched on the …
Hide characters in email address using an SQL query
I have a very specific business requirement to hide certain characters within an email address when returned from SQL and I have hit the limit of my ability with SQL to achieve this. I was wondering if someone out there would be able to point me in the right direction. Essentially, my business is asking for t…
SQL exclude wildcard from WHERE
We’ve got a query on SAP which has some potential to cause problems. Somebody put the wildcard (%) into the prompt and of course everything got clogged up. Is there a way to disallow the wildcard in the WHERE, maybe with a CASE or something? The only other alternative I could come up with was to only se…
Set empty strings (”) to NULL in the whole database
In my database are many text columns where values are empty strings (”). The empty strings need to be set to NULL. I do not know the exact schemas, tables and columns in this database or rather I want to write a general solution which can be reused. How would I write a query / function to find all text
SQL Server stored procedure summing one field with parameter input from C#
Stored procedure has multiple functions. Step One: I need to retrieve an int from a table, SUM it with an @int variable that is user entered. Then store that value back into the same column it was retrieved from. I.E. We have one, we order one, add one because we now have two because that item is already in i…
How to keep DropDownList1 selected value after postback?
I have two DropDownLists. Once a DropDownList1 value is selected, DropDownList2 will populate based on Dropdownlist1. But after the page refreshes, the dropdownlist1 selected value is changed to the …
Can’t retrieve data from Access DB query to my VB program
So this is my code so far… I have 2 DateTimePickers in which the user selects the first day of the week and the last day of the week, once selected these two I want to calculate the hours worked on each day and add them so I can display the amount of hours worked of the interval of days
SQL: Select only one row of table with same value
Im a bit new to sql and for my project I need to do some Database sorting and filtering: Let’s assume my database looks like this: What should I do to only have the last column with the same email te be returned: Thanks in advance! Answer SQL Query: Hope this solves your problem. Thanks.
Full SQL statement logging on Dropwizard
I’ve a Dropwizard application using JDBI and SQL Server. I would like to get all SQL statements logged with their parameters but I don’t seem to be able to. This is what’s usually recommended to do: logging: level: INFO loggers: “org.skife”: TRACE “com.microsoft.sqlserver.j…