Re: MSSQL: How to check if selected string has specific letters on specific places??? Please help... - Database Discussion Boards

dabuskol21-Jul-09 20:18

21-Jul-09 20:18

Hi,

I have a table with 2,000,000 records and there is no way for me to filter it by range.
I was able to get the first 1,000,000, my problem is to get the next 1,000,000 without any duplicates from the first 1M records. Any Idea.

SELECT TOP 1000000 * from Table1

how about the next 1M??

Pls..

Dabsukol

Re: How to get the next 1,000,000 records

Satish - Developer22-Jul-09 1:46

Satish - Developer

22-Jul-09 1:46

Select top 1000000 colname from
(
Select top 2000000 colname from urtable order by colname desc
) T
order by colname asc

G. Satish

Re: How to get the next 1,000,000 records

zahedonline22-Jul-09 21:34

zahedonline

22-Jul-09 21:34

In short

For First 1000000
Select top 1000000 colname from urtable order by colname ASC

For Next 1000000
Select top 1000000 colname from urtable order by colname DESC

ZAK

Re: How to get the next 1,000,000 records

Mycroft Holmes23-Jul-09 1:06

Mycroft Holmes

23-Jul-09 1:06

Oops just added another record - this is a Microsoft answer, technically correct practically useless.

Never underestimate the power of human stupidity
RAH

Re: How to get the next 1,000,000 records

Mycroft Holmes23-Jul-09 1:09

Mycroft Holmes

23-Jul-09 1:09

Select top 1m records order by ID
Get the last ID in the first set (you do have an ID field)
Select the top 1m records where ID > last ID

You can also look into Row_Number in SQL Server, this will eliminate the detect requirement but is more complex in the select. I would assume you are processing the 1m records and therefore detecting the last ID would be trivial.

Never underestimate the power of human stupidity
RAH

How to add trigger function into PostgreSQL 8.0?

valeranavin21-Jul-09 20:17

valeranavin

21-Jul-09 20:17

I am using postgreSQL 8.0 (pgAdmin III). Whenever I create a trigger, an error "There is no in-built function 'funtion name'".

What the actual problem is with the trigger or postgresql?

Please send me the solution..

Thank u.

MSSQL: How to check if selected string has specific letters on specific places??? Please help...

Magnat7421-Jul-09 10:19

Magnat74

21-Jul-09 10:19

Hey,

I want to access letters in strings selected from DB.

I would like to do something like that:

SELECT word FROM dictionary 
WHERE 

-- and now the pseudo-code part:

word[0] is in {'a','e','o','u','y'} 
AND word[1] is in {'b','c','d'}

where word[0] means first letter in selected word, word[1] second letter etc.

Is it possible to do in MS SQL?

Re: MSSQL: How to check if selected string has specific letters on specific places??? Please help...

David Mujica21-Jul-09 10:43

David Mujica

21-Jul-09 10:43

Look into CHARINDEX and SUBSTRING

pseudo code ...

IF (CHARINDEX(SUBSTRING(WORD,1,1),'aeiou',1) > 1) then
  found it
End if

Re: MSSQL: How to check if selected string has specific letters on specific places??? Please help...

Magnat7421-Jul-09 10:49

Magnat74

21-Jul-09 10:49

big thanks!!! I haven't test it yet but it seems to be the solution Smile | :)

Re: MSSQL: How to check if selected string has specific letters on specific places??? Please help...

WoutL21-Jul-09 20:42

WoutL

21-Jul-09 20:42

You should use the Like keyword:

select word from dictionary
where word like '[aeouy][bcd]%'

Wout Louwers

cool use of "like"

David Mujica22-Jul-09 10:17

David Mujica

22-Jul-09 10:17

Wow ! That is a neat way of using the "like" comparison. I like it! Laugh | :laugh:

Re: MSSQL: How to check if selected string has specific letters on specific places??? Please help...

Blue_Boy22-Jul-09 11:33

Blue_Boy

22-Jul-09 11:33

You got my 5.

Briliant.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

copying the whole table from one server to another server [modified]

venu65621-Jul-09 6:13

venu656

21-Jul-09 6:13

Hi Experts

iam having two sqlservers .where i want to move entire table from the server1 database with the data to anothers server(server2) datbase using query .plz guide me......

regards
venu

modified on Friday, July 24, 2009 5:55 AM

Re: copuing the whole table from one server to another server

DoctorMick21-Jul-09 6:24

DoctorMick

21-Jul-09 6:24

You could use SSIS or linked servers.

Re: copying the whole table from one server to another server

venu65621-Jul-09 6:28

venu656

21-Jul-09 6:28

i know using linked servers but using query i shuld get it becoz this query is used in c#..... to execute so many tables ...

Re: copying the whole table from one server to another server

Robin_Roy21-Jul-09 17:56

Robin_Roy

21-Jul-09 17:56

Hey Venu,

Please elaborate a bit more on what exactly are you looking for inside your C# code.
Are you trying to transfer data between different databases having identical schema from inside your C# code or you want to query different database at the same time???

Robin

Re: copying the whole table from one server to another server

venu65621-Jul-09 18:26

venu656

21-Jul-09 18:26

hi robin.
actual i want to transfer the entire table structure along with datafrom local sqlserver to hosting sqlserver using c#

Re: copying the whole table from one server to another server

Mycroft Holmes21-Jul-09 19:39

Mycroft Holmes

21-Jul-09 19:39

This is usually achieved by backing up the local database and restoring it on the host.

Additionaly you can script the database and uses SSIS to move the data

Or use SQL Compare from http://www.red-gate.com/index.htm?gclid=CLDSwcDM6JsCFcItpAod-kAU5Q to move the code and Data Compare to move the data. This is what I use.

Never underestimate the power of human stupidity
RAH

Re: copuing the whole table from one server to another server

icanmakeiteasy21-Jul-09 19:32

icanmakeiteasy

21-Jul-09 19:32

hi venu,

server1 database structure is static or dynamic??

icanmakeiteasy

Re: copuing the whole table from one server to another server

venu65621-Jul-09 19:37

venu656

21-Jul-09 19:37

Server1 is static server

Re: copuing the whole table from one server to another server

icanmakeiteasy21-Jul-09 19:50

icanmakeiteasy

21-Jul-09 19:50

then if the table structure is static create a script file for server1 database.., read that file from c#, then manipulate it...

icanmakeiteasy

command to find specific value in select

dabuskol21-Jul-09 1:58

dabuskol

21-Jul-09 1:58

Help!!!

How can I find specific value from a field in a select list where the specific value varies in position.
ex;
Record1 A-'Telec:144'
Record1 B-'Telecom:145'

How to find the ":" using the SQL so I can get the 2 value in one field.. pls..

Dabuskol

Dabsukol

Re: command to find specific value in select

Ashfield21-Jul-09 2:08

Ashfield

21-Jul-09 2:08

Use substring to get the characters, and charindex to find the :

declare @a varchar(20)
set @a = 'Telec:144'
select substring(@a,1,charindex(':',@a)-1),substring(@a,charindex(':',@a)+1,len(@a))

will return Telec for the first 1 and 144 for the 2nd

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: command to find specific value in select

dabuskol21-Jul-09 2:20

dabuskol

21-Jul-09 2:20

You are correct... Thanks for the immediate reply you save me on my last minute.

Thanks...

Dabsukol

Re: command to find specific value in select

Ashfield21-Jul-09 4:48

Ashfield

21-Jul-09 4:48

No problem

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Last Visit: 31-Dec-99 18:00 Last Update: 5-May-24 2:57

Refresh

ᐊ Prev 1...799 800 801 802803804 805 806 807 808 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.