Please bear in mind that I have no idea about your data. I do not know what your contracts are. I don't know what 'players'...

This construct

t.ticket_date BETWEEN @SearchFromTicketDate AND @SearchToTicketDate + ' 23:59:59:997')

Should be written like this, to completely avoid any problems with fractions:

t.ticket_date >= @SearchFromTicketDate AND t.ticket_date < (@SearchToTicketDate + 1 day))

What is your connection string?

antonio_scp125 (1/5/2016)

---

In a Data Mart I have a table with information about Players (Dimension Player). And It have the following attributes:

•Name (nvarchar(250))

•Dt_Contract (date)

•New_Player (int)

•DT_Execution (datetime)

The New_Player is a...

bpowers (1/5/2016)

---

We received verification that the data can be submitted with all the Header data then the Detail data, as such:

Header 06721

Header 05482

Header 04263

Detail 06721

Detail 05482

Detail 05482

Detail 04263

Etc...

Not sure if...

You could try using FINDSTRING() instead.

FINDSTRING(@[$Package::StateExcludeNames], [State], 1) == 0

where [State] is the data column and

$Package::StateExcludeNames is a...

vipin_jha123 (1/5/2016)

---

Hi All,

I have source flat file , I want to exclude the records containing below state.

I have created one variable which data type is string and value is as...

hartmann 74688 (1/5/2016)

---

Personally, I will continue to use datetime unless I need the additional accuracy afforded by datetime2. Why? Because datetime columns perform better and require less disk space than...

I spotted a few minor typos:

"legacy tables that uses datetime" - use

"some developer simply" - developers

"8 byte of storage" - bytes

"ambigous" - ambiguous

"Let;s " - Let's

hartmann 74688 (1/5/2016)

---

pjdijkstra (1/5/2016)

---

We went back from Datetime2 to Datetime because when we saved the data to excel (from SSRS) Excel wouldn't interpret the Datetime2 fields as dates. We didn't...

Have you considered using Change Tracking?

The columns in a single result set cannot vary between rows.

But maybe you can create a simple result set containing something like (RecId Rownum Data) where the Data column is...

RonKyle (1/4/2016)

---

Yes, I'm sure. ...

RonKyle (1/4/2016)

---

Post is a little old, but I ran into this issue and the solutions offered didn't help me. So in the event someone else runs across this and...

Wow. That suggests you have written/tested 10,000 (or more) TVFs :w00t: