This is my code:

declare @Date varchar(8) = 'UnconvertDate'

select CAST(RIGHT(@dATE, 4) + LEFT(@Date, 4) as date)

from hp27.importData

I get this error message:

Conversion failed when converting date and/or time from character string.

That worked! Now this is probably a silly question, but how do I get it to use the date that's already in the date field? By using the...

I was able to get the data into a staging table in SQL. All the fields of the staging table are varchar except for the Hour field which is...

What data type do I bring it into the staging table as?

I was able to get the SAS ODBC driver downloaded and configured. I know it's working because I can import the data into Excel using that SAS data source....

There is an Export Wizard in SAS where I can export the file to a csv or txt file. How would I then take the csv file and pull...

I looked under the "About" and it says I have SAS 9.1 TS Level 1M3 XP_Pro Platform. So do I perform the proc export within SAS? As I...

How do I know if I have the correct interface? All I was told was the the SAS is intalled locally on my machine. There is no server...

Did you figure out how to accomplish this? I've got SAS on my PC, not on a server and I want to load the output from the SAS file...

I tried selecting all regions by default as well and that didn't work. I keep getting the original message.

I tried making the multi-select parameter null, but it wouldn't allow that.

Okay, this will show how new to SQL Server I really am. You'll have to dumb it down for me. I'm not sure how to go about setting...

I have set up shared data sources to both databases on each server. I am needing to combine the two to create a dropdown for my parameter. I'll...

Well see, that's the thing. When I type the code in, I don't put quotes around the VARCHAR. SSRS automatically puts them in when I run it.

The error...

I've tried both ways so I must be doing something wrong because I still get an error. First, I looked again at the table and both fields are character...