Looking at SQLCMD help I found this:

Editing Commands

[:] ED

Starts the text editor. This editor can be used to edit the current Transact-SQL batch, or the last executed batch. To edit...

Really helpful if you use the [ url ]/[ /url ] IFCode shortcuts (no spaces inside...

Use Google, you are looking for a delete command.

Djcarpen11 (7/23/2012)

---

I've created an index similar the one below

CREATE NONCLUSTERED INDEX [Ixn_Mytable_F]

ON [dbo].[MyTable] ([ColA])

INCLUDE ([ColB],[ColC],[ColD])

where ColA = 122

If I run the below code against it, I'd have thought...

Each developer needs to have a licensed copy of the developer edition. Also, you do realize that if the developers have to RDp to the server, you most likely...

SSCNewbee (7/23/2012)

---

The data looks like this

scheduleddatetime requesteddatetime inspecteddatetime

2012-07-23 07:30:00.0002012-07-23 09:27:00.0002012-07-23 09:27:26.533

2012-07-23...

littlelisa1111 (7/23/2012)

---

select o.Id, o.AccountId, o.Name, o.StageName,o.[type], o.Account__c,o.SalesPerson__c, c.InvoiceDate__c,c.Sales_Person__c

from customers.dbo.opportunity as o inner join

customers.dbo.orderheader__c as c on c.AccountId__c = o.AccountId

Where o.SalesPerson__c = '' and o.[Type] = 'Integration Renewal' and o.StageName NOT...

Then I have already told you what you need to do, create a job step to delete the backup file.

Adelphi (7/23/2012)

---

Hi All,

I have a table that holds the following data:

ProjectsCustomersUpdatedByNewValueUpdatedOn

Project 1Customer AUser 1£1,142.0005/01/2012 10:27

Project 1Customer AUser 1£1,839.0005/01/2012 10:59

Porject 2Customer BUser 5£121,995.0024/05/2012 09:26

Project 3Customer CUser 3£20,332.0026/06/2012 09:57

Project 4Customer DUser 2£18,191.0014/05/2012...

I can't tell you that, I don't know your system nor what...

sivag,

I don't think you understand. We can't give you the code to move data from one table to five tables without knowing the how the data maps between the...

espanolanthony (7/23/2012)

---

let me explain in detail sir.

Step 1 : Server A takes database to a network location. (Let's say Server C //test-dql_1\backups\Prod.bak)

Step 2 : The...

SSCNewbee (7/23/2012)

---

Thanks Lynn this is the FUNCTION:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

-- ===================================================================================

-- -- Description:Given a unique inspection number, this function returns an integer

-- ...

espanolanthony (7/23/2012)

---

actually we don't need that backup copy because we do refresh every day. I just want to delete because i need free space at all times. So any idea...

SSCNewbee (7/23/2012)

---

Thanks Lynn can you please elaborate in detail? This PACKAGE didnt fail until the last weekend. Also can you please tell me what the "dbo.FN_GET_INSPECTION_DURATION_SECONDS( ScheduledDateTime ,RequestedDateTime ,InspectionDateTime)" is...