The

SELECT @variable = @variable + myfield

FROM mytable

portion is this undocumented feature Sergiy wrote about.

It allows you to concatenate all myfield values selected by a query into a variable in a...

I think the problem comes from the 'golden plate'

SELECT @Message = ISNULL(@Message + ',', '') + Z.REP+':'+ Z.INFO

FROM (

SELECT LEFT(SLPRSNID,2) AS REP,INFO

FROM @Stage

WHERE SLPRSNID...

Actually I was referring to you first post while you were adding that little bonus of the concatenation when you do a select into a variable.

Sergiy,

do you always hand out everything on a golden plate?

I don't know if I understand the problem correctly but if you question why your @message is NULL at the end of the loop then the answer is because it is...

Well. In a case when you have limited amount of data that fits into single page creating an index will decremet the performace because you will ask the server to...

I think you could access the sysfiles directly if what you mean by accessing is reading their content. Actually I would advice anyone to learn about them and use them as...

You should be able to do it using something like this

ALTER TABLE yourtable DROP CONSTRAINT yourconstraint, COLUMN yourcolumn

you can also list any indexes you have this column tided up to.

If you want...

I don't know if it was apparent from the previous posts but you should be fine if you change this

SELECT @sql = 'SET IDENTITY_INSERT ' + @tablename + '...

I don't know if I understand you correctly but I think you could get the records combined by using something like this

INSERT INTO realtable

(

...your fields....

)

SELECT

item,

branch,

month,

source

SUM(inv_value),

SUM(cme_value) 

FROM mc_staging

WHERE ...your condition...

GROUP...

Depending on your particular case you could do the following:

Create a table that will hold all the holidays

CREATE TABLE Holidays (holiday SMALLDATETIME)

Populate this table with all holidays that do not...

Jeff,

I came up with somewhat similar code but I didn't have the + 1 in the first line. Otherwise there is 1 business day between today and today and I...

I am glad I could help a bit. Views can be very sensitive and tricky. Sometimes they don't aways work as you would expect them to, especially when you start joining them.

Do you need to deal with holidays as well or do you want to exclude Saturdays and Sundys only?

I don't know if this is a viable solution but one of the things you could do is to create a table with something like this

CREATE TABLE itemmultiplier (...