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.

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,...

rbarryyoung (10/28/2008)

---

Depends on what you mean by "quick":

Insert into ptApointment(...)

Select ...

From ptSchedule s

Where ScheduleID NOT IN(Select Cast(a.ID as int) from ptApointment a

...

Mike (10/28/2008)

---

I'm writing a query that is allowing the user from my web page to do a search with selecting parameters and a date parameter is one of them...

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...

Try this code:

select

a.cuslink,

a.sequence,

a.effdate,

a.site

from

#list a

inner join (

...

BigSam (10/28/2008)

---

We have used SQL Profiler with the Tuning template to create a number of files we've used as input to the DTA tool. We see recommendations to create some...

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...

Agreed. Others may have the same question as you did.

I'd go a little further:

update dbo.YourTable set

description = replace(description, 'Jasper...

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...

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...

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...

Comes down to personal preferences and coding styles. Neither way is right or wrong, just different.

😎

shane.barney (10/28/2008)

---

What I am referring to is the this part of the code:

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...