Viewing 15 posts - 3,511 through 3,525 (of 9,643 total)
Try starting with this article.
December 28, 2009 at 9:25 am
I think you want this:SELECT
a.Naam,
a.Voornaam,
a.Dienst,
c.auteur,
b.bestellingdatum,
b.bestellingid,
...
December 28, 2009 at 8:53 am
Cool. Merry Christmas.
I wish I could come to the event, but that ain't happening.
December 25, 2009 at 7:03 am
CirquedeSQLeil (12/23/2009)
10 am here - and not seeing a rousing response about work.Next question is: Who has mentally checked out for the holidays?
Yup. It actually started Monday afternoon,...
December 23, 2009 at 11:14 am
Grant Fritchey (12/23/2009)
Jack Corbett (12/23/2009)
Start by looking at sys.dm_exec_query_stats. You'll need to use sys.dm_exec_sql_text to see the query being executed. This information is since last server restart.
Sorry to...
December 23, 2009 at 11:12 am
I believe in SSRS 2005 anytime you change a selection in a report parameter the query is sent to the database. I could be wrong, but I don't know...
December 23, 2009 at 10:53 am
Is the server set for Mixed Authentication or Windows only?
December 23, 2009 at 10:42 am
You typically would use a query parameter and pass the value of the report parameter to the query parameter so the query only returns the needed rows.
December 23, 2009 at 9:06 am
Create a hidden report parameter that has a default value and use that to populate the query parameter.
December 23, 2009 at 9:04 am
Start by looking at sys.dm_exec_query_stats. You'll need to use sys.dm_exec_sql_text to see the query being executed. This information is since last server restart.
December 23, 2009 at 8:59 am
1. Database Mail IS supported on 64-bit. This article states that it is "fully-supported on 64-bit".
2. It depends on if you want to be able to identify...
December 23, 2009 at 8:46 am
If you are using the current version of the script you should be getting data from ALL the trace files. The T.path column will only return the path of...
December 22, 2009 at 5:50 pm
Bru Medishetty (12/22/2009)
GilaMonster (12/22/2009)
Bru Medishetty (12/22/2009)
December 22, 2009 at 2:14 pm
Alvin Ramard (12/22/2009)
I'm about to go offline for the next week or two, so it's time to wish y'all a very Merry Christmas and a Happy New Year.🙂
Merry...
December 22, 2009 at 1:47 pm
Thanks, but you have still left us with incomplete information as you only included the schema for one of the tables involved in the query. It would also be...
December 21, 2009 at 2:36 pm
Viewing 15 posts - 3,511 through 3,525 (of 9,643 total)