Viewing 15 posts - 1 through 15 (of 26 total)
declare @text varchar(100) = 'Southeri,Brettuen'
select @text, Replace(@text, ',' ,', ')
April 20, 2022 at 2:58 am
You are welcome. I learned something, too, from Mark C’s solution
February 28, 2022 at 6:41 pm
Here is what I would do. There may be a different way--without having to "hardcode" every path--but I don't know of one.
DECLARE @doc XML
SET @doc =' ...
February 25, 2022 at 11:05 am
I'm not sure how much control you have over the xml, I reformatted it a bit and here is how I would do it:
declare @x xml =...
February 25, 2022 at 2:10 am
Cool, glad I could help. I’ve certainly received quite a bit of help from this forum.
🤙🏼
February 23, 2022 at 2:42 pm
perhaps this will help...
DROP TABLE if exists #batch
create table #batch (batchID int IDENTITY(1,1),
...
February 22, 2022 at 11:25 pm
Try this:
drop table if exists #testAddress
CREATE TABLE #testAddress(
[ID] [int] NULL,
[houseNum] [int] NULL,
[streetNm] [varchar](50) NULL,
[StreetType] [varchar](5) NULL,
[aptno] [varchar](10) NULL,
[fullstreet] [varchar](100) NULL
)
INSERT #testAddress ([ID], [houseNum], [streetNm], [StreetType],...
February 12, 2022 at 7:43 pm
Thanks for the interesting problem... Perhaps consider something like this:
SELECT ID, b.[value] bVal , .ordinal bOrd, CASE WHEN CHARINDEX ( ',', fullStreet ) = 0 THEN ''
ELSE...
February 12, 2022 at 8:52 am
That's a much better suggestion, Phil. Thank you.
December 1, 2021 at 1:35 am
How about a not in query?
SELECT 1 as id, 100 as subID, 'John' as [name], '123 main' as [address], 1 as status into #t
UNION SELECT 2,100,'John', 'PO box 100', 2
UNION SELECT 3,100,'John', 'fake', 2
UNION SELECT 4,200,'Mary','890 Hills',2
UNION SELECT 5,200,'Mary','890 Hills',2
UNION SELECT 6,300,'Jen','Po Box', 3
SELECT * FROM #t t
WHERE subID NOT IN (SELECT subID from #t where status = 1)
November 30, 2021 at 9:16 pm
That's awesome info. Thank you so much for taking the time to look into that!
September 25, 2021 at 6:38 pm
Select CAST((CONVERT(DATETIMEOFFSET, GETDATE()) AT TIME ZONE 'EASTERN Standard TIME') AS DATETIME)
August 17, 2021 at 1:30 am
That did it! THank you so much!!!
April 7, 2021 at 8:44 pm
Thank you for your help. I've edited my post to be easier to read and included the ddl and links to the "Paste the plan" execution plans
April 7, 2021 at 6:37 pm
Update on this--it is an intermittent issue. Sometimes a trace started using the service account captures all the data, sometimes not.
October 3, 2018 at 2:15 pm
Viewing 15 posts - 1 through 15 (of 26 total)