1,694 Topics
 | |
| | I have 2 tables in sql , one is called stock and the other stock warning the stock table has columns ' Pid, pdescr,current stock, stock warning' this shows up in datagridview 2nd table(stock warning) has columns 'pdescr, current stock' showing in datagridview in the stock table when the 'current … |
 | this query was working fine but when added OverTime part then it started throwing error: Msg 8117, Level 16, State 1, Line 52 Operand data type varchar is invalid for sum operator. with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t4.ShiftId …  |
| | This query shows emplName,emplID, totalworking time, InTime, OutTime, DateVisited, Overtime for an employee based on his InTime and Outime, that's OK. Now i am trying to modify it to show only emplID, EmplName, Total Working hours(Per month), total overtime (per month). e.g. Empid EmplName TotalWorkingHours TotalOvertime Month 00001 John 77:00 … |
| | i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date … |
 | I created a three layer application with BO (Business Objects), BLL (Business Logic Layer) and DAL (Data Access Layer). I had to do some unit testing using nUnit tool. I've done that like following and works perfectly: SQL Tables: USE [Projekti_TI_1] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO … |
| | hi all ... i want fill data graid view with data taken from text boxs in medecian info group box when i press add button the problem is it add only one row ... i want make that data grid view represet bill so i want add mor than one …  |
 | cmd = new SqlCommand ("select beggining_school, end_school FROM Student,student_weekend,Weekend WHERE Student.ID=student_weekend.studentID AND student_weekend.WeekendID=Weekend.ID ", con); I just want to say that i don't have any problem concerning my code functionality. I would just like the design to be like the above example.That is, I dont'want my whole sql expression to …  |
| | As some of you might know I'm working on a movie database to help track my movie collection. For a while I was having trouble getting the output I wanted for that, but I finally figured out some sql code to help with that problem. I'm going to be working … |
| | Hi i have a problem in binding DateTimePicker value from one form named SearchDoctor to existing form named Doctor. Here is the code of my Doctor form and it works: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Data.Sql; …  |
| | Hi Please any help me on the below issue i am having a interger as below the formate is CYYDDD 114024 i want to change the above line as 24-01-2014 |
| | Hi can any one pls help on the below thing I am having a value as 91819.0 But I required the above data should be converted as time as below 9:18:19 Likewise it should be viceversa |
| | i have wrote query to calculate TOTAL WORK TIME and Overtime of an employee based on Intime and outTime but can't figure out to put another column 'IsAbsent'. e.g. if person doesn't come on any specific date than his INtime and TimeOut would be empty then if both are empty … |
 | Structures of my tables are as follow. Table Name : timetable [Image1](http://www.4shared.com/download/MYafV7-6ce/timetableTable.png) Table Name : slot_table [image2](http://www.4shared.com/download/9Lp_CBn2ba/slot_table.png) Table Name : instructor(this table is not required for this particular problem) I want to show the resultant data in my android app in a timetable format somewhat like this: [image3](http://www.4shared.com/download/oAGiUXVAba/random.png) **Question** : … |
| | Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. … |
| | How to dynamically add div in asp web page ?ie, if mssql server returned n rows from a query, i must place all these n rows in seperate div which has to be created dynamically.!!pls help (d case is when displaying search results in a web page like shopping sites)  |
| | i am given task to analyze and modify pre written large queries within small time, so please help me understanding it with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t1.RecDate AS [DateVisited] FROM AtdRecord t1 INNER JOIN AtdRecord t2 ON t1.EmplID …  |
 | Hello, I need some help here. I cannot make the right query. In my code, I want to insert a data into my database. But the id_number will have different values. Id_number have different values because its from a group. So with that group of id_number I want to insert … |
| | i've been working on a program and i want it to be accessed by multiple users. so i have an admin account and an other users account what i want to do is for the other users to be able to access the program and its database from another computer …  |
| | If someone can provide a link with the use of Parameters instead of concatenation  |
 | i want to know how to create database when there are check boxes. i also want to know the codes to connect those checkbox values to database and retrieve from database. this is my part of my html code. <tr> <td>Professional Qualification <br /></td> <td style="height: 78px"> <input type="checkbox" name="Charted" …  |
 | I have 3 comboBox.. and i wanted a code for the thirdcombobox , something like "SELECT companyName FROM table where mainCategory = firstcombobox and subcategory = secondcombobox" , how do i do the sql query? my maincategory combobox is called mainCatU , and the subcategory is subCatU I managed to …  |
| | I have following quary example. SELECT t1.TeamID, MemberList = substring((SELECT ( ', ' + FirstName ) FROM TeamInfo t2 WHERE t1.TeamID = t2.TeamID ORDER BY TeamID, FirstName FOR XML PATH( '' ) ), 3, 1000 )FROM TeamInfo t1 GROUP BY TeamID Its giving error "Incorrect syntax near the keyword 'FOR'." … |
| | Guys, please suggest me, how can I set up an audit on SQL server 2008 if I need to track who, when, what and from where changed something on a database table? |
| | Good day, I need help with my ajax based dynamic drop down list. Right now, ajax.php pulls up data depending on value at a single column. I need it to pull up data based on value at certain columns. I am new to php and its going over my knowledge. … |
| | *new to C#* I have created a form , with a working coding , but i need an extra assistance. Somewhat , i am stuck on trying to figure out how to let the 3rd combobox value , determined by the first and second. Like this : [Main Form](http://i.imgur.com/1rePOge.png) For … |
| | I only have experience using pretty basic Oracle. However, I'm now in need of a better understanding of SQL. I'm trying to write a query using CASE statements (as this seems to be the best approach), but am admittedly lost at the moment. Here is what I have as a …  |
| | I have created a form , with a working coding , but i need an extra assistance. Somewhat , i am stuck on trying to figure out how to let the 3rd combobox value , determined by the first and second. and what i wanted is , something like , … |
| | Hi there. I was kinda researching on how I could store data at best (in my opinion). I came on "CSV" files. Which looked great to use. I found out there are two functions that can operate file. So I keep Googling on how to use the syntax and how … |
 | I have data already populated in a datagrid I have three textbox txtCustomername, txtPartcode, txtinvo I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user …  |
 | Hello I have two tables: Students and Professors (both with usual info like name, last name, email... etc) I also need to have info about their knowledge of foreign languages, and I guess that should be a third table (languages for example) it should look like: Language_id, Language, Speaking, Writing, … |
The End.