That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-11
1,250 reads
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-11
1,250 reads
This one caught my eye on the Data Mining Forum and it is not the first time that this one...
2010-01-11
1,153 reads
The problem of the day: I stumbled on this problem on the Microsoft Reporting Services Forum website and thought it...
2010-01-08
3,155 reads
In my problem of the day, I found this one out on the Microsoft Reporting Services Forum. I bumped my head...
2010-01-07
23,999 reads
This one caught my eye on the Data Mining Forum and it is not the first time that this one...
2010-01-05
2,632 reads
As most of you, we in the financial world have often been faced with the challenge of extracting data from relational sources that within the business frame of reference are more hierarchical in nature. Recently, I did what most of us do from time to.
2009-09-17
2,271 reads
As most of you, we in the financial world have often been faced with the challenge of extracting data from...
2009-09-12
1,380 reads
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
hi , i know this is a sql server forum but i think my...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers