Mark,

I think you should give us more information if you want to receive useful answer. At the moment, everybody is groping in the dark, not knowing what you need and...

You have written the SQL directly int command window, but in this case it is OK - no need to use stored procedures with such simple commands. Maybe you could...

Just to avoid confusion - what is not supported are only old syntax left and right joins:

"In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions...

I agree with what Antares and Mark posted; just adding a few words to it. Core of the developer's question is :

But doesn’t it seem logical that the...

Hello Ed,

please explain this in more detail:

"Each of those records should return the lowest Receipt_Ctrl# for Customer_code (aka the first receipt ever done to the customer) and the Receipt_Date needs...

My post is called IT Project Manager, which in fact means, that I'm DBA, user support for the software running on SQLS (information system), report generator, and several other things......

On a sidenote, although you can write the SQL directly into the job step, because of performance, maitainability and reusability it is often to your advantage to create a stored procedure from your...

This question is quite common on these forums, you should be able to find some answers... but in short, the answer is NO, you can't do that in SQL Server....

Hello Phani,

as the requirements are beginning to be complicated, I would suggest that you go with the simplest solution

select com_name, off_name, usr_name,

sum(case when status = 'waiting' then amount else 0...

I'm not sure what you need, but you could try to read following topics in BOL:

SUBSTRING, CHARINDEX, PATINDEX, REPLACE ... and possibly some other string functions. These functions allow you to find what character is on...

"I need a way to say 'enough' after 10."

Have you considered SET ROWCOUNT?

I'm not saying this is the best way to go, but it surely stops you after required number...

Hmm.. what is an "answer set"? Does it always have 6 rows in the table for each inspection? Why and what is the difference between these rows? Which of the...

When creating a table, you need to know not only column names, but also data types.

Generally, creating table structure based on data in another table is not considered good practice. You...

Hello,

maybe the best way of correcting this error would be to rewrite the procedure without cursors. If you post the code here, we can try to find some set-based solution. There are...

I am a bit surprised by some things in this article... for example:

"Generally, the rule of thumb is to have as much as RAM as your data file is."

Is it...