Viewing 15 posts - 24,526 through 24,540 (of 26,490 total)
How is this column Pkg_Per defined in the database?
😎
June 30, 2008 at 10:21 am
There looks to be a problem with this query:
UPDATE dbo.tblOpenDaily
SET Who = 'Result'
(SELECT TOP (100) PERCENT dbo.tblOpenDaily.[Entered Date]
FROM ...
June 30, 2008 at 9:43 am
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.
😎
June 30, 2008 at 9:34 am
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
...
June 30, 2008 at 9:24 am
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...
June 30, 2008 at 8:55 am
Peso (6/30/2008)
http://www.sqlteam.com/article/datediff-function-demystified
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...
June 30, 2008 at 8:16 am
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...
June 30, 2008 at 8:12 am
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...
June 27, 2008 at 2:12 pm
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...
June 27, 2008 at 9:58 am
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.
😎
June 27, 2008 at 9:28 am
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...
June 27, 2008 at 8:46 am
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
...
June 27, 2008 at 8:34 am
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/
😎
June 26, 2008 at 4:33 pm
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...
June 26, 2008 at 4:22 pm
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/
😎
June 26, 2008 at 4:19 pm
Viewing 15 posts - 24,526 through 24,540 (of 26,490 total)