2,935 Topics
 | |
| | Hi All, I am new to sql and also this is my first post in this THREAD, Inline with this I am going to improve knowledge on sql, so below is my query which i desperately needed and don't know it is possible or not? I've Two table Table1: ProblemGroup … |
| | I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT … |
| | Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title for any Recruiters who have worked on more than/less than 6 projects within a specified period. These are the tables: dbo.tblResources ResourceID Company Name dbo.tblRecruiters RecruiterID ResourceID dbo.tblProjects ProjectID Datecreated dbo.tblProfiles ProfileID ProjectID … |
| | Ok, so I've been looking all over the web to try and solve my problem... I have an SQL 2005 database on a web server which displays information to customers via an asp.net web site which also offers interaction with the data. I also have a Windows .Net application which … |
 | Hello Is there a querry to convert a whole column into MD5 but i only need the first 19 characters of the MD5 thanks |
| | Hello Dani Webbers, So I've been given this old-as-hell database, it was designed in 1993 under pick, and it isn't at all normalized, in a good effort I've migrated all the data into MSSQL 2008 server and I have some several to several relations between tables, on of these relations …  |
| | As the title goes how can i transfer a table from one DB to another but first i need to delete the table1 from DB1 coz table2 from DB2 has the same name as table1... |
| | hi there, i have a question in giving access to separate table to users. i have a database call Admin and in that there are some tables that the one user should not aloowed in viewing, how can i restric that user in avoing looking at that table i am … |
| | Hi everyone, I have one problem that i couldn't solve. I'm developing a Web Application. Everyday many user's logg in and work... So, they logg in to my web app. through their MSSQL username and userpassword. HERE, I want MSSQL to deny access when they open their mssql and logg … |
| | |
| | How to save listview data to database? Not work code: [CODE]private void Insertbutton_Click(object sender, EventArgs e) { string strConnection = "Data Source=OCH-ERDENE\\SQLEXPRESS;Initial Catalog=Database;Integrated Security=True; Pooling=False"; SQLiteConnection conn = new SQLiteConnection(strConnection); conn.Open(); for (int cnt = 0; cnt <= lsvXML.Items.Count; cnt++) { string query = "INSERT INTO DataObject VALUES('" + lsvXML.Items[cnt].Text … |
| | This looks pretty simple on the face of it but I can't get my head around it. I have two tables that I'm querying: dbo.tblrespondents RespondentID FirstName Surname dbo.tblrespondentschildren RespondentsChildID RespondentID ChildFirstName ChildSurname ChildDOB ChildSex I am trying to find which Respondents who have only sons - one must be …  |
| | hi, M'soft sites documented that [CODE]RECEIVE TOP (n) FROM Target[/CODE] should fetch the n number of message from the specified queue. I am having problem with this, and do not know why because not much resource is available pertaining this. Tried finding for an answer on Klaus Aschenbrenner's book, failed. … |
| | Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation? |
| | hi, i have a problem in login in to the MS SQL server 2008, i installed the MS SQL with the authentivcation mode as Mixed mode and and for the SQL server administrator i added the current user and for the password i gave a different password, which is not … |
| | Hi all, i'am having a problem with my sql database.I'm able to insert and retrieve data.but i couldn't able to view the data in my sql interface.all the columns are empty.so where the data being stored ? why it is not appear to the sql interface ? |
| | hi there, i have a question in connection my application to ms sql 2008. i wrote a desktop application in visual studio 2008 in the C# language. and i have installed the MS SQl 2008 DBMS software. and when i try to connect to the MS SQL in Mixed mode … |
| | Hi Everyone, I got a problem while creating a views in sql server 2005. In my database there are several tables which are accounts_transaction bill_info member_bill member_info relationship is exist between “member_info and accounts_transaction, member_info and member_bill, bill_info and member_bill” but there is not any relationship between bill_info and accounts_transaction. … |
| | I am using sql server 2008 but i just want create reports usin sql statements just sql without any other application like Visual studio is posible?? |
| | Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields … |
| | I use report and have the table as shown below. The original column name are Parent and Child Row 1: Parent A and Child B Row 2: Parent B and Child C Row 3: Parent D and Child E Row 4: Parent E and Child F Row 5: arent Z … |
| | Hi everyone! I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query? For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so …  |
| | hey i have a mdf file which i made an application in visual studio 2008 and i want to migrate all the data and the tables in to the MySQL server, can someone help me in this thanxxxxx appreciate a lot |
| | Hi all, I'm attempting to get some numbers from an XAL database (MS SQL Server 2005). My query is below. There are some conditions commented out. If I add either one of the lower ones the query executes in a matter of seconds but if I replace them with the … |
| | Hi I have three tables [ATTACH]18183[/ATTACH] Suppliers, Supply and Parts. I want two queries. a) List the name of the part along with the Total Price. b) List the names of the supplier that list both p1(part1) and p2 (part2) |
| | Hello: I have a table where a column called [I]ActiveStatus[/I] (of datatype 'bit') I am trying to run a query on may contain values Boolean values or NULL. Which means, if there are 10 rows in the table, a likely scenario would have 5 NULLs, 2 FALSEs, and 3 TRUEs. … |
 | I have a stored procedure where I need to insert from some other tables when those items do not exist in the original table. Here’s the stored procedure that I wrote. [CODE] ALTER PROCEDURE [dbo].[sp_CreateRequestedItems] AS BEGIN INSERT INTO dbo.RequestItems ([request], [applicationProfile]) --select from requests and profiles table into requestitems … |
| | I have the following three tables: ClassHeader ClassID Major TeacherClasses TeacherID ClassID StudentClasses TeacherID Major I want to select all TeacherClasses where the a given Major = ClassHeader.Major |
| | i need to isnert in database and i have query liike that [CODE]str_attend = "insert into Attendees([Userid],[Attendees_name],[Attendees_telephone],[Attendees_Email] )values (" & userid & " ," & arr(0).ToString() & " , " & arr(1).ToString() & " , " & arr(3).ToString() & " )" [/CODE] all values hold values in insert statment non … |
| | O.K. I've been agonizing over this for some time now, in this website i'm building, every registered user is gonna have some data that he can review add update delete. what would be the best way to store this data? in sql?, so that we have this one huge table … |
The End.