Database

DECLARE @id int = 0
SET @id = (SELECT id FROM INSERTED  )

select a.id
      ,a.upload_date
      ,a.office_id
  from (  select max(m.upload_date) max_upload_date
                ,m.office_id office_id
            from master m
           group by m.office_id
       ) tmp
      ,master a
 where a.upload_date = tmp.max_upload_date
   and a.office_id = tmp.office_id
;

DECLARE @StringToSearch NVARCHAR(MAX)
SET @StringToSearch = 'ENTER_SP_TO_SEARCH'

SELECT    
    [name],   
    (   
        SELECT    
            OBJECT_DEFINITION(obj2.object_id) AS [text()]   
        from sys.all_objects obj2   
        where obj2.object_id = obj1.object_id   
        FOR XML PATH(''), TYPE   
    ) AS Obj_text,   
    [type] as ObjType    
FROM sys.all_objects obj1  
WHERE OBJECT_DEFINITION(object_id([name])) LIKE '%' + @StringToSearch + '%' 

SELECT AdShops.ID, Shops.url, Shops.image_url, 
       Shops.user_name AS shop_name, Shops.title, L.listing_id AS listing_id, 
       L.title AS listing_title, L.price as price,
       L.image_url AS listing_image_url, L.url AS listing_url
FROM   AdShops INNER JOIN
       Shops ON AdShops.user_id = Shops.user_id INNER JOIN
       Listings AS L ON Shops.user_id = L.user_id
WHERE  (Shops.is_vacation = 0 AND Shops.listing_count > 2 AND 
        L.listing_id IN
            (SELECT listing_id
             FROM    
                 (SELECT l2.user_id , l2.listing_id, RowNumber = ROW_NUMBER() 
                  OVER   (PARTITION BY l2.user_id ORDER BY NEWID())
                  FROM   Listings l2 INNER JOIN
                      (SELECT   user_id
                       FROM     Listings
                       GROUP BY user_id
                       HAVING   COUNT(*) >= 3
                      ) cnt ON cnt.user_id = l2.user_id  
                 ) l2 
             WHERE l2.RowNumber <= 3 and L2.user_id = L.user_id
            )
       )
ORDER BY Shops.shop_name

Roger Wright wrote:

How do you folks do this for a living? Hard drugs? Alcohol in vast quantities?

Roger Wright wrote:

All I wanted to do was load and display two or three columns from one table in the file, and print them so the accountant can enter the readings into the billing system.

Roger Wright wrote:

Server Explorer

Roger Wright wrote:

connecting to an Access DB with VS2008...

PIEBALDconsult wrote:

I use a UDL file.

Roger Wright wrote:

new toys

PIEBALDconsult wrote:

when I am trying to determine a connection string for some new database, I use a UDL file.