Sanjeev Jha (4/9/2008)

---

Hello,

I am using Microsoft SQL Server Management Studio version 9.00.1399.00. I am trying to add a custom report to Management Studio. I created a .rdl file in BIMS....

By the way - sys.views returns all USER views, which sounds like what you want....

There's also...

Jeff Moden (4/9/2008)

---

Matt Miller (4/8/2008)

---

Crud... SQL Server is getting more like Oracle every day...

If you don't mind using a temp table - you can cut that to 15 seconds.

[font="Courier New"]--Set up Test scenario

DROP TABLE files

GO

CREATE TABLE files([file_name] VARCHAR(10), range_start VARCHAR(10), Range_end VARCHAR(10))

INSERT files([file_name],range_start)

SELECT...

GSquared (4/9/2008)

---

A derived column might be the way to go on that. If you look up Cast in books online, in the Integration Services section, it will give you...

Derek Dongray (4/9/2008)

---

GSquared (4/8/2008)

---

On the consistency point, I have enough problems with T-SQL having weird consistency issues already. My (least) favorite example is Replace vs Charindex. One has...

hmm..ugly. That's not going to work.

So - back to your original question. Keeping identities is important if you have them, so I'd keep that checked for those that...

Have you tried simply using your Access front-ends with linked SQL Server tables? Assuming you're not overly fancy in your Access app - you could use them "as is"...

Girish Bhat (4/9/2008)

---

Matt - Depending on the situation it may not be necessary to go through 10 months of log. Example: If it is a table in which data is...

marge0513 (4/9/2008)

---

Thanks! It's working!!

Being a newbie, I have to ask this dumb question........why do I need the Group By in order to just select the maximum dates...

Girish Bhat (4/9/2008)

---

One way to do this could be - assuming you have the transaction logs (or can recall the tapes/files), you might use a tool like Lumigent Log Explorer...

Ahh... I see it.

don't reuse the alias in the subquery:

[font="Courier New"]SELECT  T1.*, T2.*

FROM

        Table1 T1 INNER JOIN

        Table2 T2 ON

                T1.FILE_NAME = T2.FILE_NAME AND

                T1.Downloaded_Date = T2.Act_Date INNER JOIN

        (SELECT

                T1.FILE_NAME,

                MAX(T1.DownLoaded_Date) AS Max_Date

           FROM    Table1      T1  --<<look here

          ...

[font="Courier New"]SET...

WRACK (4/8/2008)

---

So let me get this right.

I create a function called Blah in the master database and rather than calling that function if it was in the same database like...

Does this mean you're all set, or are you...