The like statement will not work if the statement is less that 9 chars.

what you want to do is search for a non-numeric char starting from the 3 char in...

I still wouldn't use is numeric as "." is also included in the check for example 10.10 would be numeric.

me too 🙂

Here is a solution that will work for Multiple Image types:

CREATE TABLE MyTable

(Id INT,

CustomerId INT,

ImageName VARCHAR(100))

INSERT INTO MyTable

SELECT 1,123,'123_X.jpg' UNION ALL

SELECT 2,123,'123_Y.jpg' UNION ALL

SELECT 3,456,'456_X.jpg' UNION ALL

SELECT 4,456,'456_Y.jpg'...

the variable be assigned the value of every row, so the last row return is what the variable will be.

Because a table has no Order and you not using an...

Why would you expect 1?

have you looked up Pivot/cross-tab queries?

Have you tried searching around here for Pivot and or Cross-tab queries?

If you can't find anything let me know.

Also please answer the question above as this will determine weather it...

try this:

;WITH CTE as (

select

ROW_NUMBER() OVER(PARTITION BY Item,price1,price2 ORDER BY Date DESC) Row,

*

from #temp

)

SELECT *

FROM CTE

WHERE ROW = 1

order by date

try this:

SELECT

Category,

COUNT(*)

FROM

(SELECT

CASE WHEN salary between 0 and 10000 then 'range = 20000 and salary = 30000 and salary = 40000 and salary = 50000 and salary =...

could you supply some the definition of your table and some sample data with the expect output.

It's pretty hard to write a query for a desired output if you dont'...

The Records are inserted in the same order.

AS you can see by the ID values assigned.

I think you mean that rows are returned in a order that you are...

Taking the CTE and test data from Imu92 here is a dynamic solution

CREATE table t (CIF char(4), ACCTNO int, SSNO varchar(10), CODE int)

insert into...

Have you tried making it dynamic?

will your output always only have code and code1

or is it possible to have:

code code1 code2 code3 etc?