Topics
Started by
Posts
Last post
So we have a SQL Server database running in a Docker Container on Linux There is a stored procedure…
8 replies
This is something I've never seen before and I can't think of the right way to search properly for …
17 replies
All, I am attempting to perform a table migration for one table (tableA) from my source database (d…
8 replies
Hi I have payroll detail table in which I have payroll details id and an employee id (foreign key f…
18 replies
Hi there I am trying to extract values from a JSON array object but struggling so my code is as fol…
21 replies
Hello I need help on how to do this more efficient. I will need to write a store procedure to valid…
1 replies
Below is a code i wanted to improve some readability and functionality: GO /****** Object: View […
7 replies
cast(DATEADD(DAY, case when j1 is null then 0 else j1 end, j_date) as date) as 'DateEnd', I get res…
6 replies
Hello, how can I change this code to txt pipe format? $DataSet.Tables[0] | Export-csv -Path "C:\Tes…
2 replies
I found this older script by Greg Ryan in 2013 to script out all the logins, permissions, roles. h…
3 replies
Hello everyone, I am rather new to SQL-Server and got a problem to which I cannot find a solution. …
14 replies
How do I add 0 in the beginning but the length of the value cannot exceed 5 digit. For example, for…
3 replies
Hello Experts, I'm currently attempting to create an inventory report using data from inventory tra…
10 replies
Not quite sure where to post this or how quite to ask as its early stage I am looking for two type …
1 replies
Folks I'm wondering can you help me here. I have inherited a system that populates a table from Exc…
3 replies
Viewing 15 topics - 361 through 375 (of 1,814 total)
You must be logged in to create new topics.