Jayanth_Kurup (6/27/2011)

---

Hi

This would remove scope for inserting a range between 1 and...

Something like this:

declare @MaxToPoint Int

select @MaxToPoint = max(ToPoint) from PLevel

If @frmPoint <= @MaxToPoint then --> error

I am assuming that selecting MAX(ToPoint) and making sure that your range is above that is not adequate?

Please mark the bit that is creating the error. 'Third step' does not make it clear to me.

Also, please post the text of the error message.

Why does it fail?

Why do you need a cursor?

It's not easy to understand what you are asking - can you provide sample input data, with desired output?

GilaMonster (6/23/2011)

---

There's a massive difference between the two.

The first there's a function applied to the column. That makes the predicate non-SARGable, meaning SQL can NEVER use an index seek operation...

As you are looking from the start of the column, you can use this

WHERE LEFT(fldField,3) = 'NCB'

- just a little tidier and avoids wildcards.

Here is proof that "it works"

DECLARE @a CHAR(1) = CHAR(10)

SELECT @a, ASCII(@a), REPLACE(@a,CHAR(10),' '), ASCII(REPLACE(@a,CHAR(10),' '))

Now please try to explain how your problem is different from what has been suggested.

How large is 'large'? Do you want to do this internally (ie, using your own network/Exchange infrastructure), or use a third party (which you might, if large really is LARGE)?

Try something like this:

DECLARE @a VARCHAR(20) = '010711'

SELECT @a,

'20' + RIGHT(@a, 2) + SUBSTRING(@a, 3, 2) + LEFT(@a, 2)

Jnrstevej (6/22/2011)

---

Hi

I'm trying to format the column(dueDate) which contains the date to a YYYYMMDD format

My understanding to achieve this would be

select convert(varchar,getdate(),112)

select CONVERT(date,duedate,112)

from test

--my attempt

select convert(varchar,duedate,112

from test

--Test table...

Nasty.

I've thought about the logic a little & this might work:

If @StartDay <= @EndDay then

where Day(Birthdate) Between @StartDay and @EndDay

else

where Day(Birthdate) Not Between @StartDay and...

Sachin4all (6/21/2011)

---

Insert into hs(Id, Date, time)

select utid,date,time

from time t

where transactiontime between ? and ?

I have created the varibles startdate and enddate as datetime

Sourcetype as directinput...

You continue to infer things...