Advanced Search

Return to Snippet

Revision: 29898
at August 7, 2010 07:20 by RealRover
Updated Code 
SELECT UserId, OrganizationId 
INTO #ORG_USERS
FROM View_Users 
WHERE OrganizationId = @OrgId

/* Code here */

DROP TABLE #ORG_USERS

Revision: 29897
at August 5, 2010 01:09 by RealRover
Initial Code 
INSERT INTO #ORG_USERS (UserId, OrganizationId)
SELECT UserId, OrganizationId 
FROM View_Users 
WHERE OrganizationId = @OrgId

/* Code here */

DROP TABLE #ORG_USERS
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Using temporary TABLE

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
table

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL