The OPTION(fast n) does not require to change numbers on each fetch. It's just that it is so in our system... maybe you'll be happy without any TOP clause and fixed...

Hi Gavin,

there is one thing you can do (it will come useful in more complex queries) - name the "inside" part of a query and use it as a derived...

IMHO the best info you can get about cursors is how to avoid them, especially if you're just populating a grid. Set-based approach with standard SELECT should outperform cursors in...

It works fine in my DB as well. Did you cut and paste the actual script that is not working, or did you edit it to make it more simple?

If you...

Hard to answer this question without DDL and sample data.. An obvious reason could be that one of the columns used in concatenation contains NULL values. If only one of...

Hi Francis,

I can understand that you don't want to change anything right now, when you're only learning how everything works. I'd do the same... it is better to map everything...

Yes, and you don't need a SP for that. You can do it directly in the query. Result of DATEPART is a number, so you just have to convert that to string...

If you set "Results in Text" in QA (menu Query), you can edit the resultset. However, I'm not sure how that helps you. I'd definitely prefer to save the result...

There are several ways how to manipulate dates, this is one of them:

-- 1st day of the current month

SELECT CONVERT(char(6), @date, 112) + '01'

-- 1st day of the next month

SELECT DATEADD(month, 1, CONVERT(char(6), @date, 112)...

Hello,

I'm not sure whether this is the reason, but... parameter @server in your code contains full address, used when communicating with the server from outside of domain. I suppose you're in the same...

Well, what else the query could return if you ask date to be converted into INTEGER?

Convert it into VARCHAR(7) instead, as mentioned in my previous post... Please read about conversions and datatypes...

Just to further clarify the situation, no, having Enterprise Manager running locally is not the same as to have SQL Server installed and running on your machine. Enterprise Manager and...

Please post the entire query by copying it from QA, where you have verified that it does not work. Such problems are often due to typos (, instead of ....

Yes Trystan, that's it. @myvar is how the parameter is called in procedure. You just explicitly name it when assigning values during SP call, to make sure there is no...

We started with xp_sendmail, but later on realized, that it has certain limitations and rewrote most procedures that mail results to use smtpmail.

The only problem we needed to solve was...