Can you use the CASE method for crosstab query?

This is stored in a varchar column, I guess? And you don't want to just trim all of them.

This is a little hacky, but you could

select column

from yourtable

where...

Can you explain about why you need to know? Because comparing strings for trailing blanks is a little complicated, and it would help to answer your question if we knew...

Check out this UBER page on date calculation:

http://www.aspfaq.com/show.asp?id=2519

Jim - is this a big production database?

My take on this: both Autogrow and Autoshrink might be OK for small / less used databases, but for a large one that...

Luckily, SQL Server 2005 reportedly will have a new operator LooksLike that will find images that look like other images or items described in strings. For example:

Select * from myScans

where...

See also

http://support.microsoft.com/kb/314546/EN-US/

http://support.microsoft.com/kb/224071/EN-US/

See the DateAdd and getdate functions

dateadd( "d", -90, getdate() )

dateadd( "mm", -3, getdate() ) etc.

It looks like your procedure creates a regular (not a temp) table and never removes it, so it remains afterward. Temp tables start with the Pound sign (#); put a...

Automatic data type conversion. Certain datatypes are automatically casted when you have a comparison using two different types.

Alice -

I thing the best method is to change (or add?) the SQL query to use SELECT DISTINCT, which will filter out duplicates.

HTH,

Merrill

Yes, I have done that. I generally make a temp table, then execute something like

SET @listCom = 'DIR /b ' + @yourFolderName + '*.foo'

INSERT INTO #dirlist ( fname ) EXEC...

Alice - your question makes me worry :-).

If you are not getting the right information in the dataset in the first place, then you really need to adjust that so...

Either that, or a single page form, "Enter the number of the record you want."

🙂

No, I don't think so. I've always had to use conditionals, e.g.

if @dbase = 'foo' use foo

if @dbase = 'bar' use bar