--
You received this message because you are subscribed to the Google Groups "tSQLt" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tsqlt+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/c15ed010-c9b0-4ac5-b12b-533ef92af0a3n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/fb336415-457c-4dd5-b77e-9ee6f352d011n%40googlegroups.com.
--
G
Bryant McClellan
Senior
Solutions Architect
260.748.5393 (direct)
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/c4d418e1-bb5f-4171-b1b3-8bfa39b8336fn%40googlegroups.com.
G
Bryant McClellan
Senior
Solutions Architect
260.748.5393 (direct)
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/6c7996f8-4d78-48be-9fca-4fcfc8e4a7e0n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/6c7996f8-4d78-48be-9fca-4fcfc8e4a7e0n%40googlegroups.com.
G
Bryant McClellan
Senior
Solutions Architect
260.748.5393 (direct)
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/CAK0UGZPVjF2W9sAeU6%3D3j_oNFNTzYZwHyDSwcsuSK6GpEx-_LQ%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/6c7996f8-4d78-48be-9fca-4fcfc8e4a7e0n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/32983aec-e481-402f-9ee1-c57168cbf975n%40googlegroups.com.
That's one way to do it, and there are others. The view v_ivLpnDetail is immensely complex, and it would take hundreds of rows to generate what is represented in that simple, stripped down fake view.EXEC tSQLt.RemoveObject 'dbo.v_ivLpnDetail';EXEC ('CREATE TABLE dbo.v_ivLpnDetail (location location NULL,itemId id NULL,lotId id NULL)INSERT INTO dbo.v_ivLpnDetail(location,itemId,lotId)VALUES (''myDestinationLocation'', -- location - location2, -- itemId - id3 -- lotId),(''mySourceLocation'', -- location - location1, -- itemId - id1 -- lotId),(''mySourceLocation'', -- location - location2, -- itemId - id2 -- lotId)' );
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/32983aec-e481-402f-9ee1-c57168cbf975n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/e495c199-ff9f-4ffc-bb17-0829c85243e6n%40googlegroups.com.
G
Bryant McClellan
Senior
Solutions Architect
260.748.5393 (direct)
To view this discussion on the web visit https://groups.google.com/d/msgid/tsqlt/e495c199-ff9f-4ffc-bb17-0829c85243e6n%40googlegroups.com.