Viewing 15 posts - 301 through 315 (of 1,231 total)
I cant imagine 70 databases/iterations would be a burden on a cursor.
I have not tested this but something looking like >
use master
go
November 3, 2017 at 1:44 am
Not sure that you need a dynamic sql statement in Ole db source adapter, via a variable. To use something like a date variable I can simply construct my query...
November 2, 2017 at 1:22 pm
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
Viewing 15 posts - 301 through 315 (of 1,231 total)