|
Have you tried:
...<br />
GROUP BY<br />
CAST(tc.TXT_CTR_NUMERO_SGF AS varchar(8000),... ?
|
|
|
|
|
Actually did, well the convert, but didn't seem to recognize it in group clause.
I did find a solution though by breaking it into parts. Seems like when you have an agragate function inside a sp, the grouping part gets very picky, so I left for more experts
|
|
|
|
|
Interesting, I never thought of doing that before. I've always known you can't group by ntext and image fields but never considered casting it like that, just coded around it.
|
|
|
|
|
Hello everyone !!!
I want to migrate SQL Server 2000 database onto SQL Server 2005 database.
The original SQL Server 2000 database tables contain some Japanese characters and I need to
transfer them as well to SQL Server 2005 database.
For this purpose I have done following things.
1. Exported all tables data to a excel sheet. (by choosing Microsoft Excel 97/2000)
2. But when I try to import this data to SQL server 2005 I am getting following error
It verifies it. (error)
Message
Error 0xc02020f6: data flow task: The character-string data type of the Unicode form and the character-string data types of the form other than Unicode cannot be converted by the row "Description".
(SQL Server import and export wizard)
Error 0xc004706b: "Component" conversion of the data flow task ahead- tblCMSTypeMaster "(26)" failed in the verification, and the verification state "VS_ISBROKEN" was returned.
(SQL Server import and export wizard)
Error 0xc004700c: data flow task: It failed in the verification because of one or more
components.
(SQL Server import and export wizard)
Error 0xc0024107: data flow task: The error occurred while verifying the task.
(SQL Server import and export wizard)
I guess this problem is related to importing of Japanese characters.
I am stuck with this problem. Any solution/suggestion on this issue is greatly appreciated.
Thanks in advance.
Thanks & regards,
Vaibhav
|
|
|
|
|
Hi all
i have a table Student
id FName LName
-----------------------------
1 Rahit singh
2 Mohit null
3 Sanjay malhotra
4 Pankaj null
i want a sql query which will return the following layout
id Name
-----------------------------
1 Rahit singh
2 Mohit NA
3 Sanjay Malhotra
4 Pankaj NA
please any one help me
thanks in advance...
thanks n regards,
Srinandan
|
|
|
|
|
Hi srinandan,
which dialect of sql are you using exactly, because you have to write a case-statement I think to get this done with NA...
e.g. for Sybase:
<br />
SELECT id, (FName + ' ' + (CASE WHEN (LNAME is null) THEN 'NA' ELSE LNAME END)) AS NAME <br />
FROM Student order by name<br />
(For Sybase there is also a function named IsNull to perform a null check with an assignment of a default value if the tested one is null)
Hope this helps you a bit,
regards
Sebastian
|
|
|
|
|
Thanks a lot to you Sebastian,
you have solve my problem.
thanks n regard,
srinandan
|
|
|
|
|
Though I might be asking a very foolish question, but it's important for me to know what's the current trend and the reason for that.
My question is-----
What is better-----
1. Tables with relations (pk and fks created through script during design time) maintained at the DB.
2. Tables without relations(pk and fks) should be maintained at the DB and accessed with appropriate query as and when needed?
Please some one help me with this.....I heard that the 2nd method is the current trend...if it is so then why is it?
|
|
|
|
|
kamalika_kk wrote: 1. Tables with relations (pk and fks created through script during design time) maintained at the DB.
2. Tables without relations(pk and fks) should be maintained at the DB and accessed with appropriate query as and when needed?
All your tables should have a primary key.
If you have related tables then they should have foreign keys.
kamalika_kk wrote: I heard that the 2nd method is the current trend...if it is so then why is it?
That is news to me.
|
|
|
|
|
Colin Angus Mackay wrote: kamalika_kk wrote:
I heard that the 2nd method is the current trend...if it is so then why is it?
That is news to me.
Same here. Haven't even considered using tables with out relations. Any data model I've worked with has some kind of relationship between entities.
That's no moon, it's a space station. - Obi-wan Kenobi
|
|
|
|
|
a service control operation failed for the mssqlserver service :2
the system cannot find the file specified
can you help fast pls
|
|
|
|
|
plz see sqlsetup.log for detail information in %windows% folder.
|
|
|
|
|
i want to make sql statment that use mod % Div /
i have tow colum
tt | time
---------
1 | 1
2 | 2
3 | 9
i want to make list for all record if (time % 5 = 0)
* how can make this
Palestine
|
|
|
|
|
SELECT * FROM MyTableName WHERE time % 5 = 0
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
I have three salesmen out on the road demonstrating our latest product on their laptops - an asp.net (1.1) application installed locally on their machine that talks to a SQL Server database instance also installed on their machine.(MSDE 2000)
I would like to send upgrades to them and make the process as simple as possible for them (I can't sell - they can't program!). Carrying out the upgrade via one click would be ideal.
The updates could be anything from appending a single stored procedure to creating new tables etc.
Can anyone suggest a good way of doing this?
Many thanks in advance.
MJ
|
|
|
|
|
I'd write a little .NET exe that has all sql database updates within it. Have a field in a table that keeps track of the database version number. In your little DBUpdate.exe, first thing you do is check the version of their database (If the table or field you keep the version number in isn't there, then you know to start at the beginning...and create the table or field). Then, just run through the updates that are less than their database version number, and update their database version number as you go.
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
how to execute tow procedure in one procedure
his job is to add data
|
|
|
|
|
exec <sp_name>
A quick google returns this example[^].
|
|
|
|
|
help me to sort out this problem
i had taken a date time picker and changing the format to dd/mm/yy
sdf
|
|
|
|
|
|
bpavan_2 wrote: help me to sort out this problem
i had taken a date time picker and changing the format to dd/mm/yy
Are you wanting to do this in .NET code or in SQL.
In .NET you'll need to use the ParseExact method of the DateTime class[^]
|
|
|
|
|
If you use SqlCommand with parameters..This an solve alot of problems like formats and sql injection.
|
|
|
|
|
Assume that I have two tables in my database,one is Catgeory and the other is Item.These tables are related; Items can belong to categories. I want to have a business class for categories that represent a record in the category table. I also want this class to contain all information about items belonging to the category. My question is which class is suitable for storing the list for items information.(e.g. Collection,ArrayList,...).I fetch item records in my Data layer as a DataSet. Please show me how I can place data contained in DataSet to the class you think is suitable(e.g. Collection).I need to use this help me please
Hope you undrestand.
|
|
|
|
|
With .net 2.0 and generics..I would use List<Item>
In .net 1.1 I make a class that inherits CollectionBase as a specialized collection for Items.
Also I fill the collection using a datareader not a dataset..This should be faster.
|
|
|
|
|
Have you managed with this??
I also had a similar problem an no-one helped on any where so I tried fixing this myself, and it is working so far.
It's a very confusing subject, and you have to "study" to understand, I don't fully understand the concept, but what I am doing works so far.
I can send you screen shots of my code if you like.
Regards
Brendan
brcvogt@yahoo.com
|
|
|
|