Search results for query: *

btw, I have to use the code and translate it to set the flags correctly. What I dont understand is how to match the row and column cells and create multiple records from each row/column.

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...

THIS IS NOT SQL ISNULL(). THIS CODE IS INSIDE OF AN EXPRESSION FOR A DERIVED COLUMN. THE FIX FOR THIS WAS TO USE A SCRIPT COMPONENT AND THEN USE .NET TO GET THE PIECE OF THE STRING I WANTED. THANKS FOR TAKING A LOOK EVERYONE.

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...

yes That is what we r finding. We are using CSharp to do the parsing currently but that is not working as expected, so we r looking to do it another way. we have a script component which calls a utility func written in C# and it cant handle the variety of data issues we are seeing.. ie...

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...

Sorry it took a while to get a post back here. I did get it to work and it runs SOOOOO much faster. Thansk for the helpful code. Once you implement it correctly it is simple. I have done this for over ten reports that took about 2-3 minutes to generate. with the new procedure they all come up in...

ok I did something alittle bit different and still cant get it right. I created a pass through query and called a stored procedure which I created on the sql server. It takes the county code as a parameter. it works fine when I hardcode it in the PTQ, however I need to get it from the user, via...

One further step along the patch... I created a function to do the query and set it equal to a record set. t'aint working yet though.. here is the code.. how do I bind my report to this function?? Public Sub RS_FromSQL() ' Comments: ' Dim dbs As DAO.Database Dim rst As...

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...

yes it makes perfect sense! I love your explanations!!! They are very helpful! works great too! thanks again! One question..Is using name like '% %' vs charindex going to affect performance? ie is using like... "fuzzy" logic? whereas charindex is straightforward

oops I get an error now hmmm! Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

thanks! I modified it a little so I wouldnt have a function to call but the logic I was looking for is there.. While (select CharIndex(' ', name) from raw1) > 0 begin update raw1 set name = Replace(name, ' ', ' ') end I see the likelihood of using this in future sources so Im going to...

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 tested this using sqlcmd instead of osql and it works great. Whatever the issue is is fixed in sqlcmd. Im thinking that the special character in this case is not being read correctly by the osql engine. Cant explain why but we have one sql 2000 server to convert. Once this happens Im changing...

Im thinking that the OSQL works is the issue. When the scripts are run they are calling stored procs which use osql to do the work. When I run them directly in mgmt studio they arent. Im recreating the stored procs to use sqlcmd instead and see if that works differently still. Not sure but it...

OK here goes. It must have something to do with the way the script gets called from the other script..OSQL??? When I changed the special character to Char(225) it works great! BTW, This data was being loaded from a tab delimited file which was generated from an excel spreadsheet. This file is...

Oops, sorry about that part. I have changed it to have the correct where clauses now. I am running it from mgmt studio. I have the main script open and run it. It has a call to execute the load script which is where the "problem" code is located. When it is run like this it doesnt work. The...