Search results for query: *

I am trying to figure out how to get my header and left side of my pages in one file, and then include that file on multiple different pages. The problem is some of the links have been changing on me, and having to change a couple hundred pages everytime that happens is getting annoying. My...

The follow code is running across 1300+ records in a table, and may have 10-20 records in it. But it is taking 4 and a half minutes. Other stored procedures take like 10 seconds and have way more records (like 200K), and use the same structure. CREATE PROC dbo.kv_updt_RECIP_AUTH_ONWAY2IBM AS...

Hi, I am pretty new to HTML. I have a small website I run on my off time, and I also maintain one at work. There really is not much difficult for me to do at either. I want to set up a form that will allow users to type into a text box some text, and then to click on the submit button and to...

We had a salesman set up our SQL server a few years ago. He set up our production databases to unrestricted growth at 10% increase each time. The drive is almost full, and we have one DB that is 3 gig, and another that is 6 gig (on a 12 gig drive). There are a few other smaller DB's as well...

Hi, I have had some users enter social security numbers of 10 numbers instead of 9. I have since added an edit to the entry screen. However I want to find all these records so they can be corrected. I know there is data on the file of 10 numbers instead of 9. I tried this query, and got no...

We are running a Kovis system with our SQL Server. Kovis has its own DB with tables. Only select users(managers) can change certain data. One of our tables has the lookup data. One of those types got changed, and none of the managers remembers changing it. I need to track who did it, and...

In Cobol, and Magec I can Start a read on a file at a specific point, and read to a specific point. Is there a comparable way to do that in SQL? I can also kick out of the read loop if a record is found(and I know I only want to find one). Sample data from table: SECTION ENTRY...

I am thinking about allowing a user to run a query, so they can get the results whenever they want. Problem is, I do not want to give them Query Analyzer. Is there another way of allowing them to run a query? Can I run it from another program?

I am trying to get only a certain date from a field with a datetime stamp. When I look at the data in SQL Server I see: 8/9/2004 3:26:29 PM In the help files it says the format is: yyyy-mm-dd hh:mm:ss[.fff] I have tried ever format I can think of. SELECT * FROM [elvis].[EP3_14] WHERE...

I am not sure if this code is correct, so I am running it by ya'll. I only want to select records that have no data in ID_1010, or ID_1078. The catch is I want no records with ID_12 less than zero(seeings how that is records that have been deleted). SELECT ID_1006, ID_1007, ID_1015, ID_1002...

Code: UPDATE [TRUST].[dbo].[Export docs] SET Thousand=LEFT(ID2, 1), Folder=RIGHT(ID2, 1), Sub_Folder=RIGHT(ID2, 3) WHERE ID2 > 999 and ID2 < 10000 UPDATE [TRUST].[dbo].[Export docs] SET Sub_Folder=LEFT(Sub_Folder, 2) WHERE ID2 > 999 and ID2 < 10000 UPDATE [TRUST].[dbo].[Export...

DECLARE @v_pos_FirstNameStart INT DECLARE @v_pos_LastNameStart INT UPDATE [Pension Forms].[dbo].[XFRFUND10] SET @v_pos_LastNameStart= charindex(' ', MEMBERFULLNAME,1 ), LASTNAME=left(MEMBERFULLNAME, @v_pos_LastNameStart), @v_pos_FirstNameStart= charindex(' '...

I am getting unlimited emails from a cursor: DECLARE @EmailAddress varchar(50) DECLARE @Devid int DECLARE the_cursor CURSOR FOR SELECT EmailAddress, Devid FROM [Kovis_Data].[dbo].[Email_cache_full] WHERE EmailAddress IS NOT NULL OPEN the_cursor FETCH NEXT FROM the_cursor into...

Is it possible to use Microsoft SQL Server to email out file(s) as attachments? I would like to create a table that has multiple entries with the email address(es), and file(s) to be emailed out. I am just not sure if it is possible. I saw the email in the DTS; but have not used that a lot...

Here is my code: DELETE FROM [ENROLLMENT].[dbo].[Process] DECLARE @socnums varchar(25) DECLARE @doctype varchar(10) DECLARE @sigdate datetime DECLARE @fundnum varchar(10) DECLARE @create_date datetime DECLARE @memberno varchar(25) DECLARE the_cursor CURSOR FOR SELECT ID_1006, ID_1007...

Please bear with me. I am a Mainframe programmer by trade, who has been given a SQL server to work with. I am going to buy a SQL book tonight, and bring it work since we have none. I am trying to find a way to check a field for being not numeric. The guy who set up our database made...

The guy who designed our Microsoft SQL Server Databases, allowed datetime fields to be nulls. I ran across a record that had a null in it, and tried to create a query to determine how many records are like this. SELECT * FROM [elvis].[EP3_14] WHERE ID_1015=NULL This returns no rows at all...