Viewing 15 posts - 6,211 through 6,225 (of 8,761 total)
Brandie Tarvin (2/4/2015)
February 4, 2015 at 7:57 am
Mindy Hreczuck (2/3/2015)
I'm trying to figure out which databases this expansion will take...
February 4, 2015 at 2:00 am
ma701ss (2/3/2015)
I'm trying to insert into a table from an XML file. The mapping works OK however there is a problem with one of the fields. It is field name...
February 4, 2015 at 1:50 am
Quick thought, this code looks very inefficient, while the logic is rather simple, should be straight forward to construct a set based code for the operation. Could you post DDL...
February 4, 2015 at 1:43 am
Quick thought, maybe this will help
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @TXML XML = '<ROOT><code>1</code><code>2</code><code>3</code><code /></ROOT>';
SELECT
ROW_NUMBER() OVER
(
...
February 2, 2015 at 11:39 pm
sqldriver (2/2/2015)
Eirikur Eiriksson (2/2/2015)
Quick thought, the problem itself is straightforward, the issue is more the schema, normalize it and the solution is easy.😎
That was one of the first things I...
February 2, 2015 at 11:01 pm
Grant Fritchey (2/2/2015)
Sioban Krzywicki (2/2/2015)
SQLRNNR (2/2/2015)
Ed Wagner (2/2/2015)
I only have Standard Edition, but I can't imagine running a production instance on SQL Express. Maybe I'm just spoiled.
I have to...
February 2, 2015 at 12:34 pm
Quick thought, the problem itself is straightforward, the issue is more the schema, normalize it and the solution is easy.
😎
February 2, 2015 at 12:02 am
Quick thought, isnull is implemented as a case statement under the bonnet/hood, performance tends to be the same for equal statements.
😎
February 1, 2015 at 11:08 pm
Jeff Moden (2/1/2015)
jarick 15608 (2/1/2015)
February 1, 2015 at 12:02 pm
jwiseh (1/31/2015)
I remember the pain of working with a system where a developer had chosen the TIME data type to store the number of hours worked in a day....
January 31, 2015 at 3:48 pm
Andy Hogg (1/31/2015)
Eirikur Eiriksson (1/31/2015)
...phone number as decimal with the fraction as the extension...You have got to be kidding me!!! :w00t:
Just like "The Evil That Men Do", but this time...
January 31, 2015 at 3:34 pm
Don't know where to start, possibly EF choice of geography as varbinary(max) or XML as nvarchar(max). Other peculiarities would be Currency Exchange Rates as int, Social Security Number as datetime,...
January 31, 2015 at 2:24 pm
Could you please check your data sample, somehow id doesn't look right or I'm missing something
😎
January 31, 2015 at 12:42 pm
Quick question, is this ERD an accurate interpretation?
😎
...
January 31, 2015 at 11:52 am
Viewing 15 posts - 6,211 through 6,225 (of 8,761 total)