Viewing 15 posts - 196 through 210 (of 290 total)
is there any way to save the execution plan in the background (not on SSMS GUI) while the query is running, and then open the plan for review at a...
November 13, 2018 at 11:30 am
I finally got it working THIS WAY:
public void Main()
{
string fileText;
try
{
fileText = System.IO.File.ReadAllText(Dts.Variables["FullFilePath"].Value.ToString());
fileText = fileText.Replace("WTOTA", "TOTAL");
System.IO.File.WriteAllText(Dts.Variables["FullFilePath"].Value.ToString(), fileText);
...
November 12, 2018 at 2:59 pm
I have tried this way as well but code does not compile...
See the attached too, same.
Public Sub Main()
'
Dim reader...
November 12, 2018 at 2:16 pm
November 12, 2018 at 10:32 am
--DECLARE @myDecimal as decimal(4,1) = 4.5November 12, 2018 at 9:36 am
The best I have done so far is adding leading zeros to entrynumber column (INT) (a different input format than in my post/quesiton).
update MobilityRates Set entrynumber = Replicate (...
November 12, 2018 at 9:11 am
November 12, 2018 at 8:20 am
its only because this way it ieasier to output all text fields to text file via SSIS.
November 11, 2018 at 6:16 pm
November 11, 2018 at 6:15 pm
yes you are right, they should be.
November 11, 2018 at 4:38 pm
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MobilityRates](
[Area] [varchar](5) NULL,
[type] [varchar](5) NULL,
[School] [char](4) NOT NULL,
[TestType] [char](6) NULL,
[Grade] [char](2) NOT NULL,
[Sex] [char](1)...
November 11, 2018 at 3:12 pm
November 11, 2018 at 2:52 pm
Sure. Attached is both DDL and DML.
I started doing it via a cursor but it really is not a right way.
November 11, 2018 at 12:43 pm
Viewing 15 posts - 196 through 210 (of 290 total)