the transaction log on a 10Mb database has shot up to 1G!, how can I reduce this and prevent this happening in the future....................more >>

Hello, I have a table (TAB) and A View with alias (VIEW) Table cod varchar 3 descr carchar 60 my view cod alias COd1 descr alias DES Now i need a index on view with key COD1 I can't create it. Can you help me Carlo ...more >>

I have an alias that can get very long because it maintains a information of where it came from. Is there a way to alias an alias? My first thought was: Declare @T1 varchar(128) Set T1 = 'MyAlias' .... Inner Join Table1 as @T1 This of course does not work. Is there way? ...more >>

This is propably a very simple question, but I can´t seem to find the answer to it in the documentation. I want to format a numeric field so the result is right justified and zero-filled. ex select 1 will give the result 01 How do I manage this simple task? -- best reguards fro...more >>

Sample table as follows Order ID Stock Code Status --------- ------- ------- 203 STK1 3 203 STK2 2 203 STK4 3 204 STK1 3 204 STK5 3 205 STK2 2 205 STK1 ...more >>

I have a table that has two fields, pkg_num, which is a number, and del_date_time, which is a date-time. The table can contain duplicate pkg_num values, as long as the del_date_time values are different for any given number. I need a query that will return the most recent del_date_time for ...more >>

Hi I am having an application with mssql7 standard as backend. Some times the entry screen is hanging and nobody can save data. I am using several mster tables like supplier,customer..etc At this time when i start opening a table ex:supplr_master in server it is showing an error "Microsoft o...more >>

Hi all, I'm trying to make this query: select count (distinct UC_CODE, SYNT, SUPER) FROM PLAN_RB WHERE HYPER IS NULL AND SUPER IS NOT NULL and I have this message: Incorrect syntax near ',' What I want to find is the total number of lines... Do you know a way to solve this problem...more >>

Hello ! Does nobody in which algorithm the LIKE and CHARINDEX function based. Is it meaningful to write itself search algoritms based on Knuth-Morris-Pratt or Boyer-Moore algoritms to replace LIKE on CHARINDEX functions for speed exhancement ? (I itself not belive) Is the some ways to spee...more >>

Hi, I need to make sure i do not open second transaction if one is already opened, i wanted to name a transaction, but how can i cjeck if a transaction with that name is already open? mndreu ...more >>

Hi all, I have some code that looks like below and after a few suggestions from a previous post I have tried passing it all through as variables but with no luck, has anyone else got any other ideas how I can speed this stored procedure up, all necessary tables have indexs???? Any help w...more >>

Hi Does anybody know what the difference is between the 'IN' and '=' operators. I am aware that '=' compares two expressions whereas 'IN' looks to see if an expression appears in a list and that a statement including an '=' operator is quicker to type than one with an 'IN'. Other than that ...more >>

How can I cross-tab the query it was simple in MS-Access but i don't know how to do it in SQL. the thing i want is as follows: Simple Query Item Year Qty A 1991 10 B 1991 15 C 1991 20 Cross-Tab Query (Items) ...more >>

I have a query where I am writing the following statement: select * from ...... where table1.field1 = table2.field2 ..... ..... ..... field2 is a varchar field and field1 is an int field. Field2 contains the data mapping data for field1 and also other unrelated data as character strin...more >>

Appreciate it if someone can show me how to copy table structure to a new table without the data using a query. Thanks. Beginner.....more >>

I want to pull the most recent record from 2 tables with a Union query. Here's what I thought would work: Select TOP 1 EntryTime, Windspeed, WindDirection, Temperature FROM BlackpoolWeather ORDER BY EntryTime Desc UNION Select TOP 1 EntryTime, Windspeed, WindDirection, Temperature FROM ...more >>

Hi, I would like to change the data output style generated from the SQL query. So, how can I go about doing it? Example : display 59766 as 59,766 and also datetime as date. Please help....thanks a lot! ...more >>

I need help typing to pull info out of a SMS database. We are selecting info from three table. we inner join the tables to get selected info out. where we are having trouble is by limiting what is returned. is there a way to say "if the row has a specific character(s) then the row will be ...more >>

I have a table with a varchar field that for the most part contains valid dates ie (mm/dd/yyyy). There are some items that are not dates. I would like a SQL statement that converts the varchar to a datetime and where there is an error for a particular field will return a null for that field....more >>