cognos will support SQL Server 2008 R2 and R2 clustering?

cognos will support SQL Server 2008 R2 and R2 clustering? ...

Oracle Trunc Date in SQL Server

Does anyone know how to do the equivalent of a trunc(date) in SQL Server? ...

cognos will support SQL Server 2008 R2 and R2 clustering or not?

i am going to use cognos 8.4.1 and SQL Server 2008 R2 and R2 clustering.is it support cognos SQL Server 2008 R2 and R2 clustering? ...

Microsoft SQL Server unable to convert MySQL date to SQL Server smalldatetime

I am using a DTS package to import tables from MySQL to SQL Server 2000. All works fine except tables that have date type columns (MySQL). The format is YYYY-MM-DD. The receiving fields in MS SQL are smalldatetime. I am getting the following error: ....general conversion failure on column pair ... ( ...

how to insert current date in sql server

am new herecan any one plz help me my problem isam trying to insert current date using asp aand sql server when i insert date i look to database and found 1/1/1900 i search the net but nothing workcolumn data type is datetimeplz help me ...

cognos powerplay on sql server

I designed a relational database in sql server and i need to use cognos powerplay on it. The thing is that the administrator of the tool who i'm working with says that relational databases can not be used, only databases with hierarchy are usefull to desing a cube. I think that realtional database a ...

C++ date vs SQL server date

I need some help in clarifying the difference between the date in MS SQL server and Visual C++. The result of the experiment in both the Visual C++ and SQL server is as follow:1. I used COleDateTime to get todays date in DATE format and the value is 37781.969375000. Then I parse the date formatinto ...

Date from SQL Server db

I had an app that itnerfaced with an ms access db. Since I had it running just fine, the powers that be decided to switch to SQL Server. Most of it works fine, except the date fields. How do I get a date from the db? Here's what I have:CRecordset rs(m_db);CDBVariant varValue;rs.GetFieldValue("T ...

load date from sql server

I would like to make a table with the content loaded from the SQL Server.FOr example there are 5 records loaded from the db, 1 ABC 102 CDE 343 RTG 764 HRE 765 GRE 23As I use asp to get the data from sql server, how i can insert html code in the ASP.NET code?Can you please show me a simple example? ...

Cognos and Microsoft SQL Server 2008

Dipendra Pokhrel said: We are about to upgrade MSQL server 2000 to 2008. Just wondering if Cognos 8 supports MSQL sever 2008 or not ?Any idea? ...

SQL Server Date Issue

Why is the date in SQL Server 2005 printed in this format..Feb 9 2006 12:00AMIn the SQL Server DB it is stored in this format.. 09/02/2006Why is the time added also? I don't want the time.Thanks. And thanks for all your help so far. I'm finally getting the hang of SQL Server.Kevin. ...

sql server 2000 Custom date format(MMMM/yy)----its urgent

hello..! required a helpi want to store a date in sql server field...i set the field type is datetime..bt i jus want to save only Month and year ...kindly help me in it..!i m working with vb6 i set the date formate myDate = Format(cmbMonth1.Value, "MMMM-yy")bt the date store lyk dis (02-Au ...

Date problem with SQL Server!

i have a problem regarding date in sql server. i have a datetime field in my database and i am using hierarchical flex grid to display the records in VB.when i am inserting value to database i am passing only date value but its taking default time value also when inserting.flex grid is also displayi ...

sql server does not exist or access is denied

I work remotely from home.Here is my scenario:I connect to an ip address on the internet to perform day to day database operations. Until yesterday, this worked fine. Suddenly, without any event to make me suspicious, I can not connect (via enterprise manager or query analyzer) to these machines. I ...

How to connect to SQL server 2005?

HP-Unix Server. How Cognos connect to SQL Server 2005 ?(ODBC or OLE)PLS help me ! ...

SQL Server datetime in Java?

I'm using JDBC to send updates to a SQL server 7.0 database. I can't work out how to send the parameters required to set a datetime field. java.sql has classes for date (with no time) and time (with no date). But SQL Server does not support date and time types, only the combined datetime type. There ...

SQL Server 7 will not except date/time data!!

HelloI posted about this recently...and I changed my date field in SQL Server 7 to datetime form smalldatetime...but it will not except dates (birthdates in this case) before 01/01/1900...and dates that are within its value range at the higher end (ie: where the year is 9194)My field in Access 2000 ...

Query a Date Filed in SQL Server 2000

I want to query a date filed in SQL Server 2000 which its default value is set to GetDate().My problem is that the data filed saves data and time for example "3/26/2003 5:34:34 PM", Now when I query the table and:SELECT * FROM tblX WHERE Date='3/26/03' it won't return the record. However i ...

Convert a date function in SQL Server

I have the date in the SQL server column as 2002-06-16 00:00:00.000 and I will be needing this to convert to 2003-06-16 00:00:00.000. Just the year from 2002 to 2003. I used an update statement likeUPDATE dbo.tableASET Datepart (yyyy,TranDt) = Datepart (2003,TranDt)This did not work - is there anyth ...

SQL Server 2000 Date Format

Can anyone tell me how can i change the datetime format in Ms SQL Server 2000. During i insert a data from VB to Ms SQL 2000 database, my date field return me the format as "2004-06-30 14:20:31.000". My actual format need like this "Jun 30 2004 02:20:31 PM" I have format my codin ...

DB2 date & Time datatype migration to SQL Server datetime

We are migrating our database from DB2 8 to SQL Server 2005. We have date and time saperate columns in DB2. For example, Date_of_birth, Store_sun_open_time, Store_sun_close_time etc. For date we are using datetime. For time what datatype should we use in SQL Server? ...

SQL Server equivalent for DATE LIKE '%__/Apr/2006%' (was "Please Give Me A Hand...")

I'm happyguy and this is the first time to post my problem. Thanks a lothere is a SQL query that I know how to write in Oracle, which isSelect * from AttandanceRecord where date like '%__/Apr/2006%'but, now i'm developing my system with using Ms Sql Server 2000, so I don't know how to write a query ...

error of date type field in SQL server 2000 & mshflexgrid

Hithis is my problem.mshflexgrid converts date value from dd.mm.yyyy to yyyy-mm-dd or mm.dd.yyyyWhen i use JetOLEDB & .mdb fileI can show correctly date type field in mshflexgrid with str() function.For example rst.open"Select str(MyDateField) from tableset mshflexgrid.datasource = rsti can ...

SQL Server Query(native query in cognos Framework for creating a query subject)

Venkata Guntupalli said: HiPls find attached queries written in sql server.SALES QUERYSELECT sr.salesRepId AS REP_ID, CONVERT(VARCHAR(4), sr.salesRepId) + ' - ' + sr.lastName AS REP_NAME, srsg.salesGroupId AS GROUP_ID, sg.salesGroup AS GROUP_NAME, srsg.salesGroupLead AS GROUP_SENIOR, vrs.seniorId AS ...

Null date value in SQL Server view

I have a SQL Server View. The problem is that the DateTime field has many Null values which is causing a problem with my parsing of the data in MSAccess.How would I use CAST (or CONVERT) to handle Null Date values in my SQL Server view?I remember there was a way to use CAST or CONVERT similar to the ...

Date Conversion in SQL Server 2005

Everyone, thank you for taking the time to read my post. I'm creating a view in SQL Server 2005 to base a report on Crystal Reports XI. I've been trying to figure out how I can convert a date field in the format YYYYMMDD to MM/DD/YYYY. I'm not quite sure about the steps I need to take to accomplish ...

SQL Server 2005 Date/Time Problem, Please Help

I have two issues and I hope someone can help me with it. I have been on this problem for 3 days now, And I can't resolve it. #1 IssueI have a database in access 2003 that is the front-end and the backend on sql server 2005.I have a table called group_section, that has 3 fields begintime, endtime an ...

Get a List of Last date Database access in SQL Server 2000

I had tried on my local server for the getting details who are last date accessed database in sql server 2000.select b.name as DBName,a.login_time,a.last_batch,a.hostname,a.prog ram_name,a.hostprocess,a.nt_domain,a.nt_username,a.net_address,a.net_libr ary,a.loginame from sysprocesses a, sysdatabases ...

SQL Server Windows Authentication -- Cognos Data Source Connection

Olga Gedroit said: I have a SQL Server Windows Authentication account. Which means: whatever I login to our domain as, when logging in to a database via MS SQL Server Management Studio Express, I choose the authentication type as Windows Authentication and am immediately logged in into the chosen da ...

Programically Inserting date/time into the SQL Server database

Inserting date/time into the SQL Server database:I set my regional options locale (off Control Panel) to English (United Kingdom) for the SQL Server PC, which makes the date format of DD/MM/YYYY.From this PC or another PC set at the same locale I tried to insert the datetime into the SQL Server data ...

Cognos BI 10 installation with SQL Server Content Store

I have read the documentation about the installation of IB Cognos BI 10. I want to create the Content Store in a SQl Server 2005 database. I have followed the instruction of how to create de content database and I have used the collation MODERN_SPANISH_CS_AS than means Case Sensitive and Accent Sens ...

Using Cognos 8.3 Planning with SQL Server 2005

said: We have decided to user Sql Server 2005 Tools. We have created several reports using the publish data . Our users want to have more real time reporting. Has anyone had any expericence with these tools using Cognos 8.3 planning? We just updated for Cognos 7.3 to Cognos 8.3. Is there anyway to g ...

Can't get ASP to read date and time from SQL Server

what i'm trying to do is display 2003-2004using this <% =Year(strDate) ' - ' =Year(strDate) + 1 %>but i can't get ASP to read the date and time from SQL Server ...

SQL Server 2000 Timestamp to Oracle Date conversion

I'm doing a straight data transfer from a SQL Server database table to an Oracle 8i database table.The input side brings in a column with SQL Server type date/time. Ascential sets this to Timestamp. The data coming in this column is in the format YYYY-MM-DD HH:MI:SS.999 (ex: 2004-10-08 00:00:00.000) ...

SQL Server and getting records by date

I'm trying to extract all records for a given date from an SQL Server 7 database. Records are stamped with a timestamp like this: "1/18/01 10:53:31 AM"Queries using "WHERE timestamp LIKE '1/18/01'" are not working.What's the best way to select all records for a given date using t ...

SQL Server Express 2005 and Date field

I am using SQL Server Express 2005 as my Database and programming in C# 2005. In one of my Table "Results" I have a field named "ResultDate" of DateTime data type. In my form I have a DateTimePicker. I want to save only one record for a particular date, hence while saving the rec ...

SQL Server + Date Issue

all. Working on SQL Server. The date is causing me some problems. I want to return rows in the below query but doesn't seem to recognise $class_date.Why is this??$query = "SELECT t.ffnumber "."FROM training t, class c "."WHERE c.course_ID = '$course' "."AND c.locat ...

SQL Server - Returning Date Value

// process date **********************************$closed_date = date("d/m/Y" ,strtotime($row['closed_date']));echo '<h1>'.$closed_date.'</h1>';closed_date is set in the database as smalldatetime. Also given NULL value.If the field is NULL today's date is returned. Why is this? ...

Problem in finding birthday from date of birth in SQL Server

I have a database in SQL Server 2005.I've a table namely 'PersonalDetails' in it which contains a 'date of birth' field of type datetime.I've to generate weekly birthday reports .I wrote a sp like this: ALTER PROCEDURE [dbo].[selectweekfrompersonaldetails](@paramdate datetime ='02/01/2007')as -- sel ...

strange date issue in SQL Server 2005 Express

Note: I debated whether this should go in ASP forum or SQL Server forum and I think it belongs here.Ok, I have a classic ASP web application, a custom intranet, which has been used in 7-8 different installs, 3-4 different servers with no issues.It uses a SQL Server 2005 database and usually MS Serve ...

SQL Server 2005 Date/Time Problem , Please Help

I have two issues and I hope someone can help me with it. I have been on this problem for 3 days now, And I can't resolve it. #1 IssueI have a database in access 2003 that is the front-end and the backend on sql server 2005.I have a table called group_section, that has 3 fields begintime, endtime an ...

Date parameter from VC component to SQL server

I am using ATL to develop a component that inserts a record into a table in SQL server.One of the fields in the table is of type smalldatetime. Now, my question is, how can I send date values to the database from the component(not the parameter part, but the data type part). ...

Get Date & Time From SQL Server Using VB

I am making a Punch card system for the company, so employees can punch in and out from their computers.i cannot get the date and time from the client computer because they can change the date and time. So I will need to get the date from our SQL server.so my question is how can I do it, I would app ...

Date functions between VB & SQL Server

I am writing a security module and have a function to extract an expiry date from the SQL Server database which is compared against the system date. If the system date is after the expiry date then the user is prompted to change password. Example code :If Date &gt; dtePasswordExpiry ThenfrmChang ...

How to insert date and time in SQL Server

Please guide me how to insert current date in one field and current time in another field in SQL server. I used CAST, it works with date (It works but I am not clear) but not work at all with time.I selcted smalldatetime for date and timestamp for current time storage. ...

Get Date & Time From SQL Server Using VB

I am making a Punch card system for the company, so employees can punch in and out from their computers.i cannot get the date and time from the client computer because they can change the date and time. So I will need to get the date from our SQL server.so my question is how can I do it, I would app ...

Oracle use a SQL SERVER get date in query

I want to constrain my returned data by a change date to just return the last rolling 30 days of data. When I use sysdate, I find the plan is to retreive ALL data across the dblink, and then filter it on the Oracle side.Is there any way I can use the Sql Server getdate() function, something likesele ...

stoing date (date only not time with date) and time seperately in SQL server

HiI am using SQL server 2000.I want store date (date only not time with date) and time seperatelyin a table, also want to searchers based on these fileds.ex: select * from tablename where datefield>10/12/2008 and timefield>12:30 - assume time in 24 hour formatthnaks in advance ...

Change Date Settings to UK in SQL Server Express Edition??

Can anyone help? I need to change the Date settings in SQL Server Express to the UK Settings, dd/mm/yyyy.No idea where or how to do this?Any ideas? ...

MS SQL Server - Date conversion on DTS

I need to transfer data from another database (IBM AS/400) into SQL Server, but I have a problem converting Date column from Numeric Data type into Date Data type,Here is an activex I was trying to perform this task. But it gives me an error(All dates are in MMDDYY format eventough the source column ...