TSQL Challenge 75 - Find the Episode and Sequence based on interval
The challenge is to find the Episode and Sequence based on interval.
2012-02-06
1,295 reads
The challenge is to find the Episode and Sequence based on interval.
2012-02-06
1,295 reads
The challenge is to create a query for a report that show expiring material
2012-01-23
958 reads
The challenge is to wrap the text by specified position.
2012-01-09
2,883 reads
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.
2011-12-26
1,847 reads
Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.
2011-12-12
1,413 reads
This challenge invites you to identify the longest sequence of alphabets from a string.
2011-11-28
1,004 reads
Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
2011-11-14
629 reads
This challenge invites you to Generate kaprekar kernel or series from numbers.
2011-10-31
903 reads
This challenge invites you to identify the largest sequence of alphabets from a string.
2011-10-17
967 reads
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.
2011-10-03
584 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers