Viewing 15 posts - 1,771 through 1,785 (of 2,452 total)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 14, 2012 at 12:19 pm
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';
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 13, 2012 at 6:45 am
have you seen/read this article?
http://support.microsoft.com/kb/892490
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 10, 2012 at 2:28 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 9, 2012 at 5:23 am
can you post the view definition?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 8, 2012 at 5:48 am
does this help?
INNER JOIN TableB AS B ON DATEADD( dd , DATEDIFF( dd , 0 , A.date_created ) , 0 ) = DATEADD( dd , DATEDIFF( dd , 0 ,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 7, 2012 at 11:08 am
SS53217 (9/6/2012)
everything works fine but the excel files are not being iterated only...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2012 at 12:02 pm
SS53217 (9/6/2012)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2012 at 11:37 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2012 at 5:59 am
for readability
SELECT f.WSEC_FEA_ACT_UID ,
c.CONV_STRING AS WSEC_FEA_ACT_NAME
FROM
MSP_WEB_SECURITY_FEATURES_ACTIONS AS f
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2012 at 5:41 am
SS53217 (9/5/2012)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2012 at 2:11 am
SS53217 (9/5/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2012 at 2:48 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2012 at 10:55 am
CELKO (9/1/2012)
Somebody did not do his homework! Tables have no ordering BY DEFINITION. If...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2012 at 9:22 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 2, 2012 at 5:51 am
Viewing 15 posts - 1,771 through 1,785 (of 2,452 total)