I'm trying to perform the following query:
DELETE FROM page_section WHERE page_id=(
SELECT page_id FROM template_page WHERE template_id=#template_id#
)
What i'm essentially trying to d...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23024444.html
Greetings all
I have the following tables:
Annual_Card: Contains a list of Pupil annual cards
Fee_Structure: Contains a list of Fee records
(see snippet for details)
The "key" fiel...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23056867.html
Hi
i have a problem in ms sql, i wanna execute And Statement but i would like to enforce another restriction on the statement.
AND (VI.RatingCertificate = 0 Or NOT (convert(varchar(10),@SlotEndTi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23641259.html
Zones:
MS SQL ServerDate Answered: 08/21/2008 Rating: 7.1 Views: 0
experts,
I manage two DBs in SQL Server 2k. A MS Access Data Project application was created with user interface (Forms) as front-end for a non-SQL Server user. The new data added by the interfa...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21975366.html
Zones:
MS SQL ServerDate Answered: 09/01/2006 Rating: 6.6 Views: 0
We have recently switched to a dedicated server for our website. We use an MS SQL db, MS SQL 2005. When I read through the log files, I have over 100,000 instances of the following type of error,...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22021643.html
Zones:
MS SQL ServerDate Answered: 10/12/2006 Rating: 9.8 Views: 0
HI,
Could somebody help me about the locking database please?
We just moved from MSDE 2000 into MS SQL server 2005. And we are using MS Access for the front end.
WE had 6 computers connect to ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22625169.html
Zones:
MS SQL ServerDate Answered: 06/20/2007 Rating: 9.8 Views: 0
In MS SQL Server ,is it possible to create a stored procedure for each of an unknown number of values of a numeric field? I tried using strings within a pre-existing stored procedure but couldn't f...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22709203.html
I have a stored procedure that is passed a uniquie value. What I would like to do do an insert if results are =0, an update if results >0.
How can I branch on the result of an aggregate query?
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22849016.html
Zones:
MS SQL ServerDate Answered: 09/24/2007 Rating: 9.0 Views: 0
I need create a function using the following query and need to call the function in a view. Can you provide me the function script with the below sql and show how i can use it in a view.
SELECT ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2292...
Hello Experts,
In my SQL Server 2005 I have registered two SQL server. SQLProd and SQLDev servers.
I have a table emp_Master in SQLProd database and I have emp_master in SQLDev.
I have add...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22926917.html
Zones:
MS SQL ServerDate Answered: 10/30/2007 Rating: 9.8 Views: 0
