Search results for query: *

I have a spreadsheet with row 1 set to role_id Column a is screen_id the cells have a code where they meet. see below. A B C 123 122 Scr1 A D Scr2 S A I need to create rows in a database that look like below Role Screen Display Edit Add 123...

I am trying to create a derived column to concatenate a few fields together. The first field should ony contain all of the characters beginning with the 3rd character... ie Right(colA, len(colA)-2) The following syntax is throwing an error and I cant figure out what is wrong... The fields do...

We have several clients whos send us flat files comma seperated .csv files. These files may have text qualifiers around the text fields (") . the problem we r having is the parsing of these rows dont always come out correct. We have gotten to the point to try and use excel to parse the fields...

Not sure if this is the correct forum for this but.... We have several clients whos send us flat files comma seperated .csv files. These files may have text qualifiers around the text fields (") . the problem we r having is the parsing of these rows dont always come out correct. We have gotten...

I need to generate a report in access using dynamic sql. The user will be prompted to enter a county name when generating the report. I need to use this county name to drive which database and table I will be using to retrieve the dataset from. the sql version of this query is as follows. note...

Im new to SSIS and cant figure out the best way to do a merge/join when there is no column that I can do a straight map on between them. I need to join TWO DATASETs in ssis where column_A in the first dataset is in column_B in the second dataset. and Column_B is delimited with a |(pipe). the...

I have data in name fields like 'John Doe MD' . I need to remove all spaces except one where they exist. I know I can do several replace statements one after another. But I dont know how many spaces exist and cant get my while loop to work right. can someone give me a quick loop to...

I need to replace some special characters in a name field. Im pretty sure my syntax is correct because it works when I run it by itself. However when I run the whole procedure it doesnt update. the code is below.. this is part of a larger proc that is called as part of 10 steps. One .sql file is...

I have ran into an error that I cant figure out. We recently moved our data from 2000 to 2005 servers. We use actuate as a reporting platform and run reports from a server off site against our sql2005 servers here. When I changed the data source for a report to test we get an error. 7405: [SQL...

Posted before but didnt get help yet...Trying this another way... I have a VB 6.0 app using access 2003 database. This app resynchs their laptops to the master database on a machine in their office.. They use when they leave the office to copy the dbase locally to the laptop and then point the...

I have a VB 6.0 app using access 2000 database. This app resynchs their laptops to the master database on a machine in their office.. They use when they leave the office to copy the dbase locally to the laptop and then point the odbc connection for the app to the copied database... c:\...

I have a VB 6.0 app using access 2000 database. This app resynchs their laptops to the master database on a machine in their office.. They use when they leave the office to copy the dbase locally to the laptop and then point the odbc connection for the app to the copied database... c:\...

I have a set of codes with text descriptions that relate to the code. This description has the potential to have multiple values in the table. ie when I do a select distinct code, value I get multiple text descriptions for each code. I want to loop through the records and combine the...

I have a query that has a subselect from another server in the join logic. See below. This query wont run due to an error saying that table ef is not a table in the query..???? Does anyone know of a problem with this type of logic? It runs find when all of the tables are on the same server...

I have an excel spreadsheet that has around 1000 rows. Most of these rows will contain nothing of value to my task. ~ 30 will and I only want to keep those 30. I know I can find rows based on some criteria. But I would like to use the list of keys for the rows I want to keep, and delete all of...

Does anyone know why a query formatted perfectly in SQL Query analyzer would look different in SQL 2005 Studio. I verified same font and tabs are set to 8 in both. Tabs are tabs and not spaces in both. Yet the layout in 2005 is messed up, not unuseable, but not lined up like we want either. Is...

I have a table with a column witha 30 char array. This field contains UP TO 15 2 char codes stored in it. I also have a SSN and a certnum field for keys. I need to break up this one to many relationship into another table. Has anyone pased a filed and then done an insert into another table for...

I do a lot of data mining and use SQL 2000 and the 2005 tools(we are upgrading currently). I have found that when exporting a resulting dataset to a file delimited by ANYTHING in SQL 2005, it embeds chars in the output. I have output to column alligned and tried to import to a SAS tool. It...

We have been experiencing an issue with crystal 8 that is really beginning to bug me. We have an ASP.net app that has several crystal reports. we use the viewer to preview and print the reports. they all work fine for a while and then abra cadabra, they start giving us the following error...

I have moved a database access 2003 to a new server. I access this through an application written in vb 6.0. The users were using a local copy of this database on the C drive of their laptops. I created a new odbc connection pointing to the dbase on the network S: drive. I can read data into my...