Luis Cazares (4/8/2014)

---

It could help in other cases, but I'm not sure that it's the best option if you're trying...

You should look into linked server, check this out

😎

The parenthesis where the problem, a CTE does not require the columnar declaration.

😎

IQ and Anywhere yes, ASE (to my knowledge) no.

😎

Sybase has supported RANK with the OVER clause for some time, which version are you using?

Try this out, should work 😎

cREATE TABLE #SampleData (ID INT, Tran_Date DATETIME, Ref VARCHAR(10) NULL)

INSERT...

Using the row_number function

😎

cREATE TABLE #SampleData (ID INT, Tran_Date DATETIME, Ref VARCHAR(10) NULL)

INSERT INTO #SampleData(ID, Tran_Date, Ref)

SELECT 1, '2013-01-15', NULL UNION ALL

SELECT 1, '2012-04-10', 'Kames' UNION ALL

SELECT 1, '2013-10-05', 'Adjustment'...

This function will bring back the last number only portion of the string

😎

CREATE FUNCTION dbo.udf_GetNumEEric

(

@strAlphaNumeric VARCHAR(256)

)

RETURNS TABLE

AS

RETURN

WITH NBR1(N) AS (SELECT NM.N FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS...

Not much of a difference for an untyped xml, typed...

Peter2012 (4/8/2014)

---

Hi Eirikur,

declare @TableSpace table

(

TableName sysname

, RowsK varchar(32)

, ReservedMB varchar(32)

, DataMB varchar(32)

...

Start by adding a data viewer in the Data Flow Task, between the Flat File Source and the destination.

Run the package in debug, if all the rows are shown in...

rho_pooka (4/7/2014)

---

Thanks a ton for the help! Can the answer look different if you wanted to use node navigation? I think that's what I was trying to do...

First thought, make certain your user has the proper rights on both sql and ssas as a windows user.:cool:

SQL Wayne (4/4/2014)

---

I apologize if this is a stupid question...

I have VS 2010 installed on a Windows 7 machine. We use this for TFS mainly. I am at a new...

Could you detail your setup, looks like there is a missing login for the SSAS on the Sql Server.

😎

call.copse (4/7/2014)

---

I'd go so far as to say that you need to (and to be able to) take pride in your team. It's definitely one of those circumstances where if...