Update pgStatusStart & pgStatusEnd by recordcount

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Update pgStatusStart & pgStatusEnd by recordcount

Author

Topic

micnie_2020
Posting Yak Master

232 Posts

Posted - 2010-03-03 : 00:45:36

Dear All,

I need an sql to update a table pgStatusStart & pgStatusEnd As Below:-

Before:
********
No pgStatusStart pgStatusEnd
------------------------------------
1. Null Null
2. Null Null
3. Null Null
4.
:
:
10. Null Null
11. Null Null
12. Null Null
:
:
20. Null Null

After:
*******
No pgStatusStart pgStatusEnd
------------------------------------
1. y Null
2. Null Null
3. Null Null
4.
:
:
10. Null y
11. y Null
12. Null Null
:
:
20. Null y
:
:

Please help me.

Thank you.

Regards,
Micheale

Sachin.Nand

2937 Posts

Posted - 2010-03-03 : 00:47:41

What is the basis for the update?

PBUH

micnie_2020
Posting Yak Master

232 Posts

Posted - 2010-03-03 : 00:51:51

quote:
Originally posted by Idera

What is the basis for the update?

PBUH

Update 10 record each for pgStatusStart & pgStatusEnd

eg:

ID 1 --> pgStatusStart=y
ID 10 --> pgStatusnd=y
ID 11 --> pgStatusStart=y
ID 20 --> pgStatusEnd=y
ID 21 --> pgStatusStart=y
ID 30 --> pgStatusnd=y
ID 31 --> pgStatusStart=y
ID 40 --> pgStatusEnd=y
:
:

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2010-03-03 : 00:53:56

[code]
is this u want
DECLARE @i TABLE (id INT IDENTITY(1,1),pgstart VARCHAR(12), pgend VARCHAR(12))

INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL
INSERT INTO @i SELECT NULL ,NULL

UPDATE @i
SET pgstart = 'y'
WHERE (id%10) = 1

UPDATE @i
SET pgend = 'y'
WHERE (id%10) = 0

SELECT * FROM @i
[/code]

micnie_2020
Posting Yak Master

232 Posts

Posted - 2010-03-03 : 01:01:17

Dear bklr,

It's work Fine now.

Thank you very much.

Cheers,
Micheale

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2010-03-03 : 01:02:45

quote:
Originally posted by micnie_2020

Dear bklr,

It's work Fine now.

Thank you very much.

Cheers,
Micheale

Welcome

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources