Viewing 15 posts - 4,876 through 4,890 (of 13,872 total)
November 27, 2017 at 8:49 am
myukas - Monday, November 27, 2017 8:09 AMIs there an easy way to do schema only exports in mssql
You could extract...
November 27, 2017 at 8:16 am
I want my numbers to be converted from a column which is of nvarchar(100)...
November 27, 2017 at 7:34 am
November 26, 2017 at 6:25 pm
I am a newcomer to the world of TSQL and was wondering if someone...
November 26, 2017 at 10:08 am
They look like lineage Ids to me. You should be able to track down the columns they belong to by opening the package in SSDT. Have a read
November 23, 2017 at 7:36 am
My preference would be to put the additional stuff into another database & live with the dependency.
I would, however, make sure that this was a one-way dependency...
November 21, 2017 at 1:37 pm
November 20, 2017 at 12:07 pm
Are you using a Fixed Width flat file destination in SSIS? You should be able to define all of your column widths there, without the need for any fancy REPLICATE...
November 20, 2017 at 10:51 am
November 20, 2017 at 9:38 am
This is possible and does not require any scripting, just a technique known as 'recordset shredding'. Take a read here, if you'd like to know more.
It assigns...
November 19, 2017 at 1:28 pm
November 17, 2017 at 11:48 am
November 17, 2017 at 10:47 am
Thom A - Friday, November 17, 2017 10:05 AMWrap the ISNULL around your SUM instead.
Or even add another:SELECT
'$'...
November 17, 2017 at 10:21 am
Viewing 15 posts - 4,876 through 4,890 (of 13,872 total)