Karthik

Try reading some English-language newspapers. You will find that the sentences are clear, concise and well-formed. Stick to the type we in the UK refer to as "broadsheet"...

What do you mean when you say it doesn't work? Does it give an error message, or does it just not return the results you expect? Please provide...

Please will you post your table structures in the form of CREATE TABLE statements and also give some sample data in the form of INSERT statements. Also, please show...

Could it be to do with your regional settings? What happens if you do SELECT CAST (GETDATE() AS datetime)?

John

The data is stored the same no matter what your regional setting is. What changes is the way dates are presented, and the way SQL Server interprets dates that...

If shifts have to be 0, 1, 2 or 3, why do you have 4s and 5s in your view?

Something like this may do it for you. If it...

I think it would help if you posted some DDL for all relevant tables, because I'm confused about what tables you have and what they're for. Please include foreign...

Create a table of dates (as I suggested in answer to another of your questions) and left join it to table1.

John

Karthik

We're checking that the first character is equal to the last, the second is equal to the second to last, and so on. You only need to do that...

C'mon, Karthik - do some of the work yourself! What don't you understand?

John

Karthik

Try this.

John

DECLARE @word varchar(20)

DECLARE @length smallint

SET @word = 'AbleWasIEreISawElba'

SET @length = LEN(@word)

IF EXISTS (

SELECT *

FROM master.dbo.spt_values

WHERE type = 'P'

AND number between 1 and @length/2.0 + 1

AND SUBSTRING(@word,number,1) <> SUBSTRING(@word,@length-number+1,1)

)

PRINT...

Why don't you want to use REVERSE? Is this a homework question?

John

Please will you post your table structure and some sample data and expected results. It's difficult to visualise your problem without this.

John

If you want to use dynamic SQL then you to use it for the whole statement. Something like this:

EXEC 'DECLARE C CURSOR FOR ' + @QueryString + ' '

I...

Do Antares's solutions not work? If no, tell us why not and we'll see if we can help.

John