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
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...
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
I would like to learn SQL Administration and how it works. Is there anyone who knows where to direct, teach or explain to me how its properties are made up?
http://www.experts-exchange.com/Microsoft/Development/Q_23438756.html
Hi all, I'm trying to use TVF function in Where clause with conjunction with Case statement.
In this scenario I'm getting an error:
"Subquery returned more than 1 value. This is not permitted whe...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23491919.html
I have to interview a database analyst this afternoon, although I'm an IT professional I don't do database work and need some good questions to test the DBA's knowlege.
I'd prefer questions list...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23522291.html
