hxkresl (4/17/2012)

---

stuck on an error in the SELECT statement

Msg 207, Level 16, State 1, Line 32

Invalid column name 'Portfolio'.

WITH Maxticket AS (SELECT AD.ID, AD.OrgName,

...

ok so we put the renaming of the column into the first CTE as follows:

WITH Maxticket AS (SELECT AD.ID, AD.OrgName,

...

Lynn Pettis (4/17/2012)

---

hbtkp (4/17/2012)

---

ok. i already posted my formula for cumulative.

i hv another prov

i have delcare variable

declare @abd datetime

now i need to get 1 date from function

like

select @abd = fromdate...

zojan (4/17/2012)

---

If you want log steps of the SP_ you can use loging into log_table.

You can lo step (which is executed), Getdate(),...

you can add sp_name column to log more...

hxkresl (4/16/2012)

---

It's really helpful capn.Hector. Thanks for mentoring.

I have one last thing to do.

The report must have one additional level to it's hierarchy that doesn't even exist in the...

Cadavre (4/17/2012)

---

This is quicker: -

SELECT DATEADD(DD,N,GETDATE())

FROM (SELECT N

FROM (VALUES(0),(10),(20),(30),(40),(50),(60),

...

i have always used SELECT 'String you want to display here' and not had a problem with multiple outputs in a stored procedure.

i got it to work by using the following:

WITH fechas (fecha) AS (

SELECT GETDATE() AS fecha UNION ALL

SELECT DATEADD(day,10, fecha) from fechas )

select TOP 12 fecha from fechas -- instead...

it would be adding a variation of your case statement you have in the cte to the final query, not using another cte. i can post the answer in...

i...

it has been discussed before but in case its hidden some where.

depending on how mission critical the box is we install patches the next time we have to reboot after...

i hate to be the bearer of bad news but because its AT&T you have to live with the quirks. AT&T does this with every email (as far as...

see the original thread i have posted an answer there.

; WITH Maxticket AS (SELECT AD.ID, AD.OrgName, AD.ProjName, AD.Ticket#, ROW_NUMBER() OVER (PARTITION BY AD.Ticket# ORDER BY Revision_num DESC) AS revision

...

degrees