Quick thought, by removing the alternative predicate from the...

TomThomson (10/4/2014)

---

Eirikur Eiriksson (10/3/2014)

---

It is worth noting that the THROW...

h2sh (10/3/2014)

---

hi,

i'm trying to work with full text search , i have create a view , but unfortunately , the view doesn't have a column which have a non duplicate...

Alan.B (10/2/2014)

---

I have a few dev boxes running 2014 and have have experienced some instances where 2014 is giving me a parallel query plan where on 2012 I get a...

Quick thought, use NULLIF or skip the ISNULL in the inner query for Actual_CurrentMonth and Budget_CurrentMonth to return NULL instead of 0, then remove those two columns from the group...

Quick thought, what is the data type of the MANUFACTUREDDATE column? If the MANUFACTUREDDATE is a character column of the format MM/DD/YYYY (101) then you must always use the 101...

Had this handy (straight from BOL);-) should get you passed the hurdle.

😎

/* Relevant date time functions with BOL comments*/

SELECT

/* Returns the current database system timestamp as a datetime

...

It is worth noting that the THROW "message" is fixed...

Best option would be to use T-SQL, it is simple and straight forward, here is a quick example.

This sample uses XML AUTO, by changing to XML PATH, almost any...

Here is a simpler and better performing version of the XQuery, where the XQuery does the leg-work instead of using a union in the TSQL part. The result set contains...

Quick questions:

A. how are you importing the XML files?

B. Do the files have as XML declaration tag (<?xml version="1.0" encoding="UTF-8" standalone="no" ?>)?

C. Can you post a more complete sample...

Quick thought, you can do some string splitting and concatenation, not too pretty but works

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @DATETIMESTRING VARCHAR(12) = '200508310926';

SELECT CONVERT(DATETIME,SUBSTRING(@DATETIMESTRING,1,4) + CHAR(45) +

...

In this case, my first suggestion is to use a staging table at the destination for the aggregation. Is that an option?

😎

Quick question, what is the data source and destination (file,table etc.)?

😎

hakan.winther (10/2/2014)

---

I agree with you. I Think it's hard to...