Snap-in failed to initilize error on enterprise manager - Database Discussion Boards

Test27030729-Mar-07 0:16

29-Mar-07 0:16

i have a column named ReceiveDate..that is nvarchar.and have a row '27/03/2007'
when i run this statement that have some problems:

select * from tablea where
convert(datetime,OrderDate,101) >= (CONVERT(datetime,'26/03/2006',101)) AND
convert(datetime,OrderDate,101) <= (CONVERT(datetime,'27/04/2007',101))

pls any body can halp me?if possible give the correct select statement here.
thanks.

Re: convert datetime

Colin Angus Mackay29-Mar-07 0:47

Colin Angus Mackay

29-Mar-07 0:47

Test270307 wrote:
when i run this statement that have some problems

That's a bit vague. What sort of problems?

Test270307 wrote:
select * from tablea where
convert(datetime,OrderDate,101) >= (CONVERT(datetime,'26/03/2006',101)) AND
convert(datetime,OrderDate,101) <= (CONVERT(datetime,'27/04/2007',101))

Why are you doing all these conversions?

SELECT *
FROM TableA
WHERE OrderDate >= '2006-03-26'
AND OrderDate <= '2007-04-27'

When writing a date in SQL always use ISO format. That way you don't have to worry about cultural differences and your code will work anywhere.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

My website

Re: convert datetime

Test27030729-Mar-07 1:00

Test270307

29-Mar-07 1:00

sorry dear,
ur select statement does not return any rows.

in my select statement problems was:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

Re: convert datetime

Colin Angus Mackay29-Mar-07 3:16

Colin Angus Mackay

29-Mar-07 3:16

Test270307 wrote:
ur select statement does not return any rows

Then perhaps OrderDate was in an incorrect type. If you are going to store dates in the database then store them as a SMALLDATETIME or a DATETIME. Do not store them as anything else unless you have an exceptionally good reason.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

My website

Re: convert datetime

Krish - KP29-Mar-07 1:39

Krish - KP

29-Mar-07 1:39

convert function's style 101 represents mm/dd/yy

your dates are in the format dd/mm/yyyy
use 103 for the same like ....
select * from tablea where
convert(datetime,OrderDate,103) >= (CONVERT(datetime,'26/03/2006',103)) AND
convert(datetime,OrderDate,103) <= (CONVERT(datetime,'27/04/2007',103))

Regards
KP

Re: convert datetime

Test27030729-Mar-07 1:52

Test270307

29-Mar-07 1:52

yes.that works....thanx

Re: convert datetime

Chetan Patel29-Mar-07 21:00

Chetan Patel

29-Mar-07 21:00

1 101
U.S.
mm/dd/yyyy

2
102
ANSI
yy.mm.dd

3
103
British/French
dd/mm/yy

Best Regards,
Chetan Patel

Snap-in failed to initilize error on enterprise manager

mohd imran abdul aziz28-Mar-07 21:02

mohd imran abdul aziz

28-Mar-07 21:02

When you try to start Enterprise Manager of SQL server 2000, you get the following error message:

Snap-in failed to initialize.
Name: Not available
CLSID: {A841B6C2-7577-11D0-BB1F-00A0C922E79C}.

Earlier it was running perfectly alright. but for installing report service feature i upgrade sql2000 with service pack 3. after running setupsql.exe . it was shwing message like you should now backup your master and msdb database since this installation has update their content.

please help

thanks

regards
imran khan

Duplicate records

Sophia Rekhi28-Mar-07 18:55

Sophia Rekhi

28-Mar-07 18:55

Hi all,

How to delete duplicate Records in a table in SQLSERVER.

Re: Duplicate records

jijoaresseriljose28-Mar-07 21:33

jijoaresseriljose

28-Mar-07 21:33

hi,
suppose col001 of table1 is the duplicated values.then the query
"select col001 from table1 group by col001 having count(col001)>1" will get all the
duplicate values so,

the below query will delete all the duplicated records.

"delete from table1
where col001 in (
select col001 from table1 group by col001 having count(col001)>1)"

regards
Jijo

jijo jose

Re: Duplicate records

Sophia Rekhi28-Mar-07 23:10

Sophia Rekhi

28-Mar-07 23:10

Hi jijo jose,

Thanks for your response, but your solution deletes all records which are duplicate.even table does n't contain one value.

i want only delete duplicated records other than first value'
ex:
Sample Table Contains records are
sno sname
10 XXX
10 XXX
10 XXX
20 YYY
20 YYY

But after deletion of duplicate records i want records in table like this : sno sname
10 XXX
20 YYY

Re: Duplicate records

Krish - KP29-Mar-07 1:46

Krish - KP

29-Mar-07 1:46

in continuation to my earlier solution....

select * from tblA where newcol IN (select min(newcol) from tblA group by sno having count(*) > 1)
should give first occurance of the each duplicate row.

Note :
newcol is the new identity colum

Regards
KP

Re: Duplicate records [modified]

jijoaresseriljose29-Mar-07 3:31

jijoaresseriljose

29-Mar-07 3:31

hi,
I thought, you wanted to delete all the dubplicated one including original,
Then do this in your query analyser.........

1 st step
----------
alter table table1 add [id] int identity

2nd step
----------
delete from table1
where [id]
not in
(select min([id]) from table1 group by col001)

it will delete all the duplicate records from table1

regards
Jijo Roll eyes | :rolleyes:

-- modified at 9:36 Thursday 29th March, 2007

jijo jose

Re: Duplicate records

Krish - KP28-Mar-07 21:37

Krish - KP

28-Mar-07 21:37

Add new column to the table and make it IDENTITY
so that each row can be identified Uniquely.

Regards
KP

Re: Duplicate records

one_stone_zz28-Mar-07 23:21

one_stone_zz

28-Mar-07 23:21

You can use the temp table, put the only exist records into the temp table then you can delete the original table's records use the condition with the information of the temp table.

onestone

how do i Decryption Store Procedure ...?

PavanPareta28-Mar-07 3:50

PavanPareta

28-Mar-07 3:50

I have write a Strore Procedure with Encryption.

for Exmaple

alter Proc GetAll
with encryption 
as
select * from test1

after completing SP Encryption.

I am not able to again modify My Store Procedure.
please help me.

Pavan Pareta

Re: how do i Decryption Store Procedure ...?

Pete O'Hanlon28-Mar-07 4:36

Pete O'Hanlon

28-Mar-07 4:36

Try this link http://www.sql-shield.com/sql2k_spcrypto.txt[^]

Deja View - the feeling that you've seen this post before.

Re: how do i Decryption Store Procedure ...?

N a v a n e e t h28-Mar-07 22:38

N a v a n e e t h

28-Mar-07 22:38

Pavan_pareta wrote:
I am not able to again modify My Store Procedure.
please help me.

Once encrypted you can't view it.

http://www.w3hearts.com/articles/6/[^]

Check the link

printf("Navaneeth!!")

www.w3hearts.com

Re: how do i Decryption Store Procedure ...?

Pete O'Hanlon29-Mar-07 5:12

Pete O'Hanlon

29-Mar-07 5:12

This is the accepted wisdom, but as with a lot of things that are accepted wisdom, it's not always true. Take a quick search on Google for decrypt Sql Server procedure, and you get numerous hits - some of which tell you how to decrypt procs. I've provided a link to one above.

Deja View - the feeling that you've seen this post before.

Self referential join

Johnny ²28-Mar-07 3:06

Johnny ²

28-Mar-07 3:06

I have a table with a parent-child relationship in a MySQL database:

id
parent_id - points to id
other columns

I can easily extract all rows belonging to a particular parent. For example:

SELECT * FROM table WHERE parent_id=5

What I'm trying to do is extend this to not only get all rows belonging to a particular parent, but also get a count of each row's children (the grandchildren). I don't need any further generations. Other than retrieving the children and iterating through the rows and fetching the counts seperatley, I've been getting into a good muddle with joins and self-referential joins.

I'm hoping that some kind soul has a few suggestions!

Re: Self referential join

DQNOK28-Mar-07 3:32

DQNOK

28-Mar-07 3:32

This seems to work on my system (not MySQL).

SELECT * , (SELECT COUNT(*) FROM tblTasks WHERE parentTaskID=T.taskID)
FROM tblTasks AS T
WHERE T.parentTaskID=5;

Don't know whether MySQL will support the (SELECT ...).

Hope this helps.

Re: Self referential join

Johnny ²28-Mar-07 17:04

Johnny ²

28-Mar-07 17:04

That is perfect, thank you! And a whole lot simpler than my left joins

Job

Navneet Hegde28-Mar-07 2:33

Navneet Hegde

28-Mar-07 2:33

hello All dear,
I want to create job which sends email every 10 minute by retreiving fldEmail[email id] from table.

Develop2Program & Program2Develop

Re: Job