Viewing 15 posts - 10,051 through 10,065 (of 14,953 total)
Try full outer, instead of left, and you should be able to include an "is null" in the Where clause that will filter for unmatched rows, you just have to...
April 8, 2009 at 12:51 pm
Sounds like an interview question, actually.
Do you have the tables he's using? Do you understand the differences between inner, outer and cross joins?
April 8, 2009 at 12:40 pm
This should get you what you need. Just put in your column name where I have the string literal.
select reverse(cast(cast(reverse(substring('05380101010000', 8, 4)) as int) as varchar(4)))
Edit: And, of course,...
April 8, 2009 at 12:36 pm
I don't see where leading zeroes have anything to do with that.
April 8, 2009 at 12:33 pm
Can you cast/convert them into a numeric data type (int, for example)? That'll get rid of leading zeroes.
April 8, 2009 at 12:04 pm
Robert Frasca (4/8/2009)
GSquared (4/8/2009)
April 8, 2009 at 11:55 am
Update dbo.Table1
set EndDate = dateadd(minute, 30, dateadd(hour, 8, StartDate))
where EndDate is null;
April 8, 2009 at 11:28 am
I think you can use an underscore there. I had to solve the same problem once, and I think that was what did it.
April 8, 2009 at 11:14 am
insert into dbo.Table2 (EndDate)
select dateadd(minute, 30, dateadd(hour, 8, StartDate))
from dbo.Table1;
April 8, 2009 at 11:11 am
On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of temp tables, and that temp tables...
April 8, 2009 at 9:36 am
I'm not clear on where the Flag data is coming from. You say you want to create the data for tableB, but part of that is the Flag, and...
April 8, 2009 at 9:30 am
I've had a few problems with schedules that were changed after they were created, not working as planned. My solution was to create a new schedule, with the desired...
April 8, 2009 at 9:26 am
Is that in a table, or a recordset variable, or something else?
April 8, 2009 at 9:24 am
Have you tried using IsNull on the column? You might not be able to do that directly in the Pivot operator, but if you first use a CTE to...
April 8, 2009 at 9:23 am
The easiest way is to take your most recent full backup, copy that to the test server, and restore it there. That's assuming, of course, that your databases are...
April 8, 2009 at 9:12 am
Viewing 15 posts - 10,051 through 10,065 (of 14,953 total)