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

Please answer my question about the shift column and I'll see what I can do.

John

No loop is necessary, especially a loop within a loop, which would kill performance if you have a lot of data. It should be possible to solve this with...

To solve this, I think you'll need a table of dates. Search this site for Jeff Moden's tally table - this is just a table of sequential numbers, to...

Not from my reading of it, no. But study the @@IDENTITY topic in Books Online carefully, and maybe carry out a few tests as well.

John