j.grimanis (6/15/2015)

---

Hi,

I have a procedure which inside I call two other Procedures, the first one is updating table Purchase Order and the second one is updating an intermediary table afterPurchase...

The column t00.[CustNo] is never NULL, so you'll always end up with a value of 0.

You don't need the nested CASE, you can just add more conditions as needed.

Select t00.[InvDate]

...

Full example:

CREATE TABLE dbo.SampleData(

Stip_Abv nvarchar(10),

Dt_Start nvarchar(10),

Dt_End nvarchar(10))

INSERT INTO SampleData

VALUES( 'PM', '05/15', '06/20'),

(...

If you can have either start date and end date or no dates at all, you can make it simpler.

ISNULL(dbo.APD_Stips1.Stip_Abv + N' ', N' ') + ISNULL( N'(' + dbo.APD_Stips2.Dt_Start...

sgmunson (6/15/2015)

---

WITH DATEFIELDS AS (

SELECT DATEFIELD1 =...

From your private message, I could understand that your 2 recordsets have the same information but one has details and the other one has totals. SSRS is able to group...

You don't need an explicit transaction for a single statement.

Using a top 1 in an update makes no sense.

Your WHERE clause is not SARGable. A possible better way would be...

Your join condition will never evaluate TRUE and that's why you're always getting NULLs.

There's a problem here. Even if you explained exactly what you need to do, it's too generic. We can't help with the stored procedure because we can't see it. We're...

tsobiech (6/12/2015)

---

Luis Cazares (6/12/2015)

---

Or you could use SSRS to create a nice report with parameters that can be exported to Excel, Word, PDF & others.

The Stairway to Reporting Services will...

Or you could use SSRS to create a nice report with parameters that can be exported to Excel, Word, PDF & others.

The Stairway to Reporting Services will guide you step...

Lynn Pettis (6/12/2015)

---

Alvin Ramard (6/12/2015)

---

Lynn Pettis (6/12/2015)

---

Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo it. Maybe if...

I suppose that you could create an unformatted partition for the disk or simply deallocate all the space. I'm not sure what are you referring to.

Also, a disk corruption might...

Try the stairways[/url] on this site or the books section[/url] or even the Videos. The entire site is full of valuable information on SQL Server and we'll be happy to...

jasona.work (6/11/2015)

---

Jeff, realistically, I'd probably (for the right price) go as far as...