Search results for query: *

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!

I'm new to MySQL(meaning I've never seen or used it before). What I'm wondering is if you can take a backup file from a MySQL database and attach it to SQL Server and have an up and running copy of the database file? Can anyone out there answer this question or point me in the direction of...

Is there anyway in a SQL query to display the most recent fields submitted based on a datetime field? If so what is the proper syntax? Thanks!

Please help! I have a contact database that has basic contact info in it (approx 1200 records). Now I have found out that I need an ID number. Does anyone have any ideas on how to populate this field in a quick and easy way without have to run 1200 update statements??? Any help would be...

It's somewhat complicated....but I think we are going to try using views and see where we can get from there.

Here's the statement. There is a nested SQL statement in the order by: SELECT (strLName + ', ' + strFName) as name FROM UserInfo, LoginInfo WHERE UserInfo.strUserID = LoginInfo.strUserID AND strRights = 'user' AND (strUserStatus = 'active' OR strUserStatus = 'inactive') ORDER BY (SELECT...