SOME DLL would be good hover i have re arrangged your cursor to do what i think you mean.

DECLARE cur_ProdHistMstr CURSOR FORWARD_ONLY

FOR

SELECT convert(datetime,absdate) as absDate

, 'Pack'

, Item

...

at the moment i dont want to do anything after z27 however, i may then want to re loop it through a second loop to start at AA1 through to...

Champion thanks 🙂

i did some work for a prospect in CHINA in order for me to display the chinese characters i used NVARCHAR data type and downloaded the latest chinese language package...

there is a report that you can run that till tell you who last changed the stored procedure and when. from ssms navigate to your database, right mouse click on...

looks like i stand corrected and you cant use SET CONCAT_NULL_YIELDS_NULL { ON | OFF } for calculations of int field so use isnull function 🙂

at the top of your script set concat nulls on then off at bottom 🙂

SET CONCAT_NULL_YIELDS_NULL { ON | OFF }

When SET CONCAT_NULL_YIELDS_NULL is ON, concatenating a null...

i have encountered a situation where i could only update 1 row at a time and the way i worked around was to use a cursor.

You could like the...

I would say if not exists

Whats you error? and you cant use a case statment to procude a IN ( val,val2) clause...

can you post DDL information please and we can look at this for you

abdul.badru (7/6/2012)

---

If you dont want to use the case in where condition you can consider using Common Table Expression and then use your new columns in where condition in another...

i see you have identified the non numeric char, not sure how you did it, but here is one way to identify rows that has any none numeric characters

where PATINDEX('[^0-9]%',collumn)>0

Hi yes it is possible to have a case statement in a where clause

Jeff Moden (6/30/2012)

---

Since the OP didn't have that in the...

Read up on use the READ UNCOMMITTED isolation levels, also do you know how many reads your query is doing?