Hello,

I got to look at the problem again and realized, that - if I understand everything correctly - this query should work even if the products are not ordered, as...

Cursor is IMHO not necessary... and if the BuyListingID and SellListingID would always be precisely as they are in the example - meaning that the ID is identity column with increment...

Hello,

I'm not sure I understand everything correctly from your posts, but I'll try to answer your original question from thread title - yes, it is possible to start a job on...

What the COALESCE or ISNULL does for you is, that it sets the starting value to empty string instead of NULL, that's all. If you declare a variable, it has the...

Hello,

if by "transactional backup" you mean the transaction log backup, then 3 hours is IMHO not often enough and you should consider making it more often. I know this is highly individual,...

Hi,

you didn't mention any info about the data type of underlying tables. What are the data types of columns A.Date1 and B.B2 - datetime and integer, or varchar?

Did you try...

There are situations, where uppercase helps a lot : on forums and in articles (I don't want to copy everything into QA to see it better); in client applications that don't...

Oh... that's different :-). Well, then what about to use your original query and modify it a bit:

UPDATE emp

SET Dup = Yes

FROM Employees emp

WHERE EmployeeID NOT IN

(SELECT TOP 4...

Hmm... I'm not sure I understood the question... are you asking how to mark all entries with duplicity, instead of leaving always one of them unmarked? If so, then try...

Interesting coincidence... this is already third question of the same type today. Please see my reply in this thread : http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=133911

You'll have to change the length of returned string to...

I vote for UDF, too... see my reply in another current thread :

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=133911

This question keeps popping up quite often... I learned this way to create concatenated texts in these forums,...

Depends on how you will use the result... if you need this summary of available colors in several queries, then the best solution could be a UDF:

CREATE FUNCTION dbo.f_get_item_colors (@item...

AJ,

shouldn't the SET command work with the alias as well (DD instead of DTS_MRP_DRAWING) ? Maybe that's the source of error, though I don't remember seeing such error message.

cheers, Vladan

Hello ebufanio,

there is a nice way to do this using UDF (user defined function):

/*create test environment*/

create table testing(tk_id int, tk_number int, tk_battery int)

insert into testing values (6500, null, null)

insert into...

Hello Colin,

as to the server hardware, it depends on the number of users, databases and their size, and activities performed on the server (read/write etc.). Generally and IMHO, it could...