Topics
Started by
Posts
Last post
Hello, I created a SSIS package to transfer data from an XML file to a database in SQL Server inst…
12 replies
I have this calculation I have in a script: ROUND(T3.NUM_POINTS * 1.0 / T4.TOTAL_RECORDS * 100,2) A…
2 replies
So, long story short... A conversation about loops, cursors and in-line functions ended up with me …
17 replies
Hi, one of my peers prefers to maintain one specific sql agent job after rdp'ing into that server. …
9 replies
getting over it I have installed SQL Server Reporting Services 2019 on my Windows 10 machine, and I…
2 replies
I am not sure how to decide on how I should index my tables so the query is able to run as fast as …
8 replies
Hi, I am doing a crosstab but I am unsure if its a pivot or is there a simpler way of doing it. Cre…
5 replies
I am a SS rookie. To me it seems like running a query in parallel whenever possible is a great ide…
5 replies
This simple delete statement drives CPU to 100% for long periods of time when a user requests 1,000…
15 replies
I am in the process of doing a re-write for my project so I need to find all SP that use a particul…
1 replies
I was running a SP and I got this. This is the first time I have ever received this. What does it…
2 replies
We have a rebate program where I need to calculate sales based on the date the customer joined the …
7 replies
Hello, I've JSON file format as following, { "acc_div": [ { "level1_code" : 1104, "level2_code…
2 replies
Any idea on how to import a json file into sql server? I've never done one before. I saw some examp…
4 replies
Hi, we just moved to 2019 std from 2016 std. We comingle the engine, ssas and ssrs on one server.…
12 replies
Viewing 15 topics - 316 through 330 (of 1,822 total)
You must be logged in to create new topics.