Member Avatar
Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm …
by RudyM 31 in Databases ()
Member Avatar
Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use …
by zachattack05 56 in Databases ()
Member Avatar
Hi Dw. What is the correct way to write an sql query like this? ... in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. When I tried this it will just return the …
by Mr.M 32 in Databases ()
Member Avatar
Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p
by pleasehelplmao in Databases ()
Member Avatar
How do i get the most repeated value that is inserted just today from 23:59 till 00:00 i have this sql but i dont know how to filter it by date any help will be apreciated. ...
by Stefan_1 -3 in Web Development ()
Member Avatar
hello to all! I am developing a data warhouse as my final year project. I have made my star schema succesfully. Now i want to make a query interface for end users so that they run their desired queries. But i am unable to understand that what type of interface …
by Saboor Siddique -3 in Software Development ()
Member Avatar
I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this ... How can one write sql/mysql …
by Amaina in Databases ()
Member Avatar
Hi Dw. I have a timer that in every 600 interval access the database and the database I'm using is MS Access database. The problem I have is that with this being said, the MS Access database has a limitation of 64 connections on each thread so this 600 interval …
by Mr.M 32 in Software Development ()
Member Avatar
MySQL Stored Routines: Another Useful Scenario I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you already have)! Let’s jump right on, …
by Bob Hensley 20 in Databases ()
Member Avatar
Is it possible to select values from 2 columns in order to calculate another column in the database table?
by BabaRoro in Databases ()
Member Avatar
Hello, I have the below case. ... So, I want to insert into TM_TABLE_2.NITEMID the value of TM_TABLE_1.NID where TM_TABLE_2.NORDERCODE = TM_TABLE_1.NORDERCODE, keeping in mind that its possible to have more records inside TM_TABLE_1 than TM_TABLE_2 so I just want to insert NID's from TM_TABLE_1 into TM_TABLE for row's with …
by fo2sh -4 in Databases ()
Member Avatar
How do I write a SQL query involving a time stamp? QUOTE_ID is a character string CREATE_DTG is a date time type RETENTION_LEAD_TRACK is a table This sql statement ... throws this error ...
by complete -2 in Databases ()
Member Avatar
I want to insert a table cell into a table from another table by select method and after, to display an error in text prompted from the user was not found. Can someone tell what's the problem with my codes? My codes are as follows: ...
by tshukela.george in Software Development ()
Member Avatar
Let's say I have such table: ... I'd like to select every single result in this table, where user with ID ... has partcipated. How can I do that? Ye old ... . Couple things worth noting, that in this particular field, there may be just alone ... , or …
by RikTelner 20 in Web Development ()
Member Avatar
Hey fellas, some time ago I started trying out Brackets, and guess what? Loved it! If you don't know, it's an open soude editor made out of html, css and javascript, powered by node JS and chromium and sponsored by Adobe. A lot of open sources projects coming together to …
by AleMonteiro 238 in Community Center ()
Member Avatar
Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number
by judgerm in Databases ()
Member Avatar
Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!
by Emily_3 in Databases ()
Member Avatar
Hi Friend, ... Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. please solve my problem. Thanks & Regards
by Parth_3 in Programming ()
Member Avatar
Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ?
by sashiksu in Databases ()
Member Avatar
Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. …
by tig2810 in Databases ()
Member Avatar
Hi all, I currently have two tables that look like this: ... I use two queries to get the number of likes and comments in relation to any profile post: ... ID ... and ... ID ... I have been trying to combine these into one query. However, I get …
by James_43 15 in Databases ()
sql
Member Avatar
I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …
by Peter_26 in Databases ()
Member Avatar
Hi, ... strProfile can be blank, so if it is blank then this AND PD.Profile = strProfile should not be included in the where clause, How do I bypass this? Cheers Darren
by DGULLIVER 10 in Databases ()
Member Avatar
hello guys i want to disconnect a mssql connection automaticaly whit a command
by mehran199107 in Databases ()
Member Avatar
My project uses local sql database. I tried the app on a non development machine for first time. Got a message saying it was downloading required files, sql 2008 express, at a whopping 600MB+ file. Please tell me I've done something wrong, and any user of my app will not …
by Suzie999 229 in Software Development ()
Member Avatar
Hello to all! I am using Sql server express 2008. Now I want to use Integtation services such as creating and executing packages. But I could not find any interface to create and execute packages in version of server which i am using. When I go to start menu > …
by Saboor Siddique -3 in Databases ()
Member Avatar
I m in the process of creating a sql table which acts as a stafflist that has several columns like name , number , email and delete. One webpage on the website gives out the rows of this table and i would like to have a clickable link in the …
by latrellvie in Web Development ()
Member Avatar
Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting ... I fixed that error by forwarding the port through the firewall, however I get …
by toxicandy 2 in Databases ()
Member Avatar
My php file connnects to my sql database , following code works ... after that a staff listing which is written in html shows BUT if i use following code to get data out of my sql to display I only get a blank screen ... I wonder where is …
by latrellvie in Web Development ()
Member Avatar
Hi, I hope I've posted this in the right place, please just tell me if not. I've been having an issue with connecting to a database from a website and have recieved this as an error message: I then followed what it said and tried to download the Native Client …
by az_ez in Microsoft Windows ()