If you have 300,000 rows, the UDF will be called 300,000 times if you defined a scalar UDF.

More info:

User Defined Functions and Performance

Using a table valued function could improve performance.

How do you know which amount you have to transfer between branches?

As this is done on a daily basis I will always have to know what the items available are...

db808 (10/30/2013)

---

I'm reading the Training Kit Book and there are sections with a "key" icon. What are the relevance of these verses the sections labled "exam hints"

Also is 2...

I sincerely doubt it.

SSIS packages are executed with dtexec.exe and as far as I know (unless I'm missing something) .exe files cannot run on Linux.

Here you go:

-- Create Table

CREATE TABLE #TestDates

(VoyageDate DATE, Ranges DATE, Earnings INT);

-- Insert Sample Data

INSERT INTO #TestDates

VALUES ('2013-01-01','2013-01-15',40000),('2013-01-15','2013-02-05',25000),('2013-02-05','2013-03-16',35000);

-- Tally Table of 6561 rows

WITH T1(F) AS

(

SELECT...

nilamskhandare 86777 (10/31/2013)

---

Hi Experts ,

I have very big query (exceeds 300 line) and i want ot paste the same of dataset query designer.

Is their any way by which i...

Your process might be improved, but there isn't enough detail for us to work on.

To store the result of the query in a variable (make sure only 1 row is...

Nice article, nice to see some alternatives to the "insert in staging table and then do an update".

However, it's a we can't review the UPDATE statement used. The article...

Define Parameters in the MDX Query Designer for Analysis Services (Report Builder and SSRS)

I can't see the picture, try posting it as an attachment to your post.

Janie.Carlisle (10/30/2013)

---

K,

Thanks for help. Was trying to avoid duplicate work but not sure it's possible. Don't really see the logic of pushing the data from an ERP into a DW...

I know there are specific SSIS connectors for Teradata, but not sure they are available for 2005.

Never worked with Teradata myself.

Star schema's with facts and dimensions is just a modelling technique used for data warehouses.

If your model is implemented in SQL Server, you can still use CTEs and UNION ALL...

OK, this is weird.

Some guy just started a thread with as title a part of my signature.

The post itself is a reply from me taken from another thread.

When you look...

Just for your information:

osql is deprecated (and it has some issues. I remember it not working with utf8 files...