Search results for query: *

In VB6 I have a designer report that needs to call some t-sql code to populate the report. The issue is that the t-sql code creates a recordset that pulls from 2 tables that are in separate databases each with their own security. I can run the code from the query analyzer and it returns the...

I have a table with the following columns: userid, ep When I run a simple select query I get something like this: userid ep us0123 mkt1 us4567 mkt2 us0123 mkt3 What I want is this: userid ep us0123 mkt1, mkt3 us4567 mkt2 I can't figure out how to do this...

I am creating a new text file from an existing one in DTS. Each record I read from the existing file needs to create 4 new records in the new text file with various changes depending on the record read. I haven't been able to determine how to write multiple records in the new file. Is the "Main...

OK, I'm stumped. I've been writing vb code for quite a while now and this is extremely easy code that is failing. Someone please tell me what I am missing here. Function Main() dim new_cc dim new_acct dim period period = mid(DTSSource("Col001"),1, 4) if period = 2003 Or period = 2004 then...

I'm trying to import an Excel spreadsheet into a table using DTS. The data I'm importing is a mix of text characters and numbers in Excel that I've formatted into text. When I import it to a SQL table I get values for the text, but NULLS for the numeric data. I am creating the field as nvarchar...

I am creating a text file from another text file and want to copy all the columns except one. This column needs to use it's value to lookup a value in a db that is mapped to the other value and replace it in the new file with the mapped value. I've never used the lookup functionality and can't...

I am building a combo box (drop down) on a html page and using js to dynamically populate it with a recordset. It has approx 5000 records and takes about 2 minutes to load. The code looks something like this: While (!rs.EOF) { frm1.cboCC.options[i] = new Options(rs("cost_cent") +...

OK, I'm new to ASP so give me a break, but I really don't understand how to get data (specifically db records) that I generate in ASP to client side vbscript. I need the ASP to create the records, but I can't get them into or make reference or anything to them in vbscript where I can use them...

I have an asp page that requests variables from a posting asp page. In the requesting page I am trying to call a function that is client side vbscript, but the asp code can't recognize it. How do I get it to see the function? Code is something like this: <% 'create SQL string from posting asp...

Is it possible for me to create a dropdown selection that a user will be able to make multiple selections rather that just a single selection? I'm using the HTML dropdown, but it appears to allow only a single selection value. I want it to allow as many selections as the user wants to pass this...

Anyone know what the code would look like to close the Database Window? I know you can do it with the startup utility, but I want it to be controlled by code.

Is there any script that can tell who has a particular file open on the network?

I have an Access 2000 db where I am trying to use the DTS functionality of SQL Server to run a DTS package. It works fine on my pc, I suppose because I have SQL Server on my machine. But when someone else trys to run the VBA module that runs the DTS.Execute function it won't work since they...

Is there a way to start Excel with or without a particular addin being loaded? Perhaps a command line like &quot;excel /l analysis toolpack&quot; for loading the addin on startup or &quot;excel /u analysis toolpack&quot; to not load the addin on startup

I've written a script for our intranet that queries a SQL server database for some data to populate a treeview. However when it runs it prompts the user to verify that if it is ok to &quot;access data across domains&quot; when in fact the SQL server it queries is on the same network domain...

I'm trying to create a view that has a case statement in it, but it is not allowing me...it says it is not supported. However there are other views in this db with case statements that work just fine. It seems it won't allow me to create a new one..anyone know why??

I have a view that has data similar to this: ID comp_sk comp_name 980 100792 sl14907 981.01 101539 s1595 981.01 150617 s1595 988 100870 s24442 I want to return only the first, third and last rows. I want to eliminate the duplicate 981.01 ID...I...

I have a view that returns data that looks like this: ID Comp_Sk 1 101 2 102 2 103 3 105 I want to return only the first, third and fourth rows. The duplicate record that has 102 as the Comp_Sk value of 102 should be eliminated from the select. I just want the...

I am trying to copy some date from one table to another where the first table has a field with varchar values (an example looks like this &quot;1,000.00&quot;) and I need it to go to a table that has a field that is money type. When I use the convert function I get the error &quot;Cannot convert...

In my DTS transformation, I am trying to use the contents of one of the other fields of my source table to determine the outcome of my destination field using a DTS lookup. I need to use the DTSSource(&quot;company&quot;) in the DTSDestination(&quot;company&quot;), but if another field in that...