Viewing 15 posts - 5,176 through 5,190 (of 8,731 total)
Sean Lange (2/25/2015)
February 25, 2015 at 10:14 am
If you have a Member_ID is your correct identifier for each person, then this should give you the correct information.
CREATE TABLE SampleData(
FIRST_NAME ...
February 25, 2015 at 9:53 am
I can't remember anything like this in T-SQL. It can be simulated with other instructions, but the real functionality would be using MDX. Unless someone else can think of something...
February 25, 2015 at 8:20 am
So you include the whole history each month? Or why do you have only "enddate < @d1"?
This is an example of filtering using 6 months.
SELECT *
FROM SomeTable st
JOIN (VALUES(0),(-1),(-2),(-3),(-4),(-5))...
February 24, 2015 at 7:46 pm
Without the information requested previously by Alan and me.
The only help I can give is this: The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]
Read...
February 24, 2015 at 6:26 pm
I wasn't sure about this, but it seems to work. It's resource intensive because there are lots of combinations. I don't have time to comment the code, but I strongly...
February 24, 2015 at 5:04 pm
That doesn't sounds like a need of recursive queries. It seems to me that a tally table could do the job or just a date range.
We need more details including...
February 24, 2015 at 4:11 pm
Eirikur Eiriksson (2/24/2015)
Steve Jones - SSC Editor (2/24/2015)
This was a 2003 questionIt popped up on "Recent Posts" two days ago, thought it was funny:-D
😎
Is to remind us how things have...
February 24, 2015 at 2:02 pm
I didn't want to post any code because this seems a lot like homework.
February 24, 2015 at 1:43 pm
What have you tried? Why would you have a row with a phone set as null instead of not having a row at all?
You could at least post DDL, sample...
February 24, 2015 at 12:02 pm
Sangeeth878787 (2/24/2015)
I am really thankful for your conversion script, can you suggest me, based on this function logic, I need to add extra columns in SSIS, could you ...
February 24, 2015 at 9:30 am
I can't reproduce your problem. Or maybe you're doing something different.
CREATE TABLE Test(
string_pct varchar(10))
INSERT INTO Test
VALUES
('100%'),
('50%'),
...
February 23, 2015 at 2:20 pm
Why do you have the division in the GROUP BY but not in your column list?
You need to either include it in both or remove it from both.
Could you post...
February 23, 2015 at 1:53 pm
Phil Parkin (2/23/2015)
Luis Cazares (2/23/2015)
Actually, if you're inserting into an integer column, you don't need the CAST() from this example as it will be...
February 23, 2015 at 12:34 pm
I'm not sure if someone explained it wrong or if you misunderstood what happens in SQL.
SQL (in this case T-SQL) is a declarative language, so you tell the engine what...
February 23, 2015 at 11:52 am
Viewing 15 posts - 5,176 through 5,190 (of 8,731 total)