Viewing 15 posts - 6,016 through 6,030 (of 8,755 total)
SQL_Kills (3/17/2015)
Jeff, The Yesterday_Amount should show the Amount the Amount the ID was for yesterday. Thanks
Could you elaborate on Dwain's questions please?
😎
March 17, 2015 at 2:28 pm
ScottPletcher (3/16/2015)
CELKO (3/12/2015)
Since BIGINT is larger than the number of atoms in the universe, we do not use it very often.
No, not even close. There are at least...
March 17, 2015 at 2:15 pm
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
Viewing 15 posts - 6,016 through 6,030 (of 8,755 total)