Viewing 15 posts - 6,181 through 6,195 (of 8,761 total)
Slightly amusing, not even an implicit conversion here, just a Constant Scan of a Scalar string ($0.0000), guess it works for the most common ISO-4217 currencies' single symbol codes, would...
February 7, 2015 at 1:31 pm
Lynn Pettis (2/7/2015)
Eirikur Eiriksson (2/7/2015)
Lynn Pettis (2/7/2015)
Eirikur Eiriksson (2/7/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (12/12/2014)
(To the...
February 7, 2015 at 12:14 pm
You are very welcome, if you have any problems just let us know.
😎
A quick thought on the remainder of the problem, what is missing (from my point of view)...
February 7, 2015 at 12:02 pm
Lynn Pettis (2/7/2015)
Eirikur Eiriksson (2/7/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (12/12/2014)
(To the tune 100 Bottles of...
February 7, 2015 at 10:06 am
Quick thought, add a case for the zero length message entries, otherwise you solution is fine.
😎
USE tempdb;
GO
SET NOCOUNT ON;
declare @Files table (ID int identity(1,1) primary key,Filename varchar(50),Date_Created datetime)
insert into @Files...
February 7, 2015 at 10:02 am
Here is a quick possible solution which uses the ROW_NUMER function to enumerate the values in Table B in order to create an iterator for linking with the EventRefSeq from...
February 7, 2015 at 8:38 am
Quick thought, each statement will execute regardless of the success of other statements in the dynamic code, hence errors and transactions must be explicitly handled, consider this example
😎
USE tempdb;
GO
IF OBJECT_ID(N'dbo.TBL_TRAN_TEST')...
February 7, 2015 at 3:00 am
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (12/12/2014)
(To the tune 100 Bottles of Beer on the Wall)
......
February 7, 2015 at 2:36 am
Sean Lange (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Sean Lange (2/6/2015)
Sioban Krzywicki (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (12/12/2014)
(To the tune 100 Bottles of...
February 7, 2015 at 2:35 am
For completeness, a SQL Server 2012 and later running total using a window function method
😎
USE tempdb;
GO
IF OBJECT_ID(N'dbo.Test') IS NOT NULL DROP TABLE dbo.Test;
/*SqlServer 2012+*/
CREATE TABLE dbo.Test(
[Week] [int] NOT NULL,
[Count]...
February 7, 2015 at 2:32 am
Quick question, how do the tables relate to each other, cannot see anything obvious at the first glance?
😎
February 7, 2015 at 2:27 am
Srl832 (2/6/2015)
<shortMessage>Fail to insert Adventureworks.inc.humanresourceslog into database SqlException: Login failed...
February 7, 2015 at 2:09 am
What bothers me here is the fact that this a fairly large heap, makes any kind of batch/portioning effort very costly, any chance that you can change the table to...
February 6, 2015 at 1:50 pm
Sean Lange (2/6/2015)
Sioban Krzywicki (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (2/6/2015)
Eirikur Eiriksson (2/6/2015)
Lynn Pettis (12/12/2014)
(To the tune 100 Bottles of Beer on the Wall)
......
February 6, 2015 at 1:42 pm
Sean Lange (2/6/2015)
Eirikur Eiriksson (2/6/2015)
February 6, 2015 at 1:33 pm
Viewing 15 posts - 6,181 through 6,195 (of 8,761 total)