There's nothing attached. But if it works when you run it under your account and not when it runs under a system account, there's likely a permissions issue causing the...

Maybe this will help:

https://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

What if you create a dataset of (Strategic Shift,1)(Day case,2), (Same day EC,3), (Elective,4), (Emergency,5), (Non-Elective,6) and then sort by that? (Maybe you need to create a calculated column in...

• This reply was modified 6 years, 2 months ago by pietlinden.

Besides being out of support? (or is that 2008?) Kind of depends on how you use/what you use SQL Server for. Some of the new features may be part of...

WHERE datediff (YY, birthdate , Getdate()) % 4 = 0 ?

A little normalization is a beautiful thing. Your problem is that your table fails the 1NF test, so you have to use DelimitedSplit8K to break up that delimited string into...

If you're adding one column to another, like [column A] + [column B], you can use

CASE WHEN [some column] = 0 THEN <true part> ELSE <false part> END

where the True...

Oh, okay. I'll try it out. Thanks, Phil!

Did you try using the old cardinality estimator?

Check out this article by Pinal Dave.

Drop a Tablix onto the report canvas, add the EmployeeID, group by it, and put a page break between instances. Then put the other report inside it as a subreport...

Seems like you should be able to join the (AdmitDate, DischargeDate) to a Calendar table to expand the date range to a set of dates, and then group by EHRClientFK....

Wow. I'm way to lazy to write all that.

Setup:

use tempdb;
go
Create Table Vendor (
  VendorId BIGINT IDENTITY(1,1) NOT NULL
  , VendorName varchar(256)
);
Create Table Visits (
  VisitID BIGINT IDENTITY(1,1) NOT NULL
  ,  VendorId...

What's the structure of tmpDeal01? And where does it get its data? There's not enough detail here to figure out the problem, I don't think. Got some sample data -...

Could you clarify what this means "I have written a query, but its not working as desired."? What is the output you got and what was the output you expected?

How...

Don't think you can use UNPIVOT then either. Not sure if this will work, because 2019 doesn't allow a compatibility level to 2005.  Maybe this works?

SELECT AccountID
 ,...