Andrew Hancox (2/27/2008)

---

The problem that I think I've seen with the @ReorderPoint IS NULL OR ReorderPoint > @ReorderPoint is that you execute the sproc without the parameter, an execution plan...

wpp9786 (2/22/2008)

---

Pretty basic question ... I've been researching for hours. All the examples I have found seem to be exclusively for system tables whose columns are in syscolumns.

How can i...

shipleyv (2/18/2008)

---

Yes, the primary key is non-clustered. It sounds like if I 1) make this a clustered key, and 2) issue my select WITH UPDATE, that since I only pull...

shipleyv (2/18/2008)

---

Ran the select, and indid = 2 is for the primary key on the table (indid = 0 is for the table, and there is no indid = 1)....

shipleyv (2/18/2008)

---

Thanks, Karl, that makes sense. The only index on this table is on kg_table_id, a column which never gets updated. So how would I generate an exclusive lock on...

shipleyv (2/18/2008)

---

Thanks for your reply! That is pretty much how I see it, too. My question then becomes: how can both an X and a U be granted on the...

Sorry,

Made a mistake there, that's supposed to be:

set concat_null_yields_null OFF

SQLZ (2/15/2008)

---

Subba,

Try this. At the top of your stored procedure, just after the AS clause put in:

set concat_null_yields_null on

Also, for...

Subba,

Try this. At the top of your stored procedure, just after the AS clause put in:

set concat_null_yields_null on

Also, for your IF statement, try:

if @DefImpact <> ''

begin

set @whereClause =...

As you've deduced, SQL Server dates are stored in the same way, so the only way to control how it is presented is to change the format of the date,...

Actually the output is in "odbc canonical with milliseconds" rather than US format.

If you want the date in another format (for display purposes) then you can use the CONVERT function,...

I don't believe you can alter an existing column and make it an IDENTITY. You can add an identity column to an existing table.

You'll need seperate SQL Server Enterprise licenses for the database and the reporting services. Here's the statement from MS:

"... the computer running Reporting Services requires a SQL Server license....

I've taken the two procedure examples you supplied and the stored procedure with the cursor runs faster than your example using the table variable. I had to change the...

Thanks, much appreciated.

Michael Earl (1/30/2008)

---

I have just scheduled a job agent job that checks the LastStatus field in the Subscriptions table in the reporting services database. This is the status displayed...