I think this is what you are looking for, but not sure.

SELECT ISBN, max(dbo.ActiefStatus(Status,Hist)) Status

from Titel_BB

group by ISBN

order by ISBN DESC

you can use a CTE like below, but because the 'Date' field is a varchar and is only the month name, then the sorting gets screwed up. If the...

Can you provide table layout, sample data and expected results. It's easier than us guessing. Check out the first link in my signature to help with posting to...

the inner join to the Staff table is what is limiting the data coming back. But it's hard to test without sample data and table layouts. But try...

Mary,

from what it sounds like, if the data is split out by fiscal year, then instead of different tables, you could have one table that is partitioned by fiscal year....

you shouldn't have to select it. It's an output parameter

simflex,

with all the code flying around in this post, it's hard to keep straight. Can you provide the latest code that you are working with?

BT/Scott,

this forum is to try...

what is the actual data you are expecting when you decrypt the value (varchar)? Try to set the parms to that data type instead.

CREATE PROCEDURE [dbo].[usp_GetDecryptedVal]

@EncryptedVal varbinary (256),

@DecryptedVal...

I was able to get this to work with Lotus Notes without too much trouble, so it does work with Notes. A couple of questions, in the Properties...

I think one of the easier ways to accomplish this is to create a WheelID and assign it to the cases the same time the judge is assigned. The...

try this. You didn't provide the table layouts or test data to test this with. So at least this will get you started. If you provide these,...

this gets the value from a table

DECLARE @tbl TABLE(PrecisionID int, PrecisionNum int)

INSERT INTO @tbl

SELECT 10, 1 UNION ALL

SELECT 11, 2 UNION ALL

SELECT 12, 3 UNION ALL...

Laurie, you can do this dynamically, but I don't know why you would want to do this. Here's an example of how to do it dynamically

declare @vn_precision int,

@vs_sql...

the syntax looks ok. Not sure why you're getting the error. Are you running with the latest service packs? I ran this on SQL 2005 Developer Edition...

Are the format of the records in this table all the same? try these

declare @vt_t table (docid varchar(50))

insert into @vt_t

select '99~B007340~9822151~LR5~250' union all

select '99~B007599~9417974~LC0~240'

select substring(docid,charindex('~',docid)+1,7)FirstString,

substring(docid,CharIndex('~',...