I had some young people just graduating from college working for me.  Their technical skills were excellent but they did not have any business skills.  Sometimes I feel I am under...

I always test the answer I get from the post.  As Ronald Reagan said to Mikhail Gorbachev ' Trust but verify'

Steve

This is so far the best SQL server website I encounted.  I had posted many questions and people were willing to help and I got a lot of good answers. ...

Array processing - before SQL Server 2000, you can only create temporary table, but now you can create an arrary.

DECLARE arraryname TABLE (....)

It is just liked creating a temp table but...

One time I had two interviews.  One offered lower salary, one offered higher salary than I was earning.  Of course I took the high salary without looking further into the company and...

Michael,

I created the Lotus Notes profiile and used it in SQL Mail.  When I tested it using xp_sendmail, it said 'Mail Sent' but I did not receive any email.  So...

Michael,

Just curious, what does SQL Server 2005 do to fix this problem?

Thanks

You cannot use #temp in dynamic SQL.  Temp table only exists in current session.  If will automatically delete after you finish the session.  So if you use dynamic sql, it...

Unfortunately it is very hard to find someone in the company you can depend on or ask question.  In my old company I got into trouble when I talked to...

This is not data mining.  It is marketing analysis. I used to work for a marketing research company.  You have to pull a sample of audiences of different ages, gender, education background, georgraphy locatioin,...

I agree team work is important, but it depends on which team you are on.  I worked in many projects in different companies.  These were some of the teams I...

Since the industry does not pay too much attention to SQL and most companies think writing SQL is easy.  That's why we had a hard time to find a good...

In my old company, they valued VB.Net, C#, Java are important but not SQL because the VP of the IT department said 'SQL is simple, any idiot knows how to...

When you create a function in a database, there is a permission issue, only sysadmin, db_owner and ddl_admin can use it but sysadmin can grant execute permission to other logon....

Do you want @Temp to capture the sum of all the quantity? Then your query had a problem.

DECLARE @TEMP AS REAL

SELECT @Temp = SUM(CASE WHEN ISNUMERIC(tableX.Quantity) = 0

...