Viewing 15 posts - 24,031 through 24,045 (of 26,490 total)
You might try searching this site for this to be sure, as I know I have read it somewhere, might even have been a Question of the Day.
You need to...
October 27, 2008 at 10:17 pm
Just use that as the working title. :w00t:
Steve could always retitle it prior to publishing.
😎
October 27, 2008 at 9:45 pm
Not a problem, I just thought I might have missed something somewhere. So, should this be written up as counter-point article to the one that started this?
😎
October 27, 2008 at 9:32 pm
True, but when you script the create statement or edit the table in the designer in SSMS, the columns are listed in the order you defined them in the initial...
October 27, 2008 at 7:53 pm
Jeffrey Williams (10/27/2008)
Lynn Pettis (10/27/2008)
October 27, 2008 at 7:00 pm
Where is there a triangular join in this query? I am joining row i to row i + 1 using an outer join, then this derived table is then...
October 27, 2008 at 6:56 pm
Here is some code to start with:
create table #TempTable (
PersonalID int,
fk_IntakeMainID int,
FullName varchar(64)
);
insert into #TempTable
select 1,1,'Bob Smith' union...
October 27, 2008 at 3:24 pm
You may have to adjust the code I posted above to subtract 12 instead of 13. Give that code a test in a test environment. better yet, change...
October 27, 2008 at 2:51 pm
Here is the code I'd try:
delete from table
where
asofdate < dateadd(mm, -13, dateadd(mm, datediff(mm, 0, getdate()), 0))
😎
October 27, 2008 at 2:42 pm
When you are talking about keeping a rolling 13 months worth of data, are you talking about current month plus the last 12 previous months? For example, if you...
October 27, 2008 at 2:35 pm
Here is some test code I just wrote. See if this helps you figure out what you need to do.
create table #TestTable (
OrderNo varchar(13)
);
insert into...
October 27, 2008 at 2:32 pm
Jeff Moden (10/27/2008)
October 27, 2008 at 1:33 pm
Let's start with the individuals who started the site and what they wanted to deliver. Then let's look at the people that have come to the site. I...
October 27, 2008 at 1:10 pm
Since you were jumping from SQL Server 6.5 to SQL Server 2000, it is possible that some of the system tables from 6.5 were depreciated and then dropped from SQL...
October 27, 2008 at 12:39 pm
Shree (10/27/2008)
Select * From table
Where Case
When @NoSales = ‘No’ Then (...
October 27, 2008 at 10:41 am
Viewing 15 posts - 24,031 through 24,045 (of 26,490 total)