How is this column Pkg_Per defined in the database?

😎

There looks to be a problem with this query:

UPDATE dbo.tblOpenDaily

SET Who = 'Result'

(SELECT TOP (100) PERCENT dbo.tblOpenDaily.[Entered Date]

FROM ...

Have you tried attaching the existing model.mdf and model.ldf files since you say the exist in the data directory with the other system database files.

😎

Not exactly sure how SQL Server is interpreting your query, but you might want something more like this:

UPDATE dbo.tblA

SET Answer = 'Result'

FROM dbo.tblA INNER JOIN

...

I would also change your autogrowth to grow by a set size each time. Growing by 10% means each time it grows, it will grow by 10% of its...

Peter,

I just took the time to read your article above. I wish I had know about it as I was doing my article, I would have put a...

To all those who are noticing some issues with some of the code in the article. I will contact Steve about making some corrections. The code in the...

Okay, I saw a slight mistake in mine, which I noticed after looking at noeld's version. Mine and noeld are very similiar, his however will also work in SQL...

Since you posted this in a SQL Server 2005 forum, I am assuming you are using SQL Server 2005. Try this and see if it works for you.

with SumAcres...

I can't provide specific help, but you might want to look at SMO. My guess would be to start with BOL and go from there.

😎

Which is a good thing. I wish more people needing help would read that article and follow the procedures outlined. Jeff Moden did an great job with that...

Steve was right, all you need is a HAVING clause as shown below:

SELECT

fund_vintage,

count(fund_vintage) as NumFunds

FROM

#tmpRR_Testing

GROUP BY

...

I am going to need more to help you out. Please read this article, it will show you how to help up help you:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

A GROUP BY assumes you are aggregating some data in your select statement. That was the question I also asked in my previous post.

Now my question is, what are...

Read this article, it will help you with everything you need to allow us to help you:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎