Viewing 15 posts - 796 through 810 (of 2,462 total)
Brian-444611 (11/15/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 1:13 am
sqlnaive (11/20/2012)
Secondly, when once again I removed the clustered index and ran the query, it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 12:56 am
Dont forget the NOLOCK too 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 12:43 am
ch.omkarreddy (11/20/2012)
in the above i mentioned,the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......
that is what i explained plus link i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 12:20 am
tonyarp05 61903 (11/19/2012)
Can you give the script how to search
see this http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 12:20 am
ch.omkarreddy (11/19/2012)
the above table i created should have its transactio_id auto-incremented begining with 6 digit number
your requirement is not clear here but what i can assume here is you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 11:46 pm
a script can be used where you can dynamically pass the table and column names. but this will be time consuming task . as it needs to scan EVERY COLUMN...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 11:43 pm
charit0819 (11/19/2012)
Can any one plz tell me how to delete records from minimum 3 tables using inner join on the basis of a condition
this link will give you couple...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 11:01 pm
hi2u (11/19/2012)
Does the trigger keep the initial (TABLOCK, XLOCK) or the lock is released and another one is made for the trigger?Thanks
Yes to maintain the atomicity there will be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 10:59 pm
durai nagarajan (11/19/2012)
only some of them got in to wrong data.
There has to be some thing in query itself ..you are overlooking somethng
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 10:27 pm
durai nagarajan (11/19/2012)
No, for some empcode and date combination the output is right for some it is wrong.
have you try to check or verify the data with the direct...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 4:36 am
Kristian Ask (11/19/2012)
If the included columns is not creating a covering index, will the included columns still be read or is it then only using the table?
yes they will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 4:35 am
durai nagarajan (11/19/2012)
thanks, will checkjust a doubt this will have to slow down my query why my output has to vary?
your parameter to this sp is @date /...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 3:34 am
durai nagarajan (11/19/2012)
WHERE CONVERT(DATETIME, CONVERT(VARCHAR, @date, 101)) BETWEEN FromDate AND ToDate
this is the code which is creating problem as its not using the index for search (if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 3:00 am
durai nagarajan (11/19/2012)
we havent used inbuilt function also.
there is date conversion and comparison between a table column and input parameters.
i forgot to mention it is compared with...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 2:15 am
Viewing 15 posts - 796 through 810 (of 2,462 total)