3,481 Topics
 | |
| | Hi all, I have a Windows 7 64 bit client that is running a 32 bit of software and so needs a 32 bit ODBC connection to the database. I of course ignored the Administrative Tools > ODBC manager because that will open the 64 bit and instead went to … |
| | Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A … |
 | |
| | What is the main difference b/w Mysql and Mssql? |
| |    Hi, I have a below table of Content CUSTOMER ID QUESTIONS ANSWER 1 FirstName John 1 LastName William 1 Country India 1 Zip Code 60000 2 FirstName xxxx 2 LastName yyyy 2 Country US 2 Zip Code 123456 3 OrgName ABC Pvt Ltd 3 … |
 | Hi.. i want to get all columns from tbl_class where course_id of tbl_course is equal to course_id of tbl_class more over course_id of tbl_course should be thw one who has semester = 5 brife structure of tables are: tbl_class >class_id >course_id >class_room tbl_course >course_id >semester i have design this kind …  |
| | Hi guys, I have worked with PHP and MySQL before and recently I wanted to try and learn ASP.net MVC since some of my friends are using it in the work place. But the most confusing thing about this is, why does all the tutorials out there not mention how … |
 | 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 need to add un hour to my date, how can i do??? This my code CASE WHEN candidat_rendezvous_date IS NOT NULL THEN 'candidat_rendezvous_date + 1Hour' END Thanks for your help |
| | 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; …  |
| | I have text file (attached image) i need to loop and get the values (with ellipse shape )into sql table the text file record usually started with (----) |
| | Hi my name is vishal. For the past 1 week i been in the process of creating a dashboard using listview in c# windows forms with sql server 2008. I created listview named lstDashItems and populate it from a table named USERACTIVITIES in sql server 2008. The design of USERACTIVITIES … |
 | I have a project that must have centralization of databases that will have access to the web on a PHP script. I can merge MSSQL and MySQL databases if and only if they were both: 1.) On a same server or 2.) Of the same server type The problem is … |
| | Hi Experts, I have to Pad some numbers that have decimal points and I have done it successfully as follows: SELECT case when len(myValue)=1 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(5)), 2) when len(myValue)=2 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(4)), 2) when len(myValue)=3 then RIGHT('000' + CAST(CAST(myValue … |
| | 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 …  |
| | Hi Friend I am trying to connect my MSSql server 2008 R2 server using php. I am getting an error as below `Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\test\connect.php on line 4` and the code is below <?php $serverName = "servername\sqlexpress"; //serverName\instanceName $connectionInfo = array( "Database"=>"dbname", "UID"=>"us", "PWD"=>"ps"); … |
| | My company has Desktop application developed in vb.net using devexpress controls. Back End database is MySQL. Company is in retailing and have 2 retail stores in in same city. Both stores always stay busy and customers are always in waiting at the counter. Basically, it is desktop based CRM application …  |
| | 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 …  |
 | please help me in this,how would i do some recursive statement in my stored procedure. here is what i want -- @requestcode will genereate some random string set @requestcode = (SELECT substring(@username,0,3)+'-'+SUBSTRING(CONVERT(varchar(255), NEWID()), 0, 9)) -- then i want to check if the string generated is existing to 'sampletable' select … |
| | 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'." … |
| | Hi I want to do a silent install of sql express 2008 (free edition) In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy". Thanks for your help SQL Newbie |
| | 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 …  |
| | Hi Guys I have a "StudentNames" column in an sql table. Each student in the table has atleast two names all in one column. Assume that the following as studentNames. StudentNames ------------- John Smith Joseph Smitter Johan Smittin How can I use the LIKE statement to select students with same … |
| | Hi I would like to insert a record from a CSV file into 2 tables, but it's line by line instead of conventional CSV separated. I am using c# and MSSQL. My data is like this and its about 70 lines, they will be always in the same order : …  |
| | Hi Everyone, Can anyone guide what is EXEC sp_cycle_errorlog? Is it safe to just manually delete the ERRORLOG in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder? This ERRORLOG is consuming too much space that is using up c drive. Can any advice? Thank you! |
 | Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL.  and Here's the table (namely customer_call) of AIMIS.  and Here's the table (namely quotations_header) … |
 | dear all i have tables(aztrd) it conatis invoice deatils like itm_code , date,loc_cd ..... ect - in each in invoice they are itmes (itm_cd) from loc_cd "1" or loc_cd "2" and some invocies has items from loc_cd "1" only or loc_cd "2" only i try this query to get only … |
| | Hello, I would need some help/hints/tips for installing MSSQL server 2008 on a Windows Server 2003. Details: I want to work with virtual machines. My computer is an old one, not able to virtualize x64 machines. That's why I use Win server 2003 32 bit with MSSQL server 2008 R2. …  |
| | I am trying to create stored procedure which will insert one row in the first table and identity of inserted row in other two tables. For some reason I am receiving error "Procedure or function expects parameter '@id', which was not supplied.". My code is as follows: ALTER PROCEDURE InsertProf … |
| | Hi friends, I am having a doubt in insertion of data create table table1(name varchar(10)) In this table, when i insert the following record manually, it produces me an error that it cannot insert. insert into table1 values('asdfghjklqwe') But when I try to insert it with the procedure, it trims … |
 | Hi, Im having a hard time figuring this maybe a simple query. This is my first time to use sql compact edition. How can I query a select statement inside a select statement which tables are not related at all. What i need to accomplish is to insert a logo … |
| | Hi I have an issue to update data between two table. I want to update data from one table to another using Store procedure. My code is SELECT NoMonth,ACC_P,StartDate FROM dbo.tbl_Accural_Basic UPDATE WEB_tbl_Accural_Audit SET NoMonth=nomonth,ACC_P=ACC_P, StartDate=Startdate But Nothing happend. It will show the data in select command Pls help me … |
| | Hi all, i am passing comma separated values to my stored procedure. something like below: @id=1,2,3,4 @firstname='a','b','c','d' now if i write select statement then i want single data from @id and @firstname. something like below: id firstname 1 a 2 b 3 c 4 d thanks |
| | Hi, I need data table desgin for transaction table. I want transaction history for particular client having unique client_id but many having many transaction id's. transactions relate to credit, debit, transactor name and date. Regards Kaustubh  |
| | Hi Everyone, Thank you for the time you spend to look at the post. I am required to retrieve report based on a date field in the table. the date field filtering must be from the previous month of the 6th till this month of the 5th. For example, today … |
 | i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: *TABLE STORES* storeName----Sales-------Txn_date *TABLE GEOGRAPHY* regionName----storeName SELECT SUM(Sales) FROM Store_Information WHERE EXISTS …  |
| | actual differecne between SQL Server's STORE PROCEDURES and USER DEFINED FUNCTIONS ? i looked up these in google but couldn't satisfy me. Differences ? better to use ? and why does UDF can only implement SELECT statements not else , y ? |
| | ALTER FUNCTION [dbo].[customers_udfMin2] ( @decission tinyint ) RETURNS int AS BEGIN -- Declare the return variable here DECLARE @min int Declare @default int = 10 -- Add the T-SQL statements to compute the return value here if (@decission = 1) Begin SELECT @min = MIN(customers.cus_id) from customers End else RETURN … |
| | i'm trying to access a database backup that i usually keep in my pc's hard disk, trying to access it via my laptop. Both pc and laptop has SQL SERVER 2008 with same server name, using windows authentication, i spent 2 days but can't figure out that how to access … |
 | Hi all, Im working on a page that sends information to a mssql database. Its a basic registration page with a UserID, Password, First Name, Middle Name, Last Name, and Email box. When Sign up is clicked, all the information in the textboxes should be sent to the Users table … |
| | Hi guys, I'm stucked at (as it seems to me) a very strange problem. I have a listview on my form to which a list of users is populated from mssql db. In the same table but different column I have user_id. I have a textbox and a textbox_keydown control … |
| | Hi I installed mssql200. It works fine, but outside application can't communicate with it because it doesn't open port 1433 as it is configured to do. Instead it opens 2 other ports that communicate with the DNS server. What is required to change in order to open port 1433? Ronni  |
| | Hi, We have MS sever 2012 and MSSql Server 2012. ODBC Connection in Server is fine. But If create the odbc from Client PC (OS Windows 7 profession SP1), it could not connect Error : Server not found or Access Denied. Even in Admin level also, it shows same error. … |
 | How do I connect from another machine to SQL Server 2008 R2 Express installed on Windows Server 2008? I've setup the network configuration to be enabled and the TCP port is set to 1433, but I still can not connect to an existing database on the server when creating ODBC … |
| | Hi all, I really need your help on this one. I have a MSSQL db table with two columns-ID and name. Each row in this two columns contains an unique ID and a name. Now I have a query that imports just a name in the listview (I don't want … |
| | hi anybody can tell How can session store in mssql database? How to do SQLServer Session Mode start? Pls help me Maideen |
| | Good Day, I would like to ask if it possible that i have my Local Database(MSSQL) but i would like to put it Online? I need some idea on this Daniwebers. Your response is Highly Appreciated. Thank you, EOS |
 | we should create a program that could run through two computers and the computers should be able to access 1 database for record sharing. how can we make that? we already made the system. the problem is, how can we implement this in a networked way? thanks in advance. :)  |
| | Question: Given the relational schema: ENROL (S#, C#, Class) - S# represents student number TEACH (Prof, C#, Class) - C# represents course number ADVISE (Prof, S#) - Prof is project guide of S# PRE_REQ (C#, Pre_C#) - Pre_C# is prerequisite course GRADES (S#, C#, Grade, Year) STUDENT (S#, Sname) - … |
 | ## Hey Guys ## , I've recently stopped doing some of the projects which I wanted to do and took a look at SQL and came across Microsoft SQL and i was pretty pleased with wha tit can do so i downloaded the program and watched some basic MSSQL tutorials … |
The End.