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.

You gotta be quick around here, Between Noeld, and Remi, its hard to get a post in.

Certainly having develper change code will help.

But if the app passes in nvarchar(4000)

Evaluate it in the procedure prior to the update

Declare @p5 char(8)

set @p5 = left(@p4,8)

UPDATE yazdUser

SET name = @P1, 

     email = @P2, 

     username = @P3, 

     passwordHash = ''

WHERE userID = @P5