Sounds like good data-driven design to me:P

Adam Haines (3/15/2008)

---

The above post was for everyone chiming in on the post that may not know about NULL calculations in SQL, not for you Jack.

Addtionally, this site has a...

Are you storing the sequence number, or is this for returning the data?

For querying the data you could use the row_number() function.

Select

ROW_NUMBER() Over (Partition By...

Here are a couple of options I think will work, but I can't guarantee anything without seeing the table schemas and some sample data.

/*this uses a CTE and is SQL2005...

One way you could do it something like this:

With DayOfWeek As

(

Select

DateName(DW, date) as DayOfWeek,

date

From

...

Adam,

I considered suggesting a default value as well, but, especially with numeric data, I prefer to leave null than to put in 0 as they really do mean different things...

Just for informational purposes what is the response of the query if you return rows where column4 is not null?

I am going to guess that the query optimizer is not...

I think you are misunderstanding how a linked server works. A linked server is designed to allow you to query another data source from within the context of an...

Option 3 is okay for what you want to do. The only issue, and this is true of any dynamic SQL, is that you need to beware of and...

I think the problem is that the application is trying to connect to a db named testserver.testdb on the local server and that db does not exist on that server....

IN does not play well with variables. When you use variable for your list Sql sees it as 1 value not the list you expect.

I agree with most who have said they will do what it takes to get the job done, legally. The worst thing I had to deal with was around...

Hugo Kornelis (3/14/2008)

---

And there are other folks who don't know that what you call Oracle syntax is actually ANSI-standard syntax, and that the optional FROM clause in SQL Server is...

Now you need to create a login on your server for your domain account and on the linked server with rights to whatever you are trying to access. Then...

In your example you are assuming that the PK field is incrementing by 1 and when you have data like in the example that cannot be guaranteed. The CTE...