Viewing 15 posts - 1 through 15 (of 282 total)
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...
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...
October 3, 2024 at 5:52 pm
If you are connected to what was formerly known as an AS/400, when it was sold as an integrated system (for more than 10 years it has been sold as...
October 3, 2024 at 5:32 pm
Sorry, it's not clear to me what you want to achieve. You write very well, but somehow still fail to describe what you want in a way that I can...
October 3, 2024 at 4:25 pm
Viewing 15 posts - 1 through 15 (of 282 total)