Check yourself what your substrings are returning. anyway this can be converted to datetime without any string operations:

SET DATEFORMAT mdy

;WITH CTE_BD

AS(

SELECT *

FROM (

SELECT '06/06/63' Col015 UNION ALL

SELECT '09/17/61' Col015 UNION...

You have to grant appropriate premissions for User to that schema

GRANT <premission> ON SCHEMA::com TO com

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

Try this:

DELETE FROM staging_account WHERE Auto_Id IN (

SELECT a1.Auto_Id

FROM staging_account a1

JOIN staging_account a2 ON a2.Account_Id = a1.Account_Id

AND a2.Auto_Id != a1.Auto_Id AND a2.Priority < a1.Priority)

You should find answer to your problem under link below:

http://www.sqldbpros.com/2011/12/ssis-no-column-information-was-returned-by-the-sql-command/[/url]

Hi,

Use OleDB source in your Data Flow task to get results and try using Flat File Destination for your output?

SQL Server management studio is a developers tool to be able to connect to the sql engine, the installer you've downloaded does not include the engine itself. have you installed...

I had the same problem as you building the attached solution and that was the only decend way i found. Script itself is not complicated, please find mine below:

public void...

You need a script task that will try to open that connection, if it succeeds it sends a success and continues as normal, if it fails than you do the...

You can run your query 2 times and than merge the data in one resultset by inserting into a temp table etc.

SET DATEFORMAT mdy

select

convert(datetime,b.p12_value,101) as Call_Date

,a.user_name

,c.form_component_title

,c.form_component_id

,c.score

,c.max_possible_score

,b.form_key

from

[dbo].[Users] as A inner...

cbosman0 (3/19/2015)

---

Hi,

With above it...

Post some rows of [p12_value] column so we can see what we are dealing with.

CONVERT (datetime, value, 101)

is to convert U.S. date standsrt which is mm/dd/yyyy and in your first post you said you're trying to convert "18/01/2014 08:35:13" which is dd/mm/yyyy

try

convert(datetime,b.p12_value,103) as...

rexyrexin (3/18/2015)

---

I got the answer:

select * from mytable

where class='something'

AND ISNULL(xyz,0) = CASE WHEN @abc = 1 THEN 1 ELSE ISNULL(xyz,0) END

Here @abc is the stored procedure...

ok If your "1" value is in fact a parameter and you want your results to be based on that parameter having a null value or 1 or 0 you...

Is your "1" a parameter/variable that you are providing?