I grew up in Hong Kong, went to college in Minnesota, then came to upstate NY.  So I live in upstate NY for 23 years.  It does not mean I...

Gift,

Even I can break the DBA permission to change the production data no matter what kind of security they implemented. My old DBA always asked me if I could...

Classified jobs need security clearance. What about the jobs in private section liked the banks outsourced to the other countries. The banks had customer data, remembered Citibank lost...

I always wonder one thing about the companies outsourcing their IT development to India, China or some place in this universe.  Even the companies claimed that they only allowed those...

Yes I agreed the BI tools are getting earier to use and more robust.  I am a data warehouse developer, I got calls from vendor everyday.  Most of them can...

Why do you use TOAD when you already have query analyzer ?

I only use TOAD for Oracle since Oracle itself does not any GUI interface (shame on Oracle and Larry...

I read the book 'One minute manager' and many other books about how to influence people and how to be a good manager.  For all my years working in different...

These days I find out it is very hard to know who is the 'jerk' and who is your 'friend' at work.  I met a co-worker who was nice and...

I am in IT business for 22 years, and I have to say I got burnt out too.  Most companies these days do not appreicate good employees, with layoff and...

Rudy, I agreed with you.  Unfortunately there is no ideal company or perfect company,  (if there is, let me know), the matter of the truth is no matter where you...

Steve,

This week you seem to like to talk about management and working environment a lot !!!

'A jerk' and 'Difficult person' is very...

I would find another contracting job !!! 

The function is looking for an input field as data type INT.

When you did this

SELECT dbo.fnFindPositionSupervisor(SELECT  PositionID FROM Employee WHERE  ID = 5)

The function did not know the data type...

You need to add user 'usraspstate' to the database, or under 'Security', 'Login', find the user 'usraspstate', under the tab 'Database Access' click the database that this user allows to...

Where were these come from?

Select distinct PolicyNumber,TableCode,SeriesCode

from #tmp1

Fetch next from cursor1 into @PolicyNumber, @TableCode,@SeriesCode

Was cursor1 another cursor you defined?

The procedure complained you never declare @PolicyNumber, @TableCode and @SeriesCode.

Also...