Viewing 15 posts - 196 through 210 (of 686 total)
any help in how I can do the date format change?
June 15, 2022 at 7:40 am
Current Offset: UTC/GMT -5 hours
June 14, 2022 at 1:11 am
i'm running my process local EST and want it converted to:
Current:
CEST — Central European Summer Time
UTC/GMT +2 hours
ON my server it's 21:06 I want that displayed as Tuesday, June 14,...
June 14, 2022 at 1:09 am
What I meant was after this file was generated I could alter the output to correct the issues. The initial creation of the file was some generated process from the...
June 2, 2022 at 10:32 am
I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by Jeff works...
May 31, 2022 at 6:11 pm
Thanks for responses... I think the problem is data related... When I run the following query I finding some of the records starting with
/* and
/*
Where it's failing is the 4th...
May 31, 2022 at 3:15 pm
I stated in early post I couldn't supply file but fill check table as you gave a good starting place... What about job_type in there twice?
Thx.
May 31, 2022 at 12:24 pm
Okay I have the file loaded using BCP. I created a format file and used BCP provided... all rows loaded
All data is now loaded to the table I used above. ...
May 31, 2022 at 12:12 am
I apologize Jeff, I really appreciate the time you take to help solve issues.
This is the code to load the file...
Many thanks, and hope you don't go dark on this...
Again...
May 29, 2022 at 12:25 pm
CREATE TABLE [dbo].[PSFileOrder](
[PSFOrder_Id] [int] IDENTITY(0,1) NOT NULL,
[PSFile] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_PSFileOrder] PRIMARY KEY CLUSTERED
(
[PSFOrder_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS...
May 28, 2022 at 12:40 am
When I run this section it groups the data as expected...
SELECT df.PSFOrder_Id
,DataGroup = COUNT(CASE
WHEN substring(df.PSFile,1,2) = '/*'
THEN 1
END) OVER (ORDER BY df.PSFOrder_Id)
,DataFromFile = df.PSFile
FROM dbastuff.dbo.PSFileOrder df
<><><> It seems to be...
May 27, 2022 at 6:38 pm
I just did a Bulk Insert, any way to try and debug?
Thx.
May 26, 2022 at 11:56 pm
I put the data in a Table now via bulk Insert, but the query now is failing...
Msg 537, Level 16, State 3, Line 5
Invalid length parameter passed to the LEFT...
May 25, 2022 at 6:09 pm
If I do the rules table approach how should I multiple comma delimited entries, or can I avoid that?
Thx.
May 18, 2022 at 11:27 am
Viewing 15 posts - 196 through 210 (of 686 total)