Topics
Started by
Posts
Last post
First, I want to apologise for the shear volume of JSON code posted here. I would like to convert t…
15 replies
Im sure I'm missing a simple trick here, but suffering post covid brain fog. Unsual situation, long…
2 replies
hi folks i am a bit stuck at extracting 2 characters before the last - eg below i Want to extract A…
3 replies
Hi everyone, I wasn't sure where to post this topic, so I'm just going to post it here. I'm using S…
1 replies
Hi I've been asked to do a data purge on a huge database. There is an existing script to do this bu…
3 replies
hello, i am stuck and need some help to generate output based on the below scenario if object_id(N…
1 replies
I have temp table created by application which starts from SST, SSW, DDL and this gets deleted afte…
3 replies
Hello Everyone, I have below query to delete record from ' ExamSet '. but based on the ' ExamSet ' …
3 replies
Hi to all. It has been a while since I posted. I am attempting to output a value and convert it to …
10 replies
I'm needing assistance completing the following code. This query needs to run the number of hours …
1 replies
DECLARE @json NVARCHAR(MAX) =N'{ "code": 200, "msg": "success", "data": [{ "ITEM": "SP", "FACTORY_…
4 replies
I am trying to create a table to use for testing. I have codded the script correctly based on many …
2 replies
Something I've always wondered is how is data loaded in a normalized OLTP database? One example tha…
8 replies
I have the following data: What I need is to group by the SessionId and have the DateTimes be colu…
3 replies
Hi all, I have a variable to declare, and this works: Declare @CopyFromUser Varchar(10) = (Select T…
5 replies
Viewing 15 topics - 451 through 465 (of 3,091 total)
You must be logged in to create new topics.