|
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
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
Look into CHARINDEX and SUBSTRING
pseudo code ...
IF (CHARINDEX(SUBSTRING(WORD,1,1),'aeiou',1) > 1) then
found it
End if
|
|
|
|
|
big thanks!!! I haven't test it yet but it seems to be the solution 
|
|
|
|
|
You should use the Like keyword:
select word from dictionary
where word like '[aeouy][bcd]%'
Wout Louwers
|
|
|
|
|
Wow ! That is a neat way of using the "like" comparison. I like it! 
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
You could use SSIS or linked servers.
|
|
|
|
|
i know using linked servers but using query i shuld get it becoz this query is used in c#..... to execute so many tables ...
|
|
|
|
|
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
|
|
|
|
|
hi robin.
actual i want to transfer the entire table structure along with datafrom local sqlserver to hosting sqlserver using c#
|
|
|
|
|
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
|
|
|
|
|
hi venu,
server1 database structure is static or dynamic??
icanmakeiteasy
|
|
|
|
|
|
then if the table structure is static create a script file for server1 database.., read that file from c#, then manipulate it...
icanmakeiteasy
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
You are correct... Thanks for the immediate reply you save me on my last minute.
Thanks...
Dabsukol
|
|
|
|
|
No problem
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Link Directory Submitter is the perfect solution for sending your sites to a multitude of pre-configured online directories. Link Directory Submitter comes with 2700+ link directories to submit to, more than half ranging from PR4 to PR7. Visit us at: http://www.clicknearn.net/3016-53.html
|
|
|
|
|
If you want to advertise, try paying for it - and if your product was that good you would be found straight away by anyone googling.
And its a rubbish web site, full of spelling and grammatical errors anyway.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
I am using the following stored procedure to insert into two tables and it works fine
ALTER PROCEDURE createEmployee(@loginId VARCHAR (20), @username VARCHAR (25), @passwrd VARCHAR (25),@empId VARCHAR (20),@title varchar(5),@branchNo VARCHAR(20),@Fname VARCHAR(50),@idNo VARCHAR(13),@physicaladdress varchar(50),@province VARCHAR(50),@city VARCHAR(50),@telephone varchar(15),@cellNo VARCHAR(15),@Email VARCHAR(30),@employeetype varchar(15),@salary NUMERIC(11,2))
AS
INSERT INTO LoginInfo VALUES(@loginId,@username,@passwrd)
--SET @loginId=@@IDENTITY
INSERT INTO EMPLOYEE VALUES(@empId,@loginId,@title,@branchNo,@Fname,@idNo,@physicaladdress,@province,@city,@telephone,@cellNo,@Email,@employeetype,@salary);
But Note the @branchNo parameter to be inserted into the EMPLOYEE table. I need to get it from a table named BRANCH based on some criteria. Currently I have hard coded its(@branch parameter)its value.I've tried to use the column level Select subquery but it is not allowed. please give a junior developer some logic
ML Lingwati
|
|
|
|
|
How about:
INSERT INTO EMPLOYEE
SELECT
@empId,
@loginId,
@title,
branchNo,
@Fname,
@idNo,
@physicaladdress,
@province,
@city,
@telephone,
@cellNo,
@Email,
@employeetype,
@salary
FROM BRANCH
WHERE someCriteria
In case thats a bit confusing, you can pull the branchNo from another table while still using all your variable for the other columns to be inserted.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
