Database Discussion Boards

Hello Every body,
I've solved my problem... And this is the solution to convert a decimal to a date in the format (yyyy-mm-dd):

select STUFF(STUFF(CAST(DayDate AS char(8)), 7, 0, '-'), 5, 0, '-') AS Date
from TableName;

Poke tongue | ;-P

Kind Regards
OBarahmeh

a more appropriate solution would be to use the date data type

SELECT CONVERT(VARCHAR(20),CONVERT(DATETIME,'20080819'),106)<br />
SELECT CONVERT(VARCHAR(20),CONVERT(DATETIME,'20080819'),103)<br />
SELECT CONVERT(VARCHAR(20),CONVERT(DATETIME,'20080819'),110)<br />
SELECT CONVERT(VARCHAR(20),CONVERT(DATETIME,'20080819'),111)<br />

Never underestimate the power of human stupidity
RAH

hi
how much File size (data)and File size (log)in sqlserver2005?

check this for more details on Maximum Capacity Specifications for SQL Server 2005

http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]

Regards
KP

Sorry, what a ridiculous question.

You either take the defaults (which will show you are the time how much space) or you set your own sizes.

Bob
Ashfield Consultants Ltd

I want to connect my reports with northwind database with simple putting bindingsource control and want to add tables
through dataexpert
thanks

What have you done so far?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

I want to just print all records from the one or two tables in the report from northwind by crystal report
like using
http://msdn.microsoft.com/en-us/library/ms227875(VS.80).aspx[^]

I have found the following link for direct table fields
I haven't found link tab.

http://msdn.microsoft.com/en-us/library/ms227352(VS.80).aspx[^]

modified on Sunday, July 20, 2008 9:31 PM

And what problem are you having?

I don't think he is having trouble, just wants someone to do it for him.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

hello sir/mam
i am a student and i am still learning.
i have a problem with views.
i have a table name marksheet as

rollno. subject mo max
1001 english 70 100
1001 math 68 100
1001 history 23 50
1002 english 50 100
1002 math 87 100
1002 history 43 50

now i want to make view like this

rollno. english math history total
1001 70 68 23 253/250
1002 50 87 43 180/250

please help me to do my college assingment
i am using ms-sql server 2000

thank in advance

We don't do your homework for you. However, we will help you in the right direction.

So, what have you tried already?

Tip: Can you do this as a SELECT statement? If so, show it.

Recent blog posts:
* Event Organisation (Feedback)
* LINQ to XML (part 4)
* Scottish Developers June Newsletter

My Blog

i have to make a assingment on school managment
i have completed it but excepts this .

when we have to generate marksheet it works fine .the order is

roll no.1001

subject max mo

english 100 60
math 100 78
history 100 76

but when i have to show report as a list

i dont know what to do.

roll no. english history math total
1001 60 78 76 214/300
1002 50 40 60 150/300

i have to show this in a report im using c# and sqlserver

i think it can be done by view but how i dont understand
please help me

Do you have static number of subjects?
Are only those subjects: english history math or you have and any other subjects?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

no all subjects are dynamic

they can be increased or decreased

Sounds like you should do some research on PIVOT and UNPIVOT operators.

Mika

Hi Monu Khan,
ZAK here... ya i do understand your problem... But i strongly suggest you to learn atlest basics of SQL and also have handson training before you come to conclusion that you don't know how....

The question you asked is a bignners levfel one.. This time iam answering you.. But remember "The more you learn... The more you grow..."

Creating View:
**************

CREATE VIEW studentView
AS
	SELECT rollno, english, math, history, total/250 AS NetTotal FROM marksheet

Executing View:
***************

Execute studentView

Try this out monu khan

All the best!!! Cool | :cool:

ZAK

hi. I am developing an IS and I was wondering on how I can load the heavy amount of data in a more efficient way. I was asked to also integrate an algorithm but I don't know where to put it and what to use. The program does much more in SQL queries than C# algorithmic codes. If you know what I mean. To explain it further, if I have about 1 million data entries in my database. How can I possibly load them in a jiffy?

The quickest way to load them is bcp, but I doubt you will load 1 million records 'in a jiffy' what ever method you use Smile | :)

Bob
Ashfield Consultants Ltd

what's BCP? Confused | :confused:

Its a bulk loading utility. Ty BOL or Google. Its the fastest way t get records from a file into a SQL Server database.

Bob
Ashfield Consultants Ltd

hello everybody in this forum

i would like to know what is the appropriate solution for the current case in hand

i have two tables one called userinformation and the other called accountinformation

userinformation
================
id int not null primary key ,
firstname varchar(50) not null,
lastname varchar(50) not null,
email varchar(50) not null

accountinformation
===================
id int not null primary key ,
username varchar(50) not null,
password varchar(50) not null

now there is a relationship between the userinformation table and the accountinformation table (one to one) relationship where id in the userinformation refers to the id in the other table (accountinformation) now there are problems when inserting data into both tables like the following

The INSERT statement conflicted with the FOREIGN KEY constraint "LeftHalfHasMatchingRight". The conflict occurred in database "Sandbox", table "dbo.RightHalf", column 'PairID'.
The statement has been terminated.

now i tried to solve this problem by creating a stored procedure and within that stored procedure i created a transaction in it there is two insert statements like the following

<br />
create procedure adduser (@first varchar(50) , @last varchar(50) , @email varchar(50) , @user varchar(50) ,@pass varchar(50))<br />
as<br />
<br />
begin tran<br />
<br />
insert into userinformation (firstname , lastname , email ) values ('bla','bla','bla')<br />
insert into accountinformation (username , password ) values ('bla','bla')<br />
<br />
<br />
commit<br />
Go<br />

it works just fine but if i tried to insert single record in one of the two tables and try to execute this stored procedure with a new different records for these tables it gives me the same error message because there is a record in the userinformation without referential integrity into the other table which is the accountinformation table .

So please tell me how can i solve this current problem in hand

thank you very much

Human knowledge belongs to the world.

How do you set the primary key value into ID columns? Are they auto-generated.

If you can post table creation scripts (along with constraints), it would help a lot.

Mika

i suggest you the following things!!!

Create Primary Key for "ID" column in userinformation table and make it as IDENTITY,

Crate a new Primary Key column for accountinformation table something like
"accountinformationID" and make it as IDENTITY, Optional but good if you have one.

then Map Primary Key "ID" of userinformation table to "ID" column of accountinformation table, this process is called as Foreign Key creation

Now the basic you need to stick with is that

any insertion on table accountinformation made should have a matching "ID" value from userinformation table to the column "ID" of accountinformation table.

Hope this will help you out!!!! Blush | :O

ZAK

Listen, try this:

userinformation
================
id_user int not null primary key ,<-------
firstname varchar(50) not null, |
lastname varchar(50) not null, |
email varchar(50) not null |
|
accountinformation |
=================== |
id int not null primary key , |
id_user int not null foregn key <---------
username varchar(50) not null,
password varchar(50) not null

allways do this OMG | :OMG: