Your not constructing your dynamic sql correctly.

if you want to pass parameters into dynamic sql, then you MUST use sp_executesql. the EXEC function does not except parameters.

If you do...

Your desire to find companies within a certain distance of a given point is fairly simple on the surface,

Your function is not correct tho. (I did not check your...

Would this work?

SELECT SUBSTRING(PK, Charindex('=',PK)+1 , (len(PK)-1)) FROM audit

or you could wrap a replace..

SELECT replace(SUBSTRING(PK, Charindex('=',PK)+1 , len(PK)),'>','') FROM audit

What do you mean based off Previous AchieveLevel?

Your talking about comparing values from two different rows?

Please post sample data and desired output so we can see what your looking for..

Thx

😎

There is no need/ way to integrate stored procedures with a trigger.

For triggers you gain access to 2 virtual tables called "Inserted" and "Deleted"

Inserted holds the data that is being...

What data type is the code column in your emp table?

Please Post table definition.

It is likely your code table is an int.

Try

Select jobid As job,

CASE WHEN code in ('1','2','3') THEN...

Richard Sabbara (10/6/2006)

---

I need a quick on line refresher on Indexing, any idea where I can go? I finally have a need to build an index, just don't remember some...

I am assuming your talking about reporting services.

If not, please post and let us know.

Give this article a read

http://www.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/

Or this

http://msdn2.microsoft.com/en-us/library/ms345242.aspx

:D, Just playin about the cursor,

I don't think the error your getting has to do with the open query query, its coming from somewhere in the string.

Either your string...

select A.*

from BaseOutlet A

join (select CaseId, OUTL_ID, MKT_ID, max(cast(TAC_ID as tinyint)) as TAC_ID

from BaseOutlet

group by CaseId, OUTL_ID,...

If you have reporting services running, it is a good solution to do this.

Thats what I Have done in this scenario

What size are your @SqlString parameters declared as?

Try printing the @SQLString

Print @SQLString and in the messages tab, copy and paste that into a new window and see if you can...

select distinct top 10 CNO

from MyTable

No,

a second query is in order

alter PROCEDURE TestProc

@SumTotal money OUTPUT,

@AvgTotal money OUTPUT

AS

SET NOCOUNT ON

SELECT @SumTotal = Sum(LineTotal), @AvgTotal = Avg(LineTotal)

FROM Sales.SalesOrderDetail

SELECT SalesOrderID, LineTotal

FROM Sales.SalesOrderDetail

What control are you using? the Table control?

on each cell on the table control you can select the Cangrow Property and set it to false.

That will maintain the layout...