We have an HR search using dynamic sql in a sproc.
The sproc uses a view to pull back all possible search criteria that might be need by user searching HR information.
Pulls back all Employee information fine.
On the other side we have the same dynamic sql in a sproc doing same sort of search from Intranet DB.
The sproc uses a table that is refreshed with data about meeting room locations and if they are available and contractors names and details.
if this information was stored in the new HR system we wouldnt need this cross search.
We are trying to work out the best way to do this .
Suggestions please on following:
Run a sproc that runs HR search and inserts into a temp table all results
This sproc also runs similar Intranet search and stores the ROOM and CONTRACTOR details in same temp table.
We then distinct this temp table as part of sproc
Then a Search sproc called StaffSearch - points to this temp table and using dynamic sql shows whats searched on to user.
Be it HR type details like employee information or Room/Contractor information.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.