Viewing 15 posts - 4,036 through 4,050 (of 4,075 total)
I don't think it's necessary to use both a CTE and a derived table here. The following is untested, but should work.
WITH SQLPaging AS (
SELECT...
August 3, 2009 at 2:54 pm
How about an EXCEPT?
SELECT t1.col1
FROM T1
EXCEPT
SELECT t2.FkCol
FROM T2
Drew
August 3, 2009 at 1:22 pm
There are two variants of the CASE statement
CASE <Expression>
WHEN <Value Expression> THEN <Result Expression>
or you can use
CASE
WHEN <Boolean Expression> THEN <Result Expression>
You...
August 3, 2009 at 9:21 am
lduvall (8/3/2009)
August 3, 2009 at 9:11 am
ta.bu.shi.da.yu (8/3/2009)
August 3, 2009 at 8:45 am
Jeff Moden (8/2/2009)
Does SSRS have something in it to take an SQL DateTime and format it for display without disturbing the sortability of the underlying SQL DateTime?
If all else...
August 2, 2009 at 9:44 pm
Tejas Shah (8/1/2009)
Its better to use DATEADD(dd,0, DATEDIFF(dd,0,GETDATE())) instead of the conversion.
If the datepart you're using is Days, then the order does not matter, but if you are using any...
August 1, 2009 at 2:51 pm
itzfake (7/31/2009)
Script Task 1 -> Script Task 2 -> Email Script Task
If Task 1 and...
July 31, 2009 at 6:09 pm
A pivot table in what software? Excel?
You need to code the margin as a calculated member in your pivot table software, not in SQL.
Drew
July 31, 2009 at 4:36 pm
I realized what I was missing when I first approached this problem. You have to get a result for every single combination of account ID and required header. ...
July 31, 2009 at 12:46 am
First, why does your #header table have a duplicate ID? The purpose of an ID field is to uniquely identify a particular record. Your headerID with a value...
July 30, 2009 at 10:24 pm
This approach should work, but it is UNTESTED. It divides the clients evenly, but, and this is a big but, it does not retain the order.
1) Create a...
July 30, 2009 at 11:35 am
I'm not sure how your margin is calculated, but it sounds like you have an issue with a semi-additive or non-additive aggregation. For instance, if you have a formula...
July 30, 2009 at 10:59 am
It's not necessarily pretty, but this will work. Convert the datetime to a string in Canonical ODBC format (20 or 120), but truncate the string at the first digit...
July 30, 2009 at 10:42 am
First off, I would recommend to anyone posting sample data that includes dates to put the dates in 'yyyy-mm-dd' format. That format is unambiguous whereas the formats 'dd/mm/yyyy' and...
July 30, 2009 at 10:29 am
Viewing 15 posts - 4,036 through 4,050 (of 4,075 total)