Viewing 15 posts - 2,116 through 2,130 (of 2,462 total)
Chris-475469 (3/5/2010)
I don't want to update the secondary table with data from any rows which have a WIPCODE of P009 or P002.
UPDATE ctSET ct.shorttext =
CASE WHEN LEN(ct.shorttext) + LEN(i.shortnarrative)...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 7:40 am
MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 7:24 am
dba-vb (3/3/2010)
what is the impact of storing the null values in a table
Read Below post
http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
You will find "three state logic" Even more than that
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 5:25 am
can you elaborate your question ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 5:21 am
May be this helps you
select
t1.resource_type,
db_name(resource_database_id)as db_name,
t1.resource_associated_entity_id,
t1.request_mode as lock_requested,
t1.request_session_id as spid_of_waiter ,
t2.wait_duration_ms,
(select text from sys.dm_exec_requests as r --- get sql for waiter
cross apply sys.dm_exec_sql_text(r.sql_handle)
where r.session_id...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 5:04 am
Have you checked the Error/Sql log for that interval of time?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2010 at 2:13 am
keyun21 (3/4/2010)
Does any one know where can i find DETAIL documentation on how to configure LINKED server where I can gain knowledge on login authentication between two server on....??????
Read Below...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 10:45 pm
thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 6:30 am
DELETE FROM @T1 where desn IN(
SELECT desn FROM @t1
EXCEPT
SELECT desn FROM @t2)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 5:52 am
itskumar2004 (3/3/2010)
execute sp_executesql @ExecSql,@ExecSql1,@ExecSql2,@ExecSql3,@ExecSql4,@ExecSql5,@ExecSql6,@ExecSql7,@Execsql8--print @ExecSql,@ExecSql1,@ExecSql2,@ExecSql3,@ExecSql4,@ExecSql5,@ExecSql6,@ExecSql7
i cant say where the exactly problem lies but you can see where the problem occuring by print "sp_executesql" , see if it can help...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 5:24 am
i am not sure but it seems that your "Count" depends on "group by" but you sum includes some case statement which is creating difference/wrong data. Still i would say...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 4:57 am
SELECT t.id1,t.id2,t.id3 FROM
( SELECT id1,id2,id3 ,ROW_NUMBER() OVER (PARTITION BY ID1
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 4:33 am
miss.delinda (3/3/2010)
I'm still want to maintain the constraint. Can you show me, how update statement look's like?
UNIQUE Constraint means unique value. how can you maintain uniqueness by inserting duplicate values...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 4:14 am
Jack Corbett (2/23/2010)
you could use WHERE account LIKE @query + '%' and give the Optimizer the option to choosing an INDEX SEEK.
Can we have INDEX SEEK while using LIKE operator?:unsure:,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2010 at 4:06 am
Viewing 15 posts - 2,116 through 2,130 (of 2,462 total)