Viewing 15 posts - 721 through 735 (of 3,221 total)
xRafo (1/30/2012)
if that have 3 upgrades of 4 records,how do I insert the record was not updated??
Which posted possibly solution are you refering to?
If it is my posting - please...
January 30, 2012 at 3:17 pm
A method which should work in 2005 (sample code copied from the 2008 help file)
USE AdventureWorks;
GO
CREATE PROCEDURE dbo.InsertUnitMeasure
@UnitMeasureCode nchar(3),
@Name nvarchar(25)
AS
BEGIN
...
January 30, 2012 at 12:33 pm
Are you familiar with the new MERGE statement (Introduced in SQL 2008) ?
May I suggest looking at:
http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/
and:
SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for...
January 30, 2012 at 10:51 am
Just a suggestion - look at this article by Jeff Moden on an 8K splitter, its use just might help you.
January 29, 2012 at 6:11 pm
This might get you thinking (especially how to improve the code I have posted below). Seems I got my mind in a rut and could come up with nothing...
January 29, 2012 at 5:37 pm
tnt750 (1/29/2012)
hi allcan you help me?plz
i work with sql server 2008
Many people here will attempt to assist you.
But what is your problem ... ? ? ? ? ?
Is...
January 29, 2012 at 5:10 am
Good question - thanks for reminding me of the basics
January 25, 2012 at 8:18 pm
This may or may not be of help to you, but it is the only method I have utilized and it worked for myself. So for what assistance it...
January 24, 2012 at 3:51 pm
tilew-948340 (1/23/2012)
The question was 'on your SQL Server 2008 R2...
January 23, 2012 at 8:59 pm
Nice question really had to dig deep into my memory to, well answer the question.
January 23, 2012 at 8:53 pm
After that would like to fill details specific to particular person of particular category ( ie person who is in staff will have salary details)
A question for you. Why...
January 21, 2012 at 2:17 pm
GilaMonster (1/18/2012)
Gianluca Sartori (1/18/2012)
This one made my LMAO:
OP: I have performance issues and I'm totally clueless.
Gail: Hire a consultant.
OP: I'm the...
January 18, 2012 at 11:58 am
Is this what you are searching for?
Select dateadd(qq, datediff(qq, 0, @ThisDate), 0)
Whoops that gives you this quarter NOT last quarter ... sorry about that
January 17, 2012 at 10:36 am
Viewing 15 posts - 721 through 735 (of 3,221 total)