Since this is a CRUD procedure, and as Luis said, you should be adding the variables as input parameters for the procedure for CREATE & UPDATE operations.

Thanks Ron for the QoTD. Today, I've learned that "TOP WITH TIES" returns ties only iff the last row is tied. Darn, all along, I was thinking TIES...

As explained by the previous poster, the update statement is actually updating all the rows of the table because there is not filtering clause (where clause) or top clause.

If you...

1. Try running the report with fewer rows by using TOP.

2. Check if the data retrieval or processing is taking time (can be found in report execution log table in...

Can you post the error message for invalid login attempts appearing in SQL Error log? Be sure to include the error details such as error no, severity, level, state...

Can you post the exact error message that you received while connecting?

If the posted query is just a little part of a big query, I request you to post the entire query with some explanation about the requirement.

I see...

Does remote connections enabled on the server?

Is SQL Browser Service running on the server?

Why you are converting a datetime column to char and then doing a comparison?

When you say it is failing, does you get any errors? If not,...

This is a really very old issue with excel and data providers. To overcome, you have to set the extended property "IMEX" of provider to value of 1. ...

NULL and '' (empty string) are not same. SQL interprets empty string as a valid value, that is why the insert is failing.

Try replacing empty string with NULL...

Let's see if this works for you.

SELECTCOALESCE( c.aK, a1.K ) AS aK, c.aV, COALESCE( c.bK, b1.K ) AS bK, c.bV

FROM(

SELECTa.K AS aK, a.V AS aV, b.K AS bK, b.V AS...

I am not sure if I understand your requirement completely, but I guess you are looking for something like this

SELECTa.K, a.V, b.K, b.V

FROM#A a

FULL JOIN #B b ON a.K...

I'm not able to view the url you have posted but I think if it is a table then you can change the background color property of the row by...

This is because you are not considering the time-part of the date. By default, a date without time is considered as 00:00:00.

You either need to explicitly add the time-part in...