Viewing 15 posts - 1,501 through 1,515 (of 9,643 total)
But how do you know that it is really the same account? How is the customer number created?
I think what you really want is MERGE. IN a nutshell...
July 17, 2012 at 7:26 am
Based on the business rules you have provided, having a duplicate customer number IS an error and a unique constraint or a primary key are the only ways to guarantee...
July 17, 2012 at 6:45 am
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
Viewing 15 posts - 1,501 through 1,515 (of 9,643 total)