I think the case statement in the group by clause will probably fail you but otherwise I think that should works as:

SELECT StoreID, (CASE WHEN OrdersAmount > 10000 THEN 'Big...

I think you may be looking for a syntax similar to this:

UPDATE tb_comments

SET

user_id=tb_users_crm.id_user,

user_comment =id_tb_comments

FROM tb_users_crm

INNER JOIN tb_jobs ON tb_comments.job_id = tb_jobs.id_tb_jobs

INNER JOIN tb_school ON tb_jobs.school = tb_school.id_tb_school

INNER JOIN...

The simpliest example of leading zero creation I know of is:

select

replicate('0',@MaxLen-len(cast(

This is just a thought but since you're getting an MS ADO error that the concatenation operator '+' is invalid have you tried the standard MS concatenation operator '&' in...

There are numerous products out there for Sql Server Encryption that do column encryption. Google "Sql Server Encryption" and you'll find numerous products many that offer evaluation software.

I'm a little dumb-founded by the question but I'm sure you have your reasons for asking. The bottom line is that you need to...

I seem to read that you not only want the amounts but the dates these amounts were reached by each donor and I believe you're correct in the fact this...

The modulo mehtod i.e. where (RecID % 2)  is set to equal either 0 or 1 is the most efficient method I know of.  If you don't have an identity...

I see for some reason my previous reply didn't get posted.

In the past I've been careful to include a RecordsID field in these sort of tables. The Records ID is...

I'm also a little confused with the syntax  and much depends on your table setup. Assuming all the data is in one table then:

1)...

Hi,

I not really sure about what you're asking but it seems you're 'pro-rating' the number of hours being worked according to some attribute of the date, thus the problem appears...

T-Sql is notouriously bad at parsing text. Just the bare tools are given and nothing more.

That being said here an approach that can be used in line.