Viewing 15 posts - 91 through 105 (of 1,418 total)
I prefer migrations but have used in-place upgrades to buy time until there are the resources to look at a more managed upgrade. The trick is to have lots of...
December 20, 2023 at 10:28 am
I'll try to answer the questions all in one post here.
December 12, 2023 at 5:38 pm
@Ken - The 2 views are in the same schema, but the underlying tables are in 2 different schemas. That said, if I run "SELECT * FROM ViewA" and...
December 12, 2023 at 9:13 am
Personally I will only use DENY permissions when I really have no option.
Are all the tables and views in the same schema or at least in schemas with the same...
December 11, 2023 at 8:39 pm
Your link uses the Microsoft OLE DB Driver for SQL Server not the ODBC driver. Maybe you should try that.
December 7, 2023 at 9:55 pm
The result still shows 23 instead of 00023 or 123 instead of 00123.
Where is the result showing 23? SSMS or, as I suspect, Excel etc
December 5, 2023 at 7:03 pm
My first replay seemed to time out so I posted again.
December 5, 2023 at 4:17 pm
I need to know how to add headers please
If this is an Agent Job step then Powershell is a lot less hassle. Play with something like:
$SQLparams...
December 5, 2023 at 4:13 pm
update #leadtest set [gamedate] = (select Lead([gamedate], 1) OVER( ORDER BY [gamedate] ASC))
LEAD is a windowed function - what makes you think it is going to work in a...
December 5, 2023 at 11:35 am
It may also be worth speaking to you network team as something like Wireshark could tell you what is communicating with the server. Also, given the age of the server,...
November 30, 2023 at 9:47 pm
This post makes no sense. Why would you have an OrderId in a Customer table!?
Also there is no DDL, including the primary key, so the best that can be done...
November 24, 2023 at 8:52 am
I am not sure what question/problem is.
A few basic points to note:
1. Oracle effectively works as SET IMPLICIT_TRANSACTIONS ON so third party applications, which target multiple dbs, tend to work...
November 23, 2023 at 5:38 pm
WITH ChangeDates
AS
(
SELECT R.TeamId, R.PersonId, D.ChangeDate
,MAX(CASE WHEN R.RoleName = 'Manager' THEN X.StartEnd END) AS Manager
,MAX(CASE WHEN R.RoleName = 'Leader' THEN X.StartEnd END) AS Leader
,MAX(CASE...
November 20, 2023 at 11:32 am
Or dynamically:
/* Should be able to get this from a role table without DISTINCT
SELECT DISTINCT RoleName
INTO #Roles
FROM #AssignmentRange;
*/
SELECT RoleId, RoleName
INTO #Roles
FROM
(
...
November 18, 2023 at 11:14 am
WITH ChangeDates
AS
(
SELECT R.TeamId, R.PersonId, D.ChangeDate
,MAX(IIF(R.RoleName = 'Manager', X.StartEnd, 0)) AS Manager
...
November 17, 2023 at 10:16 pm
Viewing 15 posts - 91 through 105 (of 1,418 total)