Viewing 15 posts - 16 through 30 (of 300 total)
Apologies I seem to have miss read the text way it was being converted.
As you have the job hex in varchar from the substring, converting that to the GUID and...
November 19, 2024 at 5:12 pm
There isn't really a need to use that scalar function for the conversion.
This will also work:
SELECT t.SPID, t.Status, t.ProgramName, j.name AS JobName
FROM @Table t
LEFT OUTER JOIN msdb.dbo.sysjobs...
November 19, 2024 at 4:29 pm
Arrgh! At least in my browser the output from my post above isn't rendered correctly, even though I have used the Plain type format and it shows correctly when I...
November 18, 2024 at 7:31 pm
If you don't want to do a group by pivot, but simply want to place the price in a separate column, something simple like this might work for you:
November 18, 2024 at 7:21 pm
Thanks for the critical feedback! I appreciate your point, but the intent of my script wasn't to compare performance between the two methods. It was focused on providing...
November 11, 2024 at 11:13 am
Maybe something like this?
declare @Teams table (
TeamCode varchar(10),
Description varchar(30)
)
INSERT INTO @Teams (TeamCode, Description)
...
November 7, 2024 at 7:02 pm
Wow that seems very fast...
I'm not sure why some of this code exists and its logic wasn't up front when developed
Much appreciated for your reply.
Thanks, but... on second thought...
November 7, 2024 at 6:20 pm
... also, why do you group by d.attValue when you have a MAX() on that column in the SELECT?
November 7, 2024 at 5:56 pm
I find it curious that you use so many self-joins only to do some sums. I would probably move the additional criteria from the WHERE section to CASE statements in...
November 7, 2024 at 5:40 pm
Might be a driver issue. Are you using an OLEDB driver or something else? 32 bit or 64 bit?
November 7, 2024 at 4:58 pm
Michael J. Swart has a nice write-up about different kinds of upserts (and what's good and what's not):
https://michaeljswart.com/2017/07/sql-server-upsert-patterns-and-antipatterns/
November 6, 2024 at 10:14 am
Not sureI understand your question correctly.
You get the database connect error when you try to call a report through Report Manager?
The first thing that comes to my mind is that...
October 10, 2024 at 1:05 pm
A different T-SQL function to check for valid email format is shown here:
https://www.mssqltips.com/sqlservertip/6519/valid-email-address-check-with-tsql/
I have also found that a simple select filter like
WHERE EmailAddress LIKE '%_@_%_.__%';
while not perfect, will go a...
October 10, 2024 at 11:21 am
This old web page shows how to set up a linked server to an IBM i system (the page makes references to SQL Server 2000 and SQL Server 2003 which...
October 3, 2024 at 6:11 pm
Looking at the page you linked to, it looks like the driver is probably optimized for accessing a DB2 database for the Windows/Linux/Unix platforms (https://www.ibm.com/docs/en/db2/10.5?topic=overviews-db2-database-linux-unix-windows).
The driver can be used for...
October 3, 2024 at 5:52 pm
Viewing 15 posts - 16 through 30 (of 300 total)