Viewing 15 posts - 16 through 30 (of 45 total)
August 9, 2006 at 11:51 am
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...
August 9, 2006 at 11:35 am
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...
August 9, 2006 at 8:25 am
The simpliest example of leading zero creation I know of is:
select
replicate('0',@MaxLen-len(cast(
August 9, 2006 at 8:09 am
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...
August 9, 2006 at 7:42 am
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.
August 9, 2006 at 7:32 am
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...
August 7, 2006 at 9:12 am
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...
August 3, 2006 at 8:18 am
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...
August 3, 2006 at 7:35 am
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...
July 17, 2006 at 10:22 am
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)...
July 5, 2006 at 7:40 am
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...
June 20, 2006 at 9:22 am
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.
June 5, 2006 at 8:36 am
I found that setting security and privilege levels for Reporting Services to be a difficult exercise unless you wear both the DBA and Network Administrator hats at your organization. Reporting...
May 31, 2006 at 8:35 am
Thanks to you both Yelana and SqlBill!
I used both of your suggestions to find the problem.
First...
May 24, 2006 at 1:11 pm
Viewing 15 posts - 16 through 30 (of 45 total)