Topics
Started by
Posts
Last post
Hi I am trying to write a SQL query that returns the number of working days between two dates. The…
5 replies
Data looks like below Status 1 is Active and 2 is Clean For one Student ID we may have one active, …
5 replies
Hello, I need to dynamically switch the db context to another db and need to create a procedure ins…
6 replies
Hi everyone I need to construct indexes for two tables. Table 1 - 30 Fields There are about 8 field…
19 replies
Hi everyone I am not sure why the query is taking so long to run. If I run each CTE separately the…
5 replies
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the first tim…
17 replies
I have a table of data that I need to create a .xml file from in a specific format. CREATE TABLE [d…
1 replies
We have an issue on Azure with inserting data into a physical table . We have done some benchmark t…
7 replies
Hello folks, Even writing the title, it sounds oxymoronic but bear with me. We have a third party v…
3 replies
I want to be able to recursively go through the contents of a temp table without using a loop and c…
8 replies
Hello All, Below is the my existing table structure from which I am trying to do an update statem…
7 replies
I want to be able to generate 1 merge statement rather than loop through a lookup table using a si…
2 replies
Hello everyone 0 I have a Contact table which has columns like ContactID, Nationalidnumber, Firstna…
7 replies
We have a stored procedure that can load up a JSON file and process this in 12 seconds However on A…
2 replies
I am tasked with writing a package to import a series of files. One of the files is 7.4gb and has 2…
10 replies
Viewing 15 topics - 496 through 510 (of 1,791 total)
You must be logged in to create new topics.