Topics
Started by
Posts
Last post
Hi, After I ran a query in SSMS, I can't find the execution plan in the cache.Is there any way I ca…
1 replies
Hi,To start I have minimal experience with OpenRowSet and BCP. I usually do processing with SSIS bu…
11 replies
I have 40 tables having different structure in one of DB on one server that is being updated by dat…
5 replies
I have a process that needs to occasionally copy a file to a local drive on the active node of an A…
2 replies
Hello all, I was recently assigned to convert an Access database to Sql Server. I have to try…
17 replies
SELECT LTRIM(RIGHT(CONVERT(varchar(6), [ie].[Invoice_Number],100),7)) AS [Invoice#] --, FORMAT([i…
26 replies
Hi Team,I have created one single trigger to capture information modified by the insert/update/dele…
2 replies
Hello All, Any input would be appreciated. I have some working code that derives group member…
6 replies
Before i added this, my code ran in under 1 minute. Now, it takes at least 6 minutes (I stopped que…
6 replies
UPDATE t SET response_sol_id = x.[solicitation_id] FROM #temp_stp t CROSS a…
6 replies
Hello forum, I am new to posting as I try to read a lot to address problems i have had in the past.…
2 replies
We have a table owned by User1. An after update trigger on that table is owned by User2. That trigg…
1 replies
Hi Experts, Can you all help me out to find a query in which i can find all the tables in a particu…
6 replies
I have a data table "T" with data that looks like this:Class ScheduledDa…
3 replies
UPDATE #TEMP_STPSet Signature_Date = Top 1 D.Close_DateFrom[SOLICIT].[GTM_DOC] D, #TEMP_STP, [SOLI…
6 replies
Viewing 15 topics - 1,036 through 1,050 (of 3,067 total)
You must be logged in to create new topics.