I am migrating a student database from Access to SQL Server. In Access I have a query that displays grade information (grades are calculated on a 12-point scale). In the query I average the students' scores and store it in a column called Avg. I look up and display the equivalent grade letter using Access' […]
2005-02-16
271 reads
Hello,I am importing data from a TEXT file into SQL Server 2000 table. The destination table in SQL Server has an ID column with Uniqueidentifier data type, which is GUID and needs to be populated using SQL Server function NEWID(). Now, I am importing data from the text file, which has other data, but no […]
2005-02-14
18 reads
Hi Phill,Thanks for prompt reply... Actually Pls. find the the whole procedure... In which i am 1st import a text file. Then i have to Fetch the Table name from this file along with Column. And then insert into DB. Pls. find the whole procedure... for uor refrenceCreate PROC Sp_EnterTextFile @filename sysname as BEGIN SET […]
2005-02-03
Thanks for the pointer, Greg. I'll let my DBA know what you suggest and update my query accordingly.Thanks also to all those who have taken the trouble to have a look at my problem - it's reassuring to know that we techies support each other where and when we can. Simon
2005-01-28
I am currently experiencing some problems using the database role of dbo_ddladmin in SQL2K. I am adding an NT user group/ad group to the ddladmin role and the users are telling not only can they not add new objects they can't even do a simple select statement. I am not too familiar with SQL2K but […]
2005-01-21
2 reads
CurtisThere are several versions of Reporting Services - Standard, Enterprise, Developer - you need to install the version that matches your version of SQL Server. If you're running XP then you need the Developer version.
2005-01-21
1 reads
According to this page, http://users.spark.net.gr/~yiapap/bldiagra.htm, seems that it is caused by ADO 2.8. I haven't tried it yet.
2005-01-21
Hello. Kriss,If i correct understood Your problem (You need to remove the owner of the table), You need to change the object owner with sp_changeobjectowner
2005-01-21
1 reads
Hi all, Thanks for the suggestions. I'm trying to use s.m.b's idea. I have loaded all the data into a temp table as a single column. Now my question is, Is there a way to find the number of occurences of ',' in the string column? In that way I can find the records with […]
2005-01-19
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-01-19
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers