Discounting the fact that nothing was in Red so I may be missing something important, you ultimately are summing values that apparently aren't bounded within -1 to 1 (OK, that...

It depends on the application. It sounds like the application is coded to work under the signed-in user's authority vs using a single shared user for its SQL Server connections. That...

You told it to look for a single variable of eleven comma space eighty five. You want it to look for the value eleven or the value eighty five. Therefore,...

I think this should get it. It isn't the most ideal approach, but it should work.

update table set A.sequence = ( Select COUNT(*) from table B where B.category = A.category and...

You can convert them to varchar.

select 1 as ord, player as player, CONVERT(varchar, sum(pts)), CONVERT(varchar, sum(rebs)) from sum_players where tm = #tm#

union

select 2 as ord, 'Total' as player, CONVERT(varchar, sum(pts)), CONVERT(varchar, sum(rebs))...

@NEXT_YEAR is an integer and causes string concatenation problems. CAST or CONVERT it to a varchar.

'7/1/' + CONVERT(varchar, @NEXT_YEAR),

'7/31/' + CONVERT(varchar, @NEXT_YEAR)

Look up CONVERT in BOL ( SQL Server Books Online).

It sounds like your style of cluster is the type that does not share a physical hard drive since you had to make sure Winzip was installed on both machines....

When you import the data apply a manual transform. Transforms use VBScript or JScript and you can fairly easily make a change like that as you are inserting into the table.

Once you fix the input the output worked fine for me, although I believe it is succeptable to access path variations and I don't think it will work all the...

I can't really imagine a downside to bulk insert for this situation. I would suggest you use it in this case. However, in case someone else is reviewing this for...

In QA, Tools -> Options -> Fonts.

In EM, its tricky. It took us a while to find it. Open a SP. Right click in the background. Choose Fonts...

The Tools ->...

INSERT INTO tmpTable exec sp_Get1

So long as tmpTable is either a real table or a "normal" #tmpTable that works. EXEC isn't compatible for INSERTing into variable based @tmpTables, though.

Alternatively you...

I have no idea why, but the cursor is faster. Time trials on one of our databases with over 500 tables took about 100 milliseconds as a cursor and 1000...

Not that I have any real problem with the code Calvin posted but I will put in my 2 cents. I prefer using BEGIN and END clauses as they make...