SET DATEFORMAT DMY;

--SET DATEFORMAT MDY

DECLARE @processing_date AS varchar( 10 );

SET @processing_date = '27/04/2012';

SELECT CAST( @Processing_Date AS date );

this should work as well, but I think it...

not sure if I fully understand your requirements...but does this work?

UPDATE XYZ_TB

SET data = LEFT( data , 49 )

WHERE LEFT( data , 8 ) = 'ZY050340';

have you seen/read this article?

http://support.microsoft.com/kb/892490

here is an excellent article on "catch all queries".

well worth a read for you I think

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

kind regards

can you post the view definition?

does this help?

INNER JOIN TableB AS B ON DATEADD( dd , DATEDIFF( dd , 0 , A.date_created ) , 0 ) = DATEADD( dd , DATEDIFF( dd , 0 ,...

SS53217 (9/6/2012)

---

i changed the provider and followed the example that was specified in link that u posted me

everything works fine but the excel files are not being iterated only...

SS53217 (9/6/2012)

---

hi J Livingston SQL,

as mentioned in the example i have specified

In the Collection I have provided Enumerator As: "Foreach ADO.NET Schema Rowset Enumerator"

Provider: .net provider for Oledb\microsoft jet...

suggest you post some create table scripts and sample data insert scripts that clearly represent the problem you are having...we cant see over your shoulder and having some scripts to...

for readability

SELECT f.WSEC_FEA_ACT_UID ,

c.CONV_STRING AS WSEC_FEA_ACT_NAME

FROM

MSP_WEB_SECURITY_FEATURES_ACTIONS AS f

...

SS53217 (9/5/2012)

---

http://beyondrelational.com/modules/2/blogs/571/posts/14364/extracting-data-with-ssis-from-multi-excel-file-placed-in-a-folder-having-multiple-excel-sheet.aspx

i have tried this example but encountered with a prob i.e., in FIG 9 the database file are to be added

When i try to add database file name...

SS53217 (9/5/2012)

---

can anyone please help and provide me an example to loop over a set of excel files from a given folder and extract all the information onto a sql...

Hello everyone. So I have a database in SQL Server 2008 that contains 5 tables. I have connected Microsoft Access to this SQL Server database and have all the tables...

CELKO (9/1/2012)

---

>> I have column in a table which needs to be ordered in an ascending order. <<

Somebody did not do his homework! Tables have no ordering BY DEFINITION. If...

please see my response to your other questions

http://www.sqlservercentral.com/Forums/Topic1353196-2799-1.aspx

quick idea....

SELECT Supplier_name as Heading1, Supplier_country as Heading2

FROM SUPPLIERS