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...
is any want to help here?
Any one help me here...
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...
No... first trigger initiate on the table on same server e.g. ON INSERT and try to insert into the remote table but before insertion in Remote...
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...
Can we do it without using CROSS APPLY ...e.g simple T-SQ L.
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...
Here it is another version... declare @TeamID int,@DT datetime set @TeamID = 101 set @DT = '1/20/2011' declare @TBL table(AgentID int,DT...
any help...
Should be Like this... "AgentID","LoginDT","LogoutDT","LoginTimeSecond" 90020,01/20/11 10:00 AM,01/20/11 10:15 AM,900 90020,01/20/11 10:25...
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...
Yes... Frank I did... If you notice same thing is happening in my code... SELECT @nStartHour = StartTime FROM SkillGroupMaster WHERE SkillGroupID =...
yes seems to correct...I have tried with table but again end up with same issue as we are calculating reuqired datetime on the basis of IST...
OK here it is code that I am using ...I can't insert static value. getdate() will be initially value and we need to calculating from it. Calculation...
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...
We are using SQL Server 2005 and using no tools.... Generating script option do not give us option of no. of records limits in export or import.......
Is there any tool(s) or method to do this as export utility of SQL Server do not give data limitation UI to export or import...
Separate names with a comma.
