Hi

Please can you post DDL, sample data and expected outcomes so that we can help you out further.

The second link in my signature will help if you get stuck.

Thanks

Something like this

with cte

as

(

select

car.vinno,

car.model_id,

--sales_bill.billno,

--record.recordno,

max(areaofsales.zone_id) as Zone

from

car

inner join

sales_bill

on

car.model_id = sales_bill.model_id

inner join

record

on

sales_bill.billno = record.billno

inner join

areaofsales

on

record.recordno = areaofsales.recordno

group by

car.vinno,

car.model_id

),

cte2 as

(

SELECT

ROW_NUMBER() OVER(PARTITION BY model_id ORDER BY Vinno) AS RowNum, Vinno, model_id, Zone

FROM

CTE

)

SELECT

Vinno, model_id,...

Dont you just need to do an order by vinno asc or zone_id desc

edit, didnt test with sample data, not just an order by needed

Have all statistics been updated? DBCC UPDATEUSAGE run?

Profiler or a trace for the audit logout event.

Or build a custom script which checks sys.dm_exec_sessions for a spid and username and run it every so oftern, when it appears...

Thats the QotD from Wednesday.

Have you answered the question yet? If so it tells you why you get no results.

What is the result of

DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS

Could you post the execution plan for the procedure?

Have you checked index fragmentation and statistics to ensure they are defragmented and updated.

If stuck please follow this link http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

The problem is with the offset, you would first need to convert the string to a offset then to a datetime

Like this

SELECT convert(datetime,convert(datetimeoffset, '2012-08-01T15:05:13.000-04:00'))

This will then add on the 4...

If your not installing SSRS anywhere then you dont need licenses, if your using the reportviewer controlls within VS and providing a rdlc file and not using the portal or...

No, if you want to use SSRS you need to have the correct SQL license, there is no way around it.

Your looking at around a minimum license cost of $7200...

Looking through the licensing datasheet, it doesn't mention hyperthreading.

Instead the area about how to license says

How to license

1. License all of the physical cores on the hardware

2. A minimum of...

All the numbers you have given SQL are whole numbers, so SQL will only return a whole number.

If you want the decimal point, you will need to change a value...

When you do a restore, it logs the backupset that was used in the restore into the backupset tables.

What you are seeing are the backupsets from the primary server Database1...

So this is going to be a new server for the engine and SSRS? If so make sure you take a backup of the reporting services encryption keys before...