Viewing 15 posts - 6,016 through 6,030 (of 8,753 total)
CELKO (3/17/2015)
No, not even close. There are at least 10^78 atoms, whereas bigint only covers just under 10^20.
My bad :rolleyes:
A quick Google: it is believed that between 120...
March 17, 2015 at 2:02 pm
The desired results do not match the sample data + the logic, can you elaborate on this?
1) What is the definition of 'O'?
2) Why the difference between the requirements and...
March 17, 2015 at 1:39 pm
Luis Cazares (3/17/2015)
Can someone help with a crystal ball or interrogation system for this thread?http://www.sqlservercentral.com/Forums/Topic1668185-391-1.aspx
You will have to ask Koen, he supposedly took it to the shop for repair and...
March 17, 2015 at 1:32 pm
Quick suggestion, group and aggregate the set separately and then union the two sets
😎
USE tempdb;
GO
SET NOCOUNT ON;
--Existing Data
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#Table1') IS...
March 17, 2015 at 1:24 pm
Ed Wagner (3/17/2015)
djj (3/17/2015)
crookj (3/17/2015)
Ed Wagner (3/17/2015)
SQLRNNR (3/16/2015)
Ed Wagner (3/16/2015)
Jeff Moden (3/14/2015)
eccentricDBA (3/13/2015)
Ed Wagner (3/13/2015)
crookj (3/13/2015)
Revenant (3/13/2015)
Ed Wagner (3/13/2015)
djj (3/13/2015)
crookj (3/13/2015)
Ed Wagner (3/13/2015)
djj (3/13/2015)
Ed Wagner (3/13/2015)
jasona.work (3/13/2015)
Stuart Davies (3/13/2015)
SQLRNNR (3/12/2015)
droneBee
Happy
Peaceful
Flower...
March 17, 2015 at 7:28 am
March 17, 2015 at 5:34 am
Quick suggestion, use TRY_CONVERT
😎
DECLARE @DATEVAR DATE = NULL;
DECLARE @STRVAR VARCHAR(50) = 'Not...
March 17, 2015 at 3:57 am
As Dwain mentioned there are several ways of doing this, here are few examples
😎
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.Transactions') IS NULL
BEGIN
CREATE TABLE [dbo].[Transactions](
[ID] [char](5) NOT NULL,
[Amount] [float] NULL,
[InjectedDate] [datetime] NULL
)...
March 16, 2015 at 11:22 pm
Quick possible solution/method, should give you an idea
😎
DECLARE @COLOURINT INT = 14745599;
SELECT 'RED' AS C_IDX, ( @COLOURINT & 0xFF) ...
March 16, 2015 at 1:19 pm
webrunner (3/13/2015)
Eirikur Eiriksson (3/13/2015)
Is it simply blocking or is it dead-locking?😎
A comic situation would be two threads trying to write to the deadlock file at the same time...:-D
Hello, thanks for...
March 15, 2015 at 2:31 pm
thomashohner (3/15/2015)
That Bit Bash is sweet! Wow, so cool. I'm not sure why this is exciting but it is. 😀
It is short, concise and straight to the point, nothing complex...
March 15, 2015 at 2:28 pm
Jeff Moden (3/15/2015)
Speaking of "brilliant", nicely done, Eirikur! Heh... you really put the hex on that problem. There's only 1 in 10000 people that would know something like...
March 15, 2015 at 2:24 pm
Have you searched for the Detail.txt log file, my guess is that might lead to the reason for the setup failure?
😎
March 15, 2015 at 6:16 am
Apologies for not being of a much help so far.
😎
Quick thought, is side by side installation an option, that is installing the 2K12 on the same server, migrate every thing...
March 15, 2015 at 6:07 am
Viewing 15 posts - 6,016 through 6,030 (of 8,753 total)