Hello,
im using the jobs with 3 steps. Now i have to check if the database not empty at the begin of the job. If the db empty, the job must be stop, if not empty, the next step must be execute.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10666281.html
Zones:
MS SQL ServerDate Answered: 07/17/2000 Rating: 9.2 Views: 0
I have a TSQL which I am connecting to an Access database using an ODBC connection. But every time I run the program it comes up with a username and password prompt for the database. How can I stop...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20093113.html
We have dozens of servers here with many jobs running nightly. We are running into problems though of jobs getting too long and running into each other slowing down the next job, etc...
Is it p...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20172462.html
Zones:
MS SQL ServerDate Answered: 08/31/2001 Rating: 8.6 Views: 0
AccessID Desc
1 AccessType1
2 AccessType2
3 AccessType3
.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20321875.html
Zones:
MS SQL ServerDate Answered: 07/17/2002 Rating: 5.4 Views: 0
I have a table (A) that contains a primary key (autonumber) plus lots of other
fields. I have other tables (B and C) that have foreign keys linking to tableA.
What I need to do is duplicate a r...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20388101.html
Zones:
MS SQL ServerDate Answered: 11/04/2002 Rating: 7.6 Views: 0
I'm trying determine a database's recovery model with TSQL, for scripting purposes. All I can find is a DMO property. Any ideas?
Thanks,
Garrett
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20774999.html
Zones:
MS SQL ServerDate Answered: 10/22/2003 Rating: 9.6 Views: 0
i need to do this:
select
substring(project_name,1,255) as "Project Name",
substring(description,1,255) as "Description"
from projtable
this doesnt work, what's the correct syntax? basi...
http://www.experts-exchange.com/Database/Sybase/Q_20868370.html
Zones:
SybaseDate Answered: 01/30/2004 Rating: 8.8 Views: 0
Hi,
I need to write some TSQL that will return to me the total number of Mondays, tuesdays, wednesdays, thursdays, fridays, saturdays and sundays in a given date period. It needs to be as effic...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20947840.html
Zones:
MS SQL ServerDate Answered: 04/08/2004 Rating: 9.4 Views: 4
How can I convert this MS Access query to TSQL in SQL Server 2000
SELECT [ProgramID], SUM(IIf([XCutName]='Secretary Reimb',[XCutBudget],0)) AS ['Secretary Reimb Oblig'], SUM(IIf([XCutName]='Secr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20947907.html
Zones:
MS SQL ServerDate Answered: 04/11/2004 Rating: 6.8 Views: 0
TableOne
LineName ProductType ENDING_Inv_Date Qty
Crosby Line 1 AAA type 01/01/2004 50
Crosby Line 1 AAA type 02/01/2004 70
Cro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21045364.html
Zones:
MS SQL ServerDate Answered: 07/04/2004 Rating: 8.4 Views: 0
