Matt Miller (4/8/2008)

Oh don't feel bad. You're right that I shouldn't have used the "Regex syntax" term, since it only supports ranges and range exclusions and not all of...

In the subquery put TABLE.File_Name instead of File_Name as File_Name is a function.

Antares' questions are also valid.

Well, count this as one of the times I made a fool of myself. I actually looked up PatIndex in BOL expecting it to give an example using the...

This should give you what you want:

Select

Table1.*,

Table2.*

From

Table1 T1 INNER JOIN

Table2 T2 On

T1.File_Name = T2.File_Name And

T1.Downloaded_Date = T2.Act_Date INNER JOIN

(Select

File_Name,

Max(DownLoaded_Date) as Max_Date

From

Table1

Group By

File_Name) as T3 On

T1.File_Name =...

PATINDEX does not use Regular Expression Syntax so your second example is matching on 'A', '-', 'Z' and so the only matches found are 'A' and 'Z'

Are you sure you need a cursor? If you do post the code you may find that the cursor is unnecessary.

What are the settings for the web site in IIS? Has the server been rebooted and Reporting Services not restarted?

K. Brian Kelley (4/7/2008)

---

Piggy-backing on what was already said...

Create a database role and grant it the rights to execute the stored procedures. Make the user a member of that role....

I believe that it is in machine.config, but I actually am not sure and I do not have access to a web server at this moment.

I don't think the autogrow setting will affect you until it needs to grow. Most experts do not think you should set it autogrow. You definitely should not...

You can just used a varchar or nvarchar field to store the path. Then your GUI will use that as its path into the file system.

Can you post your connection string (minus any private data)?

You need to go to the Sql Server Configuration Manager-> Sql Server Netowork Configuration -> Protocols and set the SQL Server to allow remote connections via at least TCP/IP. ...

The other consideration for this is any calculations/aggregates you may use against this column. 0 is much different than Null. Check out this article before making this change,...

All you need is to grant execute procedures on the stored procedure as long as the stored procedure and tables are all owned by the same owner. For example...