I have converted around 395 Excel survey forms to MS SQl database with that many tables. Well, I run a script to assign a primary key on all the tables on my database.First I set the column proper...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2394...
I would like to create a dynamic SQL update/insert statement based on some parsed data in a table in SQL and run this against an existing table in the same database. The issue I'm having is that so...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2313...
Hi -
I am trying to take advantage of Geometry in MS SQL server 2008 to calculate the distance between 2 points.
I have this working as follows:
-----------------------------------------------...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2394...
I would like to set up Transactional Replication between SQL 2000 server which will be the publisher and SQL 2008 server which will be the subscriber. Can somebody please explain how I can do this...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24115989.html
Zones:
MS SQL ServerDate Answered: 02/11/2009 Rating: 8.4 Views: 37
Hi. I have a table with projects and buyers like this:
Project Buyer
A Tim
A Matt
B John
C Clark
I want a new table that looks lik...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24234472.html
Zones:
MS SQL ServerDate Answered: 03/16/2009 Rating: 9.1 Views: 0
Hi.
I have three columns:
Contract Year Month
How do I secure the table so there can't be:
Contract1 2008 5
Contract1 2008 5
Very new to sql server and...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24249498.html
Zones:
MS SQL ServerDate Answered: 03/20/2009 Rating: 9.0 Views: 0
Hi. Is it possible to have multiple CTEs in a query?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24282233.html
Zones:
MS SQL ServerDate Answered: 03/31/2009 Rating: 9.3 Views: 0
Hello experts,
I have a table in which for one of the colums there is a space and becos of that all the records that have space are appearing on the top in my dropdownlist
In spite of using LTr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2441...
Hello,
I have zipcodes table in which both Longitude and Latitude columns are varchar datatype.
In my stored procedure I am converting them into float even then I am getting an error saying E...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2439...
Hi,
I have a table containing a field lastModificationTime, I want to do periodic controls over the records, say every 5 mins, in this field and if there has been more than 5 mins I want to upda...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2437...
