PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.
Articles & Videos
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
Ok I have (May Not Be The Right or Best Way) 2 different tables set up currently. One Is called (CODE) and the other is called (CODE). The Table (CODE) keeps track of all the products and is the basi…
How do I have the "animalage" display as months and days?
SELECT ss.Location, ss.OriginalName, s.Species, ss.SoftSlip, b.Breed, ss.Sex, ss.DOB, Placements.Kennel, Placements.PlacementEndDat
I hope you can deduce what i am asking from the excel spreadsheet
it has 3 tables listed and the desired results. I don't know how to write this query.
the problem area is the gallons table.
I have the following substring issue..and not working for me
So the DiscussionTypeNumber has a prefix of 3 characters that needs to be removed to join to the c.nid value.
I am trying to update the table. where I have following columns:
folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…
what is the sql sentence to copy a column to the a new coloumn?
I want to create a copy of a column
from time to time our TEST DB will reported to have data lost from users/tester, e.g. they enter the data yesterday or hours ago and it gone.
I found out sth like if the tempdb has conte…
Lets say I have one table. with n number of columns.
I would like to create a new table that made a new row for each column name and the value of that row would be the value from that column
Yes, I have twelve files embedded. And, yes, once again I'm having trouble with very simple T-SQL syntax.
A lot of the files that I have attached are for background purposes. What I'm h…
I want to create a stored procedure with the following script below. Reason being I want schedule this procedure as a job. How can I do this?
How would i use OPENDATASOURCE to insert the records from a table in one database table to an identically named table in another Sql server instance on another server?
I need help to create a query/formula in Access
I know how to do this in Crystal reports but not Access
I have the following query:
,CAST( CAST(wbd.DATA_TYPE as XML ).value('.','varbinary(max
FROM MSGS bd, W…
I have a main query that has many other fields being listed.
One of last remaining fields I need is the summation of the hours in a 12 month period.
The code I have below works, but I'm having a har…
I am using a proprietary front end application to connect to a SQL Server database.
I want to pad a field with a constant string, by using the code below it works with one minor issue * see below:
I'm using the following code to format the ssn#s :
The only issue is if a ssn# starts with 0, it is being omitted.
How can I adjust the code to …
I have a field that is set up as a number 13,4.
I need to format it so that it looks like the following: 9999999V99.
I was trying to use the following formula, but its not working:
I need some help with a SQL Server query that will summarize data and compute an average average like shown below.
I need the output to look like this:
Supplier ID Base Model Avg Image A…
Is there a way to search an Oracle 12c database to find a specific value in a specific column for all tables that have that column? For example, if the column name is CASE_ID and the…
Any assistance would be greatly appreciated. BIG THANKS!!!
Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…
I need to get the next and a previous instructor for the session, I got the code working with one little thing The instructor have to distinct.
I have one table which contains one or multiple entries with dates.
I have another table that has ONE field for ONE date.
I am running a query that will take the date from the first table and co…
I am having an issue where SQL Server does not see a Foxpro DBF file when I attempt to import using SSIS. I see all other files except WOYTRN01.dbf. I am able to update with the following statements b…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to descri…
In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and te…
PortletPaul ( MVE )
7,901 points this week
5,500 points this week
5,336 points this week
Pawan Kumar Khowal
Railway Road Gurgaon, Haryana, India
5,000 points this week
4,332 points this week