Not sure about using a SAS dataset directly , but you could use SAS ODBC to connect to SQL Server db and run the query from there.

N means 'National'

It is used when you want to ensure that the value you are passing is a Unicode value

We were planning on upgrading to 2008, but due to budget cuts this is no longer an option.

Which is a shame as the project i am working on required...

kyle (1/27/2009)

---

We basically just want all the names in the field to be proper cased as you said most people are used to seeing Macdonald.

After further thought, we could just...

how often is table used?

is it mainly used for inserting data or retrieving data?

If was fairly static then i would recommened putting a clustered index on ValidationPartyID, but...

Ed (1/26/2009)

---

Thanks. The lightbulb is starting to go on.

Next question: The sysValidationList table (I did not design this), has a column, ValidationListID, of type int that is marked...

In some situations the way to get your foot in the door is to take a lower level position with a company that may lead you into some DBA...

Ed (1/26/2009)

---

From my brief reading on clustered index, they're useful for returning a range of values that have some meaningful sort order. Since this table uses a GUID for...

You should really have a clustered index on the Primary key,...

aziz.kapadia (1/26/2009)

---

There are two type of items one is Serialized like IMEI, SIM etc. and non serialized items like battery, charger etc.. Serialized item always going to be one in...

Okay sorry i mis-read the question..

It seems like the value is too big to fit into a numeric column

There will probably be a row that has a character that cannot be converted to integer.

try using this code to find the offending row(s)

SELECT * FROM YourTable

WHERE ISNUMERIC(YourColumn)=0

checking the error logs can alert you to possbile corruption, but the only sure fire way is to use DBCC CHECKDB.

You will need to use a variable for this, in the FTP task editor set IsRemoteVariable to True. then construct a variable based on the date and use...

The problem is that you are doing the calculation on the left side of the clause, this leads to a non-sargable query that the optimizer will struggle with

http://groups.google.com/group/huyuhui/web/a-term-sargable...