sqlblue (10/17/2013)

---

Thanks for responding. I need to execute the stored procedure in batches either through a while loop or some kind of table with identity column, but I don't...

SQLBill (10/17/2013)

---

My wife doesn't want to hear about it. But interestly enough, she goes on and on about her work and expects me to be interested. She really...

sqlblue (10/17/2013)

---

I have a stored procedure that needs to be called to update a table inside for a large date range (millions of records), but I wanted this stored procedure

to...

Resender (10/17/2013)

---

Sean Lange (10/17/2013)

---

How about some ddl and sample data? This doesn't sound too bad but without something to work with I have a hard time visualizing it, and it...

Let's start with formatting this sql into something legible.

ALTER PROCEDURE [dbo].[SaveBSPOutageInfo] @eventCreatedDate DATETIME

,@eventOrigin VARCHAR(10)

,@eventType VARCHAR(10)

,@alert_Type VARCHAR(10)

,@outageComponent VARCHAR(10)

,@remedyTicket VARCHAR(15)

,@Severity_Cd VARCHAR(2)

,@Status_Cd VARCHAR(2)

,@Planned_Outage_Ind VARCHAR(1)

,@Outage_Start_Time DATETIME

,@Impacted_800_Num VARCHAR(200)

,@Bus_Hrs_Ind VARCHAR(1)

,@Expected_End_Time DATETIME

,@Actual_End_Time DATETIME

,@Addl_Steps VARCHAR(2000)

,@BSP_Name VARCHAR(30)

,@Caller VARCHAR(30)

,@Phone VARCHAR(12)

,@Internal_Comments...

How about some ddl and sample data? This doesn't sound too bad but without something to work with I have a hard time visualizing it, and it is nearly impossible...

I can't write the code. I...

You are quite welcome. I would caution you that there are a few things in that code that I would recommend...

😉 Glad to hear it is working for you. I use it pretty frequently myself.

Jeff Atherton (10/16/2013)

---

Sean Lange (10/16/2013)

---

btw, not sure what the previous poster was complaining about. SQLExpress is free and is a great tool, especially for learning when you don't have access...

krypto69 (10/16/2013)

---

Hi,

I am using the query below and am getting back four 'Gary' records. Which I understand why that's correct for the way I have it written.

But what I...

+10000 to that.

I should have...

erikd (10/16/2013)

---

I'm looking for some direction.

I did it because I'm reading The Accidental DBA in an effort to branch out beyond the T-SQL stuff I've been kind of limited...

Assuming FlightDate is a datetime data type you could use this.

SELECT Month(FlightDate) as Month,

COUNT (PaxNum) as TotalPassengersCount

FROM dbo.FlightDetails

WHERE FlightDate BETWEEN '1/1/2013' and '10/15/2013'

GROUP BY...

Guras (10/16/2013)

---

I have the following rollback code in cascaded sp does this work?

CREATE Procedure SP1

AS

BEGIN TRAN TRAN1

BEGIN TRY

Update Table1

exec childsp1

END TRY

BEGIN...