Having a bit of a block on this one (just got back from holiday which isn't helping!)
If I have TBL_People linked to TBL_people_skills on Person_ID how do I get a list of records in TBL_People w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23437486.html
Hi Experts!
I am hoping this will be a quick fix. I only need you to look at the "Search of FEIN field" if this one will work then I will be able to get the Search ERN field to work. I have an ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2385...
Hi Experts!
I have to create a search query for various fields. The search string is type varchar and all of the fields in a table are varchars of different lengths. The problem is two fields ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23872985.html
Mental block with this one. I have the following query (which doesn't work!)
Select Distinct
Contact_ID,
Company_name,
Town,
County,
Industry_description,
Main_activity,
No_ees_nat,
...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23693457.html
I have a large TSQL Query that has a top section that declares and sets a date variable. I am leaving this with the Admin of my client but would rather put this query into a stored procedure and g...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23722552.html
I am trying to create a linked server between a SQL Server 2005 server and SQL Server 2000 server. I login to Management Studio for our 2005 implementation, right-click on "Server Objects," and sel...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2386...
In a Microsoft SQL Database, is a uniqueidentifier unique in the originating database only? For example, if I were to merge two databases, is there a possibility that a uniqueidentifier could be d...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23090505.html
This example over simplies the situation that I have but allows me to ask the question clearly without giving tons and tons of details.
I have an application that copies files to a folder struct...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/2003_Server/Q_231364...
JRE 1.5.0_12 / Win2k3 / 8GB RAM
I'm running a data import process with one of the tables containing 22 million records.
When using a JDBC 2000 driver, i can set the max heap to 512 and everyt...
http://www.experts-exchange.com/Programming/Languages/Java/Q_23223502.html
Hi,
I have a script which is intented to load an image from an Images table in a database. In the table there is a datetime column 'LastImpression' which holds the date and time of the last time...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23377411.html
