wujtehacjusz

hello guys, i wanted to write a query, or a view to be exact to display data from two tables as follow: 1. schedule_table (scheduleID as pk) 2. remarks (remarkID as pk, scheduleID as fk) meaning a schedule can contain many many remarks and non at all. now the problem …

hello frds, I m working on windows app in .net envirement with c#. I want to fetch large amount of data from a table and load it to my app. by dataset. but problem is, it unable to handle this or take a long time. My table have approx 10 …

Hello everybody, i'm a newbie to MSSQL - so excuse the newbie question. i am creating a page wich is hosted like any other page on a web server, i need to somehow connect to a MSSQL server , wich is located on a normal computer and connected to the …

Hi Guys, I have a text file which looks like this 123456 Amanda Morris and I would like it to look like this "123456","Amanda","Morris" The file has about 2000 lines how would I go about inserting the quotes and the commas. I use textpad to open the textfile and I …

Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before: [code]SELECT min(Parsed.Time), [Parsed.Number] FROM Parsed GROUP BY [Parsed.Rev Number] [/code]

hi i need to store data more than 8000 char in varchar in sql server 2000 how can i? plz help.

Hopefully this will be an easy one for someone. I am trying to write a SELECT statement that pulls the row with the least time for each Special Number. Example data would be: Time Special Number 3:25:00 1 3:26:00 1 3:25:30 2 3:26:30 2 The expected output would be: 3:25:00 …

[B]Is it possible in a query to delete a row specifying its row index?[/B] I want to delete a row from my table. I'm trying to figure this because when I delete rows from my datagridview, it does not update. So I was thinking if I just directly delete it …

Hello I seem to be having a problem, I have this query that pulls back correct results [CODE]SELECT hourStamp, SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage, SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday FROM webstats GROUP …

How to Delete top 5 rows from a table

Hi All, When I run the query: [B]select (100/50)[/B] It give me "2"... good. But when I run the query: [B]select (50/100)[/B] I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?

Hi everyone, I was wondering if anyone can recommend a good java ide. I have tried netbeans but i find it very confusing to use. I am looking for a very simple but free java ide to use. Can anyone recommend. Thank You Richard West

Hi! I have a problem with Dijkstar algorithm. At my university I was told that to use this algorithm I have to have: [LIST] [*]array of distances from starting node to all unreached nodes going only via node in set reached. [*]set of reached nodes (I pressume that it would …