Glad you worked this out, as I suspected from reading the thread that it was some strange conversion taking place. I have found that converting to string in these situations...

You could include both of the timestamp datetime fields in your table design. Call one like DateTimeModified, the other like DateTimeLoaded. In your (I assume) daily ETL you could select...

Is this a one time event? If so I can offer a quick and dirty method :

1. In SSMS go to Tools > Options > Query Results>SQL Server> Results to...

bantrim (12/31/2014)

---

MMartin1 (12/31/2014)

---

One of the tweaks I do is alter the max rows per batch and or commit size when transferring millions or rows with SSIS's, dataflow's ole db destination....

DonlSimpson (12/31/2014)

---

MMartin1 (12/31/2014)

---

How would this be different? Would you have fields in the table to denote first Tuesday of...

One of the tweaks I do is alter the max rows per batch and or commit size when transferring millions or rows with SSIS's, dataflow's ole db destination. This optimises...

I have to wonder why you need to use a batch file. Do you need to schedule the package with Windows Task Scheduler? I myself prefer the SQL Server Agent...

Do you have access to SSIS? You could query the data with the use of a data source component, of the dataflow task. It is much faster than a linked...

ikrami2000 (12/30/2014)

---

Steve, please don't give me your advice, if you need to help you will do, if you don't , just don't reply, because sometimes anyone can search...

How would this be different? Would you have fields in the table to denote first Tuesday of the month,...

Did you try building a dataset to calculate each default date that you want ? You could then use those data sets, one for the from date and the other...

Out of curiosity, any performance considerations with logon triggers that you are aware of?

KoldCoffee (12/28/2014)

---

pietlinden, in the end, the approach I took was to create the portion of the filename that holds the date using functions and concatenate it to the part of...

gissah (12/27/2014)

---

I am trending the current value on a chart. For example

=IIF(Month(Parameters!EndDate.Value) > MAX(Fields!OrderMonth.Value),

give me the current value by:

Let say Goal = 1000

Order month = month order was purchased

12=...

Create a table valued function that returns the delimited string as a column in a table. Join whatever table you are working on to this table (valued function) on the...