Viewing 15 posts - 1,501 through 1,515 (of 9,641 total)
The best way to ensure that you don't get duplicates is to create a unique constraint or primary key on the column(s) that define uniqueness. You would then get...
July 17, 2012 at 6:20 am
L' Eomot Inversé (7/15/2012)
July 16, 2012 at 11:58 am
gerard-593414 (7/13/2012)
July 13, 2012 at 3:00 pm
I never actually had it finish. Went for an hour and was maxing my CPU. My query needs to keep it from joining to itself so if you add:
s1.start...
July 12, 2012 at 6:51 pm
You could also use the ANSI standard INFORMATION_SCHEMA.COLUMNS view. I have used that in an application that had to work with SQL Server, SYBASE, DB2.
July 12, 2012 at 9:35 am
If you found it soon enough the Default Trace will have logged the DROP DATABASE and it includes the user who did the drop. The issue is that after...
July 12, 2012 at 9:31 am
I would typically size tempdb to what I have determined through monitoring to be the max size needed so that it doesn't grow. Then you monitor free space to...
July 12, 2012 at 9:15 am
If you assign Domain Users group to the Browser role on the reporting services Home "folder" they will be able to see all reports & folders.
July 12, 2012 at 9:02 am
What do you mean by Dynamic Sprocs? Depending on how you are doing the dynamic execution the execution plan could still be re-used.
I would think that you could, if...
July 12, 2012 at 8:42 am
Dwain,
Essentially your query does a self-join just using a different syntax, so I'm not sure why you don't like Self-Join's. In a case like this you have to do...
July 12, 2012 at 8:26 am
Did you RDP to the Report Server and run the report directly there? Because I can't access the report server via RDP I get the error that I can't see...
July 12, 2012 at 6:52 am
Okay. The issue is somewhere in the data of the report and it only is an issue when using an older version of IE. Using IE 9 and Chrome...
July 11, 2012 at 2:11 pm
We really need to see the query to see what it does to have any idea. Without that information all we can do is throw guesses out there.
One guess...
July 11, 2012 at 1:19 pm
When you say you created a link, do you mean you created a link on a web page other than the report manager web page?
LI = List Item
UL = unorder...
July 11, 2012 at 1:15 pm
I'm not sure I understand your issue.
If the columns in the table are defined as DateTime/SmallDateTime then your variables should be defined using the same data type, not...
July 11, 2012 at 1:10 pm
Viewing 15 posts - 1,501 through 1,515 (of 9,641 total)