SELECT pi.ProductId, pi.name, pi.familyName,

CASE pp.priceAssigned

WHEN 'listPrice' THEN pi.listPrice

WHEN 'price1' THEN pi.price1

WHEN 'price2' THEN pi.price2

WHEN 'price3' THEN pi.price3

WHEN 'price4' THEN pi.price4

WHEN 'price5' THEN pi.price5

END AS [priceAssigned]

FROM Customer c

JOIN ProductPricePerCustomer pp...

Sorry I meant an option to...

mtassin (3/14/2013)

---

Toreador (3/14/2013)

---

Most disappointing. I was sure when I got to the thread I'd see several pages of identical replies saying that it gives an error about assigning variables in...

You have to cast run_duration to varchar first.

Try

STUFF(STUFF(RIGHT('000000'+CAST(run_duration as varchar(6)),6),5,0,':'),3,0,':')

Jeff Moden (3/11/2013)

---

Thank you Mr. Burrows. I learned something new. In the past, I've written just such a function that apparently works the same way. I don't...

Lynn Pettis (3/11/2013)

---

I don't think there was...

SELECT DISTINCT j.name as job_name,

msdb.dbo.agent_datetime(run_date, run_time) AS [run_datetime],

DATEADD(second,DATEDIFF(second,0,msdb.dbo.agent_datetime(19000101, run_duration)),msdb.dbo.agent_datetime(run_date, run_time)) AS [run_endtime]

FROM msdb..sysjobhistory h

INNER JOIN msdb..sysjobs j ON h.job_id = j.job_id

WHERE j.name NOT LIKE 'Backup%'

AND j.name NOT LIKE 'Cleanup%'

AND...

Brad Marsh (3/10/2013)

---

Hi Vinu,

the excel sheet has both the data output and the expected result from what I am trying to achieve. There are 2 sheets on the excel document....

In which case you will have to produce several sub queries to produce totals as sugggested by pete.

Simplistically put

SELECT t.ID,u.Units,v.Initialvisit

FROM t

LEFT JOIN (SELECT COUNT(*) AS [Units] FROM [unittable]...

I was thinking more on line of

SELECT XX.XY, XX.YY, XX.YX

FROM Properties

JOIN XX ON XX.RMPROPID = Properties.RMPROPID

WHERE Properties.RMPROPID IN (@PROPERTIES)

Which will give you one row per...

or

UPDATE a

SET a.[Col 2] = b.[Col 2],

a.[Col 3] = b.[Col 3],

a.[Col 4] = b.[Col 4]

JOIN b ON b.[Col...

+1

Adding DISTINCT to the query will give you the results required as per the spreadsheet.

Two observations.

1. CaseID has different data type in the two tables, presume this is a typo!

2....

Which table contains Vendor_Code ?

Add a dataset to the report that queries the ExecutionLog table on the report server and show/hide parts of the report according to the time difference betwen last time the...