the sql server installation process has lots of optional components. did you install reporting services?

as the error msg pointed out, you have not declared @tg-2.

[font="Courier New"]WHERE A1.ref = t2.s_studentreference AND t3.e_reference = @tg-2[/font]

you'll need to either make it a report...

express edition has practically every feature that the full version has and supports the full SQL dialect. compact edition is not intended for multiple users and does not support...

TRY...CATCH.

eliminiates the need for error check after every statement.

your top N query

(select top 1 StatusID from CustomerOrderStatus

where CustomerOrderStatus.OrderID = a.OrderID order by StatusID DESC)

can be replaced with

(select max(StatusID) from CustomerOrderStatus

where CustomerOrderStatus.OrderID = a.OrderID)

the...

Piper Skip (4/21/2008)

---

I'm seeing the same error message for the following code:

CREATE TABLE #CDHToDelete

(

CDH_RecordID UNIQUEIDENTIFIER

)

INSERT #CDHToDelete

SELECT CDH.CDH_RecordID

FROM (IERP72..CommissionDefinitionHeader CDH

INNER JOIN IERP72..CommissionDefinitionDetail CDD

...

top with a variable/parameter is valid SQL:

declare @top int

set @top = 25

select top(@top) * from [some_table]

can you post your query?

Piper Skip (4/21/2008)

---

I'm seeing the same error message for the following code:

CREATE TABLE #CDHToDelete

(

CDH_RecordID UNIQUEIDENTIFIER

)

INSERT #CDHToDelete

SELECT CDH.CDH_RecordID

FROM (IERP72..CommissionDefinitionHeader CDH

INNER JOIN IERP72..CommissionDefinitionDetail CDD

...

if you want to create intervals based on a fixed number of days and you're using a matrix then you can modify your query, you could just add another column...

you could also use the OUTPUT clause:

[font="Courier New"]declare @batch table( CliendId ...)

WHILE SELECT COUNT FROM #Temp > 1

BEGIN

INSERT NewClients(ClientID) Select...

I'm confused as to why you want to return column names that have a NULL value. Almost any version of VB (whether .NET based or still using ADO)...

if you're using a query (rather than a stored proc), you only need to create a report parameter and reference that parameter in a TOP clause:

select top(@parm) ... from ...

you'll need to assign rights to users/groups for the physical folder that the http://server/ReportServer virtual folder points to (usually \Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services).

if you're using IE...

i don't know if CTEs can be nested, but if not you can do everything in 2 queries. your first and third datesets calculate lead over (ID_PRSN and DT_BGN)...

i agree. there seems to be more and more demand for ordered processing, but i'm sure codd and date would say that order should be irrelevant from a relational...