Recent content by lah3233

I did mean T-SQL - sorry for the confusion

I have a database with 12 fields. When I select my data - I would like it to appear back like this: 1, 2, 3, 4 /N, 5, 6, 7, 8 /N, 9, 10, 11, 12 /N I would like a /N appended to every fourth item - and like to have it returned as a single field. Is there a simple way to do this using a PL/SQL...

SleepingSand, Nevermind - I forgot to change my projectID in one location. It's working flawlessly. Thanks for all your help!!

SleepingSand Thanks for the help. The only issue I'm having is that there can be any number of consultants on a particular project. For example, in my database I have 3 consultants tied to a project, but it will only pull out two of them. How can I modify it to pull any given number of...

Hi! I've got a SQL Statement that looks like this: SELECT project.strprojectid, strprojecttitle, dtDueDate, strProjectStatus, strConsultantName FROM project, projectConsultant, Consultant WHERE project.strProjectID = '9jjx1ujn4sa' AND project.strProjectID = ProjectConsultant.strProjectID AND...

I have never worked with functions before and this is the errors I am getting back Server: Msg 170, Level 15, State 1, Procedure GetConsultants, Line 3 Line 3: Incorrect syntax near 'strProjectID'. Server: Msg 178, Level 15, State 1, Procedure GetConsultants, Line 16 A RETURN statement with a...

Where do I declare @Project_ID?

How do I go about doing that?

Hi! I've got a SQL Statement that looks like this: SELECT project.strprojectid, strprojecttitle, dtDueDate, strProjectStatus, strConsultantName FROM project, projectConsultant, Consultant WHERE project.strProjectID = '9jjx1ujn4sa' AND project.strProjectID = ProjectConsultant.strProjectID AND...

Hi Mary I ended up manually recreating table structures and then doing a dump to get the data moved over to SQL Server. DTS would not work for me as I didn't have the credentials that were needed to get into out client's MySQL database. Let me know if you have any further questions.

Does anyone out there know a quick and effective way to migrate the structure and data from a MySQL database to a SQL Server database? I would appreciate any help I can get. Thanks!

What is the easiest way to move data/table structure from an XML file into a SQL Server database? Is there a way to do it w/o manually creating the tables? Thanks!

Can you take a look at this link and tell me if something like this would be effective? http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/mysql.asp I have never actually seen and/or used MySQL before - we just need to transfer the database...

Can anyone out there tell me the proper steps to take to migrate a MySQL database to SQL Server?? We do not have MySQL in-house...we will have to access the database remotely using the MyODBC connector. Thanks!

What I mean is if you back up the entire database as you would in SQL Server. Then can you take the .mdf file and import it into a SQL Server database? Or what is the proper steps to take to migrate a MySQL database to SQL Server?? Thanks!