Hi All I need to search relevant product KB articles and articles could be in word doc, PDF or HTML format with images. I want to know best way to...
Hi All I need help on following SP code to tune up mainly where "CREATE TABLE #TblRawQueue" creating and DROPING in side While loop. DECLARE @rFlag...
Hi All We have situation where we need to insert data into Linked Server Table using For Insert Trigger on source table. On the same time we have...
Hi All I am trying to select only 20 records of each agent from a table. There could be any number of records for each agent in the table. These...
Hi All I need to calculate lgin hours of agents. The login and logout state code insert into table with date and time and agent info. I have tried...
Hi All I am calculating date range using getdate () for current date and time. And that is from 10:00 pm previous day to 10:00 pm of current day and...
Hi All I need help with following query as giving error "Incorrect syntax near '2010'." INSERT INTO DEL_SALE SELECT * FROM OPENQUERY(AV41,'SELECT...
I have following T-SQL that I have been tuned up and come up with 20 seconds from 2 minutes. Made couple of indexes and change joins and columns...
Hi All I have situation where only 10 records need to left in the production database for testing purpose. Data of 10 records should be relevant as...
Hi All I have following data and require result set but facing problem...as my query showing 28 rows... Table 1: DT FirstName LastName...
Hi All I need to add case condition in DateAdd and where clause as follows... Pls help me in this... Current One... Select...
Hi All In a table we need to update data value in a column. To encrypt the data of this column. We have a function that encrypt the data. SELECT...
Hi I need to know can I find the time of maximum queue time from a table data. This data group by half hour time period. HalfHourDateTime...
Separate names with a comma.