Database

Re: How to set up an SQL Server

9-Sep-08 10:31

You might want to have a look at this http://www.codeproject.com/script/Forums/View.aspx?fid=1725&select=2681821&fr=616#xx2681821xx[^]

bhatted11-Sep-08 9:46

bhatted

11-Sep-08 9:46

hi,

It's giving warning that
The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

My Ram is 256MB.IT's need 512MB.so what should i do.

IF you have any website where i can load sql server 2002.

Thanks

SQL Serevr Agent 2005

Saiyed Alam9-Sep-08 5:32

Saiyed Alam

9-Sep-08 5:32

Hello friends may I know how to activate the SQL Server Agent of SQL Server 2005?

Re: SQL Serevr Agent 2005

Wendelius9-Sep-08 5:38

Re: SQL Serevr Agent 2005

9-Sep-08 5:38

Did you read my previous answer http://www.codeproject.com/script/Forums/View.aspx?fid=1725&select=2714087#xx2714087xx[^] Confused | :confused:

Blue_Boy9-Sep-08 5:55

Blue_Boy

9-Sep-08 5:55

Try a google search[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Select cellection of bit fields if is true ??

kindman_nb9-Sep-08 4:18

kindman_nb

9-Sep-08 4:18

Hi ...
I have a table for eg called Forms (fid int , Read bit , Add bit , Del bit )
the problem that more than one row with the same Form like that :

fid - Read - Add - Del
2 - True - True - False
2 - True - False - False
2 - True - False - True

you can see that the form takes Add True and False in second row

.. I want to select only one row but if I have Add col has two value True and False in another row then select True to be :
2 - True - True - True

I'm using Sql server 2005 ,, can I create stored procedure do that ...

really thanks ...

jooooo

Manas Bhardwaj9-Sep-08 4:38

Manas Bhardwaj

9-Sep-08 4:38

kindman_nb wrote:
.. I want to select only one row but if I have Add col has two value True and False in another row then select True to be :
2 - True - True - True

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Blue_Boy9-Sep-08 4:48

Blue_Boy

9-Sep-08 4:48

Can you be more descriptive in your question?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Wendelius9-Sep-08 7:58

9-Sep-08 7:58

You can create a stored procedure and handle this inside the procedure. However, your problem is in modelling. You should break the table to at least two table. Separate table for Forms and separate table for allowed operations. This way you can query what operations are allowed and those that are not allowed, are not listed.

Mika

PIEBALDconsult9-Sep-08 9:21

PIEBALDconsult

9-Sep-08 9:21

Not sure what you mean, do you mean something like this?:

select fid,max(cast([read] as int)),max(cast([add] as int)),max(cast([del] as int)) from Forms group by fid

kindman_nb9-Sep-08 13:43

kindman_nb

9-Sep-08 13:43

Thanks my friend ..
what I mean that for eg ..
I have users . every user is subscribe in group and every group has it's permission Read and Add and Del of all forms ...

user A is subscribe in Group M and N
for eg : customer form :
Group M Read true - Add True - Del False
Group N Read true - Add False - Del False

then i want to select the permission of the user a from the table of permestoin ..
you can see that the user has Add is true in group M and the same user has Add is false in group N
i want to select True if i hase true or false of the same permissoin ..
i hope if you see what mean

jooooo

Paradox to Sql Server Database

PIEBALDconsult9-Sep-08 14:12

PIEBALDconsult

9-Sep-08 14:12

Ah, OK, well what I posted should help.

TheEagle9-Sep-08 2:23

TheEagle

9-Sep-08 2:23

Hi,
I have paradox database files which I need to migrate to SQL server database.I used the DTS and DataSources(ODBC) but I find the first selection :copy data from one or more tables disabled so I must use a sql query.But I don't know the tables names in the Paradox database files so What kind of query could I use?

I am too late but i will never give up

Re: Paradox to Sql Server Database

User 17164929-Sep-08 4:39

User 1716492

9-Sep-08 4:39

Have a look at see if this may help Paradox viewer 1.87[^]

modified 1-Aug-19 21:02pm.

datediff problem

imranafsari8-Sep-08 23:38

imranafsari

8-Sep-08 23:38

Hi,
I am using sql server 2005.
When I am finding difference between two date I am getting one day less
For example
select datediff(d , '2008-09-01' , '2008-09-05')
I am getting 4 days I want it to be five day as 1,2,3,4,5 that is it should start from date to todate

How can I do it

Please help
Thank you

imran khan

ChandraRam9-Sep-08 0:08

ChandraRam

9-Sep-08 0:08

Add 1 to the result.

DateDiff gives you the interval between the two dates.

Manas Bhardwaj9-Sep-08 0:21

Manas Bhardwaj

9-Sep-08 0:21

imranafsari wrote:
select datediff(d , '2008-09-01' , '2008-09-05')

5 - 1 = 4
Seems ok to me...add 1 to get your desired result.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Blue_Boy9-Sep-08 3:25

Blue_Boy

9-Sep-08 3:25

select datediff(d , '2008-09-01' , '2008-09-05')+1

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

SQL Query to find Timedifference between 2 items whose ID is same but different Status

nelsonpaixao9-Sep-08 14:19

nelsonpaixao

9-Sep-08 14:19

let it be

nelsonpaixao@yahoo.com.br

trying to help & get help

DrukenProgrammer8-Sep-08 9:21

DrukenProgrammer

8-Sep-08 9:21

Hello Experts,
I have my data like below,
ID Fname Date_TimeWorked Status
1 MyName 2006-10-25 10:00:05 Ready
1 MYName 2006-10-25 11:00:05 Completed
1 MyName 2006-10-25 10:30:00
I want to know the time difference Between Ready-completed, ready-canceled.

How do I query this? Its urgent. Thanks in advance!!

Re: SQL Query to find Timedifference between 2 items whose ID is same but different Status

Wendelius8-Sep-08 9:28

Re: SQL Query to find Timedifference between 2 items whose ID is same but different Status

8-Sep-08 9:28

For example:

SELECT DATEDIFF(minute, start.Date_TimeWorked, end.Date_TimeWorked) AS ElapsedMinutes
FROM TableName start,
     TableName end
WHERE start.ID = end.ID
AND   start.Status = 'Ready'
AND   end.Status = 'Completed'

Mika

DrukenProgrammer8-Sep-08 9:39

DrukenProgrammer

8-Sep-08 9:39

I have this in one table, what is TableName start,TableName end?

Thank you

Re: SQL Query to find Timedifference between 2 items whose ID is same but different Status

Wendelius8-Sep-08 9:46