Viewing 15 posts - 301 through 315 (of 1,229 total)
Try
CREATE TABLE #CuriousCaseOfSum(val DECIMAL(18,1) NOT NULL)
INSERT INTO #CuriousCaseOfSum(val)
VALUES (1),(2),(3)
DECLARE @var DECIMAL(12,0)=12.6
SELECT @var, Sum(val) , @var+SUM(val)
FROM #CuriousCaseOfSum
DROP TABLE...
August 24, 2017 at 10:28 am
The data element named “date_key” is absurd; a date is a unit of temporal measurement in a key is how a data element is used in a particular...
June 28, 2017 at 1:06 am
col1 int NULL
,col2 int NOT NULL IDENTITY (1,1)
,col3 AS COALESCE (col1, col2) PERSISTED NOT NULL
Take a good look at your...
June 26, 2017 at 2:46 pm
Looks to be a double post >
https://www.sqlservercentral.com/Forums/1882132/Expression-needed-for-Midnight-of-previous-day?PageIndex=1
June 26, 2017 at 2:37 pm
What is the actual max length of the values in that column? For instance varchar(20) give me up to 20 but I may only get at most 5 characters in...
June 26, 2017 at 2:28 pm
At a very high level, keep in mind that:
facts are numbers,
dimensions are words (to describe the numbers).
As for loading , that can depend on your business...
March 31, 2017 at 2:27 pm
Just a quick reminded that you do have the ability to redirect those error rows to a predetermined location , like an errors table and not hold up the rest...
February 27, 2017 at 2:44 pm
It is always good to have some sample data for better clarity.
Maybe this will help wrap your head around problem. It is a simple illustration that you can...
February 27, 2017 at 2:16 pm
Agreed. Not sure how it turned out for the OP but this is one where I would push back or at least wipe my hands clean of the bug being...
January 17, 2017 at 2:04 pm
What is the exact data type of that one field that stores the email message body? Does your new private database support the XML type?
January 13, 2017 at 5:47 pm
I would think that you already have a copy of these tables from the most recent backup. What is the "private" database that you want to migrate only some tables...
January 13, 2017 at 5:20 pm
Maybe coordinate with your team to determine who can have access to the file and when. That is what file and folders permission are also built for 🙂 . As...
January 13, 2017 at 1:38 pm
Are you using quotes around the values in the export? How lengthy is the field(s) that is causing the issue? How are you creating the files?
If migrating a database...
January 13, 2017 at 1:25 pm
So is this a SQL Server log or a RedGate log? I guess that is what you are wondering. I dont use RedGate personally but you mention source control, the...
January 13, 2017 at 1:19 pm
If your RRN schema was instead DBO, then the schema "dbo" would be the owner of all the objects involved. As it stands the DBO owner cannot access those what are...
January 13, 2017 at 1:12 pm
Viewing 15 posts - 301 through 315 (of 1,229 total)