Viewing 15 posts - 24,016 through 24,030 (of 26,490 total)
Glad it worked. I'm not that familiar with SQL Server 2005 Compact Edition, so wasn't too sure what I could and couldn't do.
October 28, 2008 at 2:55 pm
Here is some code without a loop:
with SixValues (
num
) as (
select 1 union
select 2 union
select 3 union
select 4 union
select 5 union
select 6
)
select
datename(mm,dateadd(mm,datediff(mm,...
October 28, 2008 at 2:47 pm
rbarryyoung (10/28/2008)
Insert into ptApointment(...)
Select ...
From ptSchedule s
Where ScheduleID NOT IN(Select Cast(a.ID as int) from ptApointment a
...
October 28, 2008 at 2:03 pm
Mike (10/28/2008)
October 28, 2008 at 1:48 pm
Partially. We need the DDL for the table(s), create statements. Sample data for the tables, in the format of insert statements that can be cut, paste and executed...
October 28, 2008 at 1:42 pm
Try this code:
select
a.cuslink,
a.sequence,
a.effdate,
a.site
from
#list a
inner join (
...
October 28, 2008 at 1:36 pm
BigSam (10/28/2008)
October 28, 2008 at 1:12 pm
Here is the jist of what you need. First, you need to create a Tally table in the database. It is simply a table of numbers from 1...
October 28, 2008 at 1:04 pm
Agreed. Others may have the same question as you did.
October 28, 2008 at 12:45 pm
SQLServerLifer (10/28/2008)
Sorry about that, the " "got stripped.I meant
SET column1 = REPLACE( column1, 'Jasper Conran', 'JC' )
I'd go a little further:
update dbo.YourTable set
description = replace(description, 'Jasper...
October 28, 2008 at 12:37 pm
We had a similiar issue here on a couple of servers. You can rerun the install, but there is one more step in the install process for an upgrade...
October 28, 2008 at 12:33 pm
Please take a few minutes to read the following article.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Follow the guidlines provided in the article and provide use with more information so that we may better assist you in...
October 28, 2008 at 11:27 am
Here is a better question, what version of SQL Server 2000 are you upgrading, Standard or Enterprise? If you are upgrading from SQL Server 2000 Enterprise Edition, you need...
October 28, 2008 at 10:50 am
Comes down to personal preferences and coding styles. Neither way is right or wrong, just different.
😎
October 28, 2008 at 8:26 am
shane.barney (10/28/2008)
insert into #TempTable
select 1,1,'Bob Smith' union all
select 2,1,'Dow Jones' union all
select 3,2,'Roberta Smith' union all
select 4,1,'John Dow' union...
October 28, 2008 at 8:21 am
Viewing 15 posts - 24,016 through 24,030 (of 26,490 total)