What i see at this point when i past the connectionstring getting the error:

System.Data.dll
Additional information: Keyword not supported: 'mongodb://mycosmosdb:brVmi46RA7azECQro3m2sirrywJAzLdmpxiq6xKr4MK9iFsJdjFpQnX5UfttiGU1lPZg62AE1zo6Amhg==@mycosmosdb.documents.azure.com:10255/database?ssl'.

When I do this without ssl=true I get the following error:

What is the syntax to make this happen on that column?

https://msdn.microsoft.com/en-us/library/ms186342.aspx

is that this syntax?

-- Create a clustered index called IX_TestTable_TestCol1

-- on the dbo.TestTable table using the TestCol1 column.

CREATE...

Tnx for quick reaction.. There was a diffrence in the view colm and my table 🙂

What is the Question?

GilaMonster (6/5/2015)

---

Well, yes that's going to give an error. Aliases go after the column definition, not...

CAST('0' as NVARCHAR(20))as Account,

I fix it

CAST(('0' as franchiseevendaccount) as NVARCHAR(1))

---

Incorrect syntax near the keyword 'as'.

TNX 🙂

It did not work...

Test if a field value is null. This expression can be used to control the Hidden property of an image report item.

=IIf(IsNothing(Fields!mapimage.Value) , TRUE, FALSE)

Your not using anthing then...

Put your connection in a Variable [Provider=SQLNCLI10.1;Data Source=xxx;Integrated Security=SSPI;Initial Catalog=msdb]. Then go to the propertie of your Execute SQL Task Editor --> then go to Expressions --> Click on...

PB_BI (5/12/2015)

---

Generally it's polite to provide a little bit of context when posting questions on here.

The error is probably the comma at the start of the expression ("0,01" instead...

Whats your variable and connection settings?

Need more information.

I modify my SQL and this only 1 sec to run it 🙂 anyway tnx for comment 🙂

WITH ACCOUNT AS

(

SELECT

[DATAAREAID] + '_' + [ACCOUNTNUM] AS FACC_BKEY

,[ACCOUNTNUM]

...