Works great!

Thanks.

For others, I had to remove Sorting in the Category Groups.

Yes I think you found it. 🙂

Why is this?

The results for the months look fine.

The query returns

28November2012-11

40December2012-12

84January2013-01

64February2013-02

73March2013-03

119April2013-04

99May2013-05

70June2013-06

95July2013-07

113August2013-08

100September2013-09

187October2013-10

65November2013-11

NULLNULLNULL

I would like to know if the number of cars rented each month is increasing or decreasing

Here is an example

SELECT Model, RentalDate

FROM CARS

Here is what I did:

Example:

SELECT Manufacturer, Model

FROM CARS

WHERE Manufacturer = @Manf AND Model = '2 door'

Here is what I wanted a prompt for Model = '2 door' or Model <>...

No I didn't.

So far I wrapped my query in an expression and used a paramater within the expression. Works, but is slow

Though this is late, maybe it will help someone else.

You need to have setupadmin rights first, then run

GRANT ALTER ANY LINKED SERVER TO loginname

Now you will be able create...

I was hoping to use it in WHERE statement and this is just an example.

DECLARE @MYTEST AS VARCHAR(3)

SET @MYTEST = '<>'

SELECT CARS.Year

FROM CARS

WHERE CARS.Year @MYTEST '2011'

I guess I have phrased my question wrong.

What I was wondering is if it is possible to use a CASE statement to return BUICK, CHEV, and then All Models (including...

The ELSE statement is not returning all models

I even tried NVARCHAR

I get +ù+Å-¦+ó-+-¬+ô+«+å-¦+Æ+¦+è+ñ+ê

SQL_Latin1_General_CP1_CI_AS

It is a CODEPAGE issue.

Now it inserts like "×Ϲ⻪ÓîÆ´ÒôÊäÈÃ"

I hope this helps. The list to exclude is much longer than this.

SELECT MODEL

FROM CARS

WHERE MODEL NOT LIKE '%S2%', MODEL NOT LIKE '%R5%', MODEL NOT LIKE '%G8%',

MODEL NOT LIKE...