oh yeah, table function returned a number column of ints, and was join on the int primary key. Was quite painfull.

Remi,

I used this before, and it seemed slick and all, but I was using the function joining to a partitioned view, and it was causing funk table scans. I...

You want to do a comma separated list of zip codes to the procedure.

You can do a couple of things, You can pass the records as a well formed xml...

You should never have a scheduled sql agent job run under your security credentials.

One issue is when your password changes sql agent will remember your old password causing you...

in Tsql you can use the select into method jsut for testing messing round type stuff.

select *

Into Authors_Copy

from Authors

Other wise I recommend you create the table definition first

Create table MyTable...

Depends,

How is the query being executed? IN an application? Thru query analyzer?

are the queries the same, or different, I mean are all the joins, Where clause items the same?

Have you...

Sql Compare will clearly show differences, But I can't remember if it produces anything you could use to programatically create a script so you can update the different database. But...

Well I guess I'm not sure whats not working,

Is EntryDT a datetime in the table?

Returns top 16 records where entryDT is newer or equal to @x.

Looks Ok to me.

Dynamically ordering rows in a recordset.

no temp table.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133

I usually try to get the UI Guys to do it in the presentation layer.

but don't always win that battle.

Too many tics' and you;ll want to declare @x as smalldatetime

declare @x SmallDatetime

set @x= '03/11/2003'

Which will evaluate to 03/11/2003 00:00:000

select * from task where task.entrydt >=...

More than 1 way to skin a cat.

Select table1.*

from Table1

left join Table2 on table1.colid = table2.colid

where table2.colid is NULL

Performance was not a requirement.

ahh, okay, I guess I'm just fortunate having not worked on such an application.

Column Descriptions shown in enterprise manager are extended properties.

they are handled separately, There is no way to put the description in using the Create table syntax. At least not that...

It is possible, and does not warn.

use pubs

Select *

into Authors2

from authors

Create view AuthorBooks

as

select au_lname,  au_fname, b.title_id, title, type

from authors2 a

join titleAuthor b on a.au_id = b.au_id

join titles c on c.title_id...

Nice Remi.

Don't know what in the world a user would need with displaying every 3 row in a dataset?

But nice solution to it.