here's a test scenario in a ready to use format, returning the expected(?) result.

So, I don't see anything wrong with the code.

declare @tbl table(vndnbr int, InvNbr int, InvAmt numeric(18,6),ChkNbr int)

insert...

But the most "elegant" way most probably still is the calendar table:

SELECT TOP 1 dateValue

FROM myCalendar

WHERE dateName ='Monday'

AND dateValue >= CAST(CAST(YEAR(@MyDate) AS CHAR(4)) +'0401' AS DATETIME)

ORDER BY dateValue

😉

I'm not sure If I really understood your question: but the first day of April in any given year is always April, 1st.

What are you looking for? The Day of...

Can you post the actual execution plan of the query together with the query itself?

There are numerous reasons for a query "suddenly" taking longer than expected:

Examples:

dramatic growth of rows in...

You could use the OUTPUT clause and store old and new values in a review table using the INSERTED and DELETED internal tables.

Ideally, this would be part of the update...

duplicate post. No replies please.

Please reply here: http://www.sqlservercentral.com/Forums/FindPost1436837.aspx.

Now that is a slightly different story...

You asked a question in a SQL Server forum without even mentioning you're talking about MS Access. 🙁

You might find someone around answering your...

Do you use exactly the same code as used in the sproc?

Or did you replace a few variables in the query with hardcoded values?

It seems like the compiled version of...

Based on Stevens easy to use sample data (STRONG hint for future questions... 😉 ) here's my approach. The main difference is the "depending column" having a static header ("FaultType",...

Here are some hints:

a) Don't start a project the night before it's due if the subject is something you're struggling with

b) Please note that this is a SQL Server forum...

Assuming the same WHERE clause is used, you could use the CASE statement in your SELECT statement.

I don't think there's anything unfortunate from my point of view, since you provided a solution even before I encoutered the problem! 😀

So, thank you in advance!!!

After spending some more time searching for alternatives I found a software (http://www.coolutils.com/TotalHTMLConverterX) that doesn't need any GUI communication. Seems like it's the solution I've been looking for.

You'll need to standardize the input source before even trying the BULK INSERT.

SQL Server is a great tool but it cannot "guess" what the final result should look like from...

You might want to look into the CROSS APPLY syntax (use it to get the Top 2 vender_inv ORDER BY SaleID DESC) together with a cte or subquery to...