If you have any empty strings you need to ensure they are not chosen as the shortest description.

SELECT  TeamCode, Description,
      ...

Sorry, I should have mentioned that sp_whoisactive is not a system stored procedure. It's something you can download and install, created by Adam Mechanic. It has not been updated for...

Have you looked at what's going on in SQL server when the procedures get stuck? If you use something like sp_whoisactive it's easy to see if you have spids that...

Do you have one or two tables? are "data" and "table" the same table? Do you want all the data for dates where there are more than 600 measures? if...

Grasping at straws here, but is there any chance you have an expression overwriting the server name? It appears from the image that your connections do have expressions, but they...

Can you not leave the server name alone, but change the connection manager name to remove the square brackets and the backslash, which is an illegal character?

The delete removes rows for id 102 that share Ident and val with 101. Should the 101, euid01, x010 row be updated in some way?

One solution might be to use a an explicit cache transformation for the lookup. The cache has to be loaded using a data flow first, but that allows the source...

I always have to look up the pivot syntax so I usually use case statements, but this is an attempt at both.

--PIVOT
SELECT  b.MemberID, b.[1] AS EntryDate1,...

Is this an accurate description? you want to update all rows where ID = 102 (set id = 101, Isactive = 0, closedate = getdate()) unless the combination of ident...

I haven't used maintenance plans for years, but this link suggests that you need to explicitly define the log files to delete.

https://www.mssqltips.com/sqlservertip/3225/sql-server-maintenance-plans-reporting-and-logging/

I think that Oracle displays dates in a UK format with days before months, at least that's how it seems when extracting dates without formatting. We always use to_char with...

What do you want to achieve by partitioning the table?  Monthly partitions help manage large tables and would allow you to truncate a historical partition at the end of a...

That code is now running without error, but the problem is the code is taking out ALL results where company = 'abc01' and eliminating  all custids like '%abc%' from...

Did the <> symbol get mangled? It shows as "&lt;&g" here

and t2.custid not like '%abc%' and t1.Company <> 'abc01'

• This reply was modified 1 month ago by  Ed B. Reason: edit