sql server获取数据 [英] sql server getting data

问题描述

大家好

我的结果是这样的

Hi all
I have result set like this

productid	proudctname	enterdate	nameoftheday	status
1		colgate		2013/05/01       wednesday	 0
2		santoor		2013/05/01       wednesday	 0
3		rin		2013/05/01       wednesday	 0
4		lux		2013/05/02       Thursday	 0
4		mouse		2013/05/03       friday		 0
null		null	        2013/05/04       satruday	 0
null		null  	        2013/05/05       sunday	         0
5		cellphone	2013/05/06	 monday	 	 0
6		bottle 		2013/05/06	 monday	 	 0
7		books		2013/05/06	 monday	 	 0
null		null		2013/05/07	 tuesday	 1
8		chair		2013/05/08	 wednuesday      0
null		null    	2013/05/09	 Thursday	 1

现在我想更新上面的结果集

即

如果状态= 1

i想要更新以前的日期值

产品ID和产品名称

为了澄清我会给出样品输出

now i want to update above result set
that is
if status =1
i want to update previous date values
in product id and productname
To get clarification i will give sample output

productid	proudctname	enterdate	nameoftheday	status
1		colgate		2013/05/01       wednesday	 0
2		santoor		2013/05/01       wednesday	 0
3		rin		2013/05/01       wednesday	 0
4		lux		2013/05/02       Thursday	 0
4		mouse		2013/05/03       friday		 0
null		null	        2013/05/04       satruday	 0
null		null  	        2013/05/05       sunday	         0
5		cellphone	2013/05/06	 monday	 	 0
6		bottle 		2013/05/06	 monday	 	 0
7		books		2013/05/06	 monday	 	 0
5or6or7	  cellphone/bottle/books 2013/05/07	 tuesday	 1
8		chair		2013/05/08	 wednuesday      0
8		chair	    	2013/05/09	 Thursday	 1

可以任何人帮助我



问候，

Prakash.ch

Could anyone help me out

Regards,
Prakash.ch

推荐答案

看看这里： sql server过滤数据 [ ^ ]。完全相同的问题和我的anser！

Have a look here: sql server filtering data[^]. Exactly the same question and my anser!

这篇关于sql server获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！