Calculates the next business day based upon the work weeklength, number of days from the start date and a list of holiday dates kept in a table called HolidayDate.Created this script for determining the next banking day from 2 days after a request for wiring funds. Can be used for things like calculating shipping dates […]
2006-01-19 (first published: 2005-07-16)
1,535 reads
Populate @list variable with account(s) to script. Save output to recreate:Login, Password,Default DB,Server Roles,DB Access,DB Roles,DB Object PermissionsDB level permissions are scripted in all databases. Can recreate a single login, or accepts comma delimted list of logins.NOTE:Stored procedures are created in Master, but are deleted
2006-01-19 (first published: 2005-10-19)
1,763 reads
This is a T-SQL script that uses OLE, ADO, Jet4 ISAM, and Linked Server to create and populate an Excel Workbook (XLS) file from T-SQL query. If the Excel Worksheet exists, the query will append to the "table". The code is designed to be used by SQL Agent and to append to the step output […]
2006-01-18 (first published: 2003-04-24)
13,521 reads
This VB script allows you to search DTS packages for keywords, etc. It is also useful for quickly locating what server a given package is on. This is very useful for debugging. Example - you want to know the name of every DTS package the touches a certain table. The text files generated contain the […]
2006-01-18 (first published: 2005-12-07)
6,025 reads
This funciont return a date without end-of-week , it is useful to calculate a new date for any payment!YOU CALL with 'dias_uteis(getdate(), 5)' and will get five useful days after today
2006-01-17 (first published: 2005-12-22)
96 reads
SP_WHO_3 is a very powerful utility for all DBAs. It displays processes connected to the system and what they are doing. It can find blocking processes, can return the Input Buffer for everything in the recordset returned, and provides immense filtering and sorting capabilities. It's designed to be extremely efficient, yet it provides many more […]
2006-01-17 (first published: 2004-08-12)
2,451 reads
I found my self in a fimilar situation where I wanted to modify a table but was not sure how heavily it was used. So I started out with a script that just searched for a table. Then I tought to my self...self...What about all those times you want to expand a column or drop […]
2006-01-16 (first published: 2005-12-22)
438 reads
This Script finds the maximum length of a value in Character type Column.(CHAR,VARCHAR,NVARCHAR) and finds the difference between the Total lenghth and maximum value inserted
2006-01-13 (first published: 2005-12-27)
362 reads
Returns information about all the data / log files on a server, such as total file size, % used & free, etc.Can be set to filter out db's you don't want to monitor.When edited to allow the "update usage", numbers reported will be more accurate.Note: if you edit to allow update usage and intend to […]
2006-01-12 (first published: 2005-12-27)
369 reads
This script will create a series of insert statements for a given table. It does not support every single data type in every way and has some limitations. If you add any enhancements, please send them to me at bbyrd@intellithought.com so I can update it here. Update (28 Feb 2005): Added support/Fixed bug with smalldatetime […]
2006-01-11 (first published: 2005-02-14)
4,955 reads
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
If you've ever loaded a 2 GB CSV into pandas just to run a...
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
Tlp/Wa_Cs:0817-866-887 Jl. Brigjen Sudiarto No.294, Palebon, Kec. Pedurungan, Kota Semarang, Jawa Tengah 50273
Tlp/Wa_Cs:0817-866-887 Jl. Majapahit No.112, Pandean Lamper, Kec. Gayamsari, Kota Semarang, Jawa Tengah 50161
Tlp/Wa_Cs:0817-866-887 Jl. Jenderal Ahmad Yani No.24-26, Panderejo, Kec. Banyuwangi, Kabupaten Banyuwangi, Jawa Timur 68416
We create the following table and then insert some records in it:
create table t1 ( id int primary key, category char(1) not null, product varchar(50) ); insert into t1 values (1, 'A', 'Product 1'), (2, 'A', 'Product 2'), (3, 'A', 'Product 3'), (4, 'B', 'Product 4'), (5, 'B', 'Product 5');What happens if we execute the following query in both Sql Server and PostgreSQL?
select id,
category,
string_agg(product, ';')
over (partition by category order by id
rows between unbounded preceding and unbounded following) as stragg
from t1; See possible answers