Use LIKE when comparing from the beginning of a string.

Otherwise, LIKE and PATINDEX will usually have the same execution plan.

P

Actually, LIKE 'something%' will perform better (only when you're looking from the beginning of the string - LIKE '%something%' will do a table scan).

This is because LIKE can use an...

The parm is to limit the cursor rows?

DECLARE mycursor CURSOR FOR

SELECT cols

FROM mytable

WHERE col1 = @myparm

OPEN mycursor.....

Yep. Choose All Objects and Data, and you're on your way.

P

See CREATE FUNCTION in BOL...a table-valued function can only accept a constant or a variable in it's arguments.

No worries.

Thanks for clearing that up, Steve.

P

Well, for sure you're going to have to use the with MOVE, since the folders on developer's stations have different structure than prod boxes.

What I've done is write a sproc...

Can't SELECT...INTO a table var either.

See CREATE FUNCTION in BOL.

It states that dynamic SQL is not allowed in functions.

Instead of having new tables everyday (tablename_businessdate), why not have permanent tables with a businessdate column. Then,...

Contrary to a statement above, you can declare a PK or Unique constraint - which creates an index - on a table variable.

Table vars can be as good or slower...

Jam,

Yes, it does exist. You can find code examples on the net quite easily. The MS website has some code too.

See DTS Package2 Hierarchy in Books Online.

P

Did you say you have a deal_id column in each of product and asset tables? Can 1 product have more than one deal_id? Can 1 asset have more than 1...

Hi Steve,

Thanks for the reply.

So in my case, @ObjectHandle = reference to the jobs collection object? I've tried that, and I kept getting and error.

Here's the rest of the...

Thanks for the reply.

I know I can use sp_add_job, except I have to run that on the SQL Server I want the job added to first. Using DMO, I can...