|
You can do this with an insert into table, e.g.
insert into mytable (value1, value2, value3)
select @value1, @value2, @value3
where @myitem not in (select myitem from table2)
|
|
|
|
|
anyone.. plss... nid it badly..
|
|
|
|
|
<a href="http://www.google.com/search?source=ig&hl=en&rlz=&=&q=Update+-+TSQL&btnG=Google+Search">Update</a>[<a href="http://www.google.com/search?source=ig&hl=en&rlz=&=&q=Update+-+TSQL&btnG=Google+Search" target="_blank" title="New Window">^</a>] tablename set columnmae='newvalue' where columname='oldvalue'
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.
|
|
|
|
|
Hello All
i am wondering how to call a batch of SQL server scripts from inside a C# code
Thanx for your help
|
|
|
|
|
ADO.NET
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have a requirement to allow a user to search using Staff Number is like, i.e. starts with or ends with, as well as Staff Number is in, i.e. a list of Staff Numbers. Is there some way I could handle these two filter criterion together, or should I simply create an IN query when I detect a list of numbers, and a like query otherwise?
|
|
|
|
|
I think query should be something like this:
<br />
select * from tablename <br />
where ([Staff Number] like '%value%')<br />
or ([Staff Number] in ('value'))
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.
|
|
|
|
|
I have a table and this table like the following
id_______ name_________ date
1________mm___________28/3/1999
2________mm___________21/3/1999
3________mm___________25/4/1999
4________nn____________10/8/1999
5________nn____________15/9/1999
6________nn____________2/10/1999
i need the following result
id_______ name_________ date
1________mm___________25/4/1999
2________nn____________2/10/1999
thank you
|
|
|
|
|
select [name],<br />
(select top 1 t1.[date] from MyTable as t1 where t1.[name] = MyTable.[name] order by t1.[id] desc)<br />
from MyTable <br />
group by [name]
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.
|
|
|
|
|
try this
select name, max(date)
from table
group by name
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have an inline table function and it takes tow parameters of type VARCHAR.
I functions when I hard code to string within of call like this:
SELECT * FROM dbo.TestTable('a', 'b')
Here is definition of inline table function:
FUNCTION GetIPTimeRangeTable (@StartDate VARCHAR(10) = '', @EndDate VARCHAR(10) = '')
RETURNS TABLE
AS
RETURN
(
SELECT
* FROM UserDataSetsAccess
WHERE 1 = 1
AND CreatedAT between @StartDate AND @EndDate
)
If call function like this:
SELECT * FROM GetIPTimeRangeViewTable('2008-7-1', '2008-7-11')
Every ting is OK but if I call function like this
SELECT * FROM GetIPTimeRangeViewTable('2008-7-1', CONVERT(CHAR(10), GETDATE(),121))
I get error:
Incorrect syntax near the keyword 'CONVERT'.
Do you have any explanation for that!
Tanks
|
|
|
|
|
try using varchar(10), you there have 8 or 9 char not 10!!!
you can get 8 (1-1-2004), 9 (10-9-2005) or 10 (10-10-2004) chars.
you used getdate(), if you ran it october 10th it will work 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hello all, i have a three tables user,aspnet_user,and aspnetmembership table and i made my table name myapplicationuser which contins colum similer to that of the three tables. Now from Store procedure i want to check those data in tables user,aspnet_user,and aspnetmembership and not in myapplicationuser and insert into myapplicationuser , i.e check if exist if not insert it (from stored procedure)
|
|
|
|
|
Try using IF EXISTS statement.
IF Not exists (select 1 from tablex where columny = 'z')
begin
insert ....
end
else
begin
update ...
end
Bob
Ashfield Consultants Ltd
|
|
|
|
|
whats wrong with this one why is it opening a new sqlqury ide
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[copyuser]
AS
SET NOCOUNT ON;
DECLARE @iRowId int, @userName NVARCHAR(100)
DECLARE usercursor1 CURSOR FOR
SELECT UserID,Username FROM users
print 'reached here'
OPEN usercursor1
FETCH usercursor1 into @iRowId,@userName
WHILE @@Fetch_Status = 0
BEGIN --loop started
PRINT @userName
IF not EXISTS (SELECT 1 FROM Esso_UserInfo WHERE UserName=@userName)
BEGIN --if started
PRINT 'not exist'
END --if closed
ELSE
BEGIN --else started
PRINT 'exist'
END --else closed
FETCH usercursor1 into @iRowId,@userName
End --loop closed
CLOSE usercursor1
DEALLOCATE usercursor1
RETURN
|
|
|
|
|
justintimberlake wrote: whats wrong with this one
No idea. Where does it go wrong?
justintimberlake wrote: why is it opening a new sqlqury ide
Again, no idea.
A tip, don't use cursors they slow processing down enormously. Try running updates first and then inserting where not exists.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
it just opnes a new sqlquery editor and shows return value 0
|
|
|
|
|
hey its ok the stored procedure works
|
|
|
|
|
Hello everyone,
I need ur help to write a trigger. I have 3 tables (Ex: Employee master,Employee salary details and Employee in_out details),if i update any value in the Employee master table, the value must be automatically updated in other related tables.
Plzzzzzzzzzz help urgent!!!!!!
Thanks.
|
|
|
|
|
Jesu Prabhu.J wrote: Plzzzzzzzzzz help urgent!!!!!!
Not, its not urgent.
Jesu Prabhu.J wrote: I need ur help to write a trigger.
So write your version and if it doesn't work post it and someone will help. A clue, you need a trigger on Employee for insert and update which will select the values from the inserted table and update the other two tables.
There you go, now google triggers.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Thanks for the Reply..
|
|
|
|
|
Jesu Prabhu.J wrote: I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Yes, I assumed you were using SQL Server. You still need a trigger on Employee Master. There are hundreds of examples on Google.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Plzzzzzz help me out with this problem, i have to store special symbols like integral, sigma, pi etc in tha database. I'm using the nvarchar datatype, but getting unexpected results..
Thanks in advance...........
|
|
|
|
|
I think using nvarchar should be sufficient.
Although you'll not be able to see these characters in 'Query Analyzer' or 'Enterprise Manager' (you will see boxes instead) but when this data is called by client application e.g. C# you can see correct depiction of the character.
Razov
|
|
|
|
|
I am viewing these values in a rich textbox, but it displays ?? when the application is run.I'm using VB.net 2008
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
