I put a break point on both select statements; so when my bit was 1 it stopped on the first select and bypassed the 2nd. When my bit was...

I think you just got too many fields listed in group by ...

Try ...

[font="Courier New"]      SELECT cont.conid AS "ContainerID"

             ,itmMP.itmItemNumber AS "item"

             ,cont.conQuantity AS "Qty"

             ,itmdimMPCut.dimY AS "Length"

             ,itmdimMPCut.dimX AS "Width"

            ...

General recommendation I gotten from Microsoft is not to install anything that is not needed on server. That included SQL Server Management Studio. I think other then the...

Hey ..

People here on SSC are great in helping, but when posting such large SQL code blog. It makes it difficult for them to help you. ...

I don't got it working it just sends me success or failure email. I remeber asking a Microsoft Consultant same question once he said it was not possible.

So how...

Inner Join? The code you posted different from the code you are trying to debug? The code you posted works fine for me even with break points...

I personally get annoyed at having too many connections opened. Because SQL Server 2005 SSMS (I love it) creates a query window for server/database that you have clicked on....

In database mirroring when you are entering the server port information it is not for SQL Server it is for the end-point. So try "TCP://Mirror:5022" instead...

Thanks.

abhisek karki (3/9/2009)

---

I created a maintainence plan for a database of size 63 gig, data files and log files are in autogrowth, both are in e:\. E:\ drive still have...

Found this post on MSDN that might be of help...http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/79281b89-d305-44cc-9568-5dcff4620196/

Thanks.

Hey Paul,

When executing code are you clicking on the "Play" button; as that will start debugger. So even if you put break-point debug will not show up...

In access they must have their options turned on to show system objects.

If you go to Tools Menu -> Options -> General Tab..

There are checkboxes for "System Objects" and "Hidden...

Aye 😉 .. Just reminds me of my horror days from MS Access programming heh.

I have yet to have a developer try to build view on top of...

michael ham (3/9/2009)

---

Ok I found it. We added a few columns to the results and did a self join on a view 3 times to get the data. ...

You mean a data generator tool? Like it looks at the table and puts some text in the table? I recommend RedGate Data Generator, it really is one...