r.hensbergen (12/18/2008)

---

Jeff Moden (12/18/2008)

---

Nah... really? I thought the internet was...

Then I think it is official, the is the "Water Cooler" thread.

Have you tried putting the paths and names ("C:\Program Files\My Directory\Here is my file.dtsx") in double quotes? The command line does not like spaces in directory and filenames if...

Is that the entire query or just a snippet?

Also, could you post the DDL for the tables involved?

Sherri Barkley (12/18/2008)

---

I am trying to write a query for a SSRS report that has a location parameter. The problem I am facing is that I have created a...

The following code is a basic left join. It just doesn't return the result set you requested.

select

*

from

#date_dim d

...

Is there a reason you need all the duplicated rows where the dates have null values?

If you provide the DDL (create statements) for your tables, sample data for the source table (as insert statements that can be cut, paste, and executed in SSMS) to load...

Philip Horan (12/18/2008)

---

I am attempting to INSERT from a temporary table. I created the temporary table from an excel file. The data types for the temporary table do not match...

You want to use one of these two functions: suser_name(), suser_sname(). You might want to read up on them in Books Online to see what they do.

I did a little more testing adding a cast( as varchar(100)) around the replace, and it validated Jeffrey's assertions above.

That is essentially the question you asked originally. The problem was that the information you showed did not match reality. You showed values that were all numeric. ...

Just ran a test. Here is what I found. If you use REPLACE in a select into statement, since it needs to create the table on the fly...

Steve used to give away SSC Polo Shirts when you reached a certain level as a forum poster, but the heck if I know what level that is, as I...

Well, not knowing what you are working with, and deciding to take a swag at it, try out the following code and see if that gets you going in the...