Topics
Started by
Posts
Last post
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
Greetings, I have a table of ID's and activities like the following and I need to pivot the data as…
10 replies
I have inherited a demo db called demo_1 and a live db with +300 tables. They are almost identical…
3 replies
I have a column which has the following data in it for example {"changedAttributes":[{"logicalName"…
3 replies
Viewing 15 topics - 331 through 345 (of 1,784 total)
You must be logged in to create new topics.