Viewing 15 posts - 4,006 through 4,020 (of 9,712 total)
It would be easier for us to answer that question if you posted the requested DDL and sample data. The sample data doesn't have to be real. You can fake...
September 10, 2012 at 9:08 am
Stewart "Arturius" Campbell (9/10/2012)
The issue relates to the
and dateadd(day, -30, getdate())section of the where clause.
And apparently I don't remember how to read this morning. DUH.
Good catch.
September 10, 2012 at 8:31 am
Post your table DLL, an INSERT statement with sample data, and what you've written on the CTE. That will help us help you better.
September 10, 2012 at 8:31 am
I think I have found my issue. Details in this post: http://www.sqlservercentral.com/Forums/Topic1356750-391-1.aspx?Update=1
September 10, 2012 at 8:24 am
Anyone can answer if they still wish to, but I think I found my issue.
Estimated Plan pointed out some index seeks. I googled locks and indexes and stumbled across the...
September 10, 2012 at 8:23 am
sstteevvee22 (9/10/2012)
SELECT dbo.RHeads.Branch, dbo.RLines.Part, dbo.Stock.Free AS [On Hand], dbo.RLines.CQty AS [Qty Last Received],
dbo.RHeads.DateTime AS Date,
...
September 10, 2012 at 8:07 am
Look up Common Table Expressions in Books Online. That's precisely what it was created for.
http://msdn.microsoft.com/en-us/library/ms190766(v=SQL.105).aspx
September 10, 2012 at 8:05 am
Check out this thread. I bet you have the same issue.
I found it by googling your error message.
September 10, 2012 at 8:02 am
aaron.reese (9/10/2012)
the view with UNION ALL the same query once for each agent table
Not something I recommend. The view will have to be recreated every time a new agents table...
September 10, 2012 at 7:23 am
DBayliss, if you can follow t.brown's advice, that would be the best solution to your issue. If you are constrained from making changes to the existing schema, here are a...
September 10, 2012 at 6:07 am
We've had the same issue due to permissions and we've had the same issue due to missing or out of date dll files on our server.
Was this package developed by...
September 10, 2012 at 5:56 am
Scott D. Jacobson (9/9/2012)
Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/%5B/url%5DThe Hacker News comments are interesting as well.
Yeah, the comment that led to...
September 10, 2012 at 5:16 am
jrichards54
Just a quick FYI: Next time you reply to someone's post and want to quote it, just hit the quote button instead of reply. It will use the forum code...
September 10, 2012 at 4:57 am
tua022012 (9/10/2012)
Same material can be found at: Production executive interview questions[/url]
I hope it's useful for you and you like it. Please continue...
September 10, 2012 at 4:27 am
jasona.work (9/7/2012)
Even if it is something that a seasoned DBA (not...
September 7, 2012 at 11:32 am
Viewing 15 posts - 4,006 through 4,020 (of 9,712 total)