Quick and dirty fix try the command time out to 0 Try that you might get ahead and fix the real problem whilst they are dragging on with it. dont...
Kind of disagree with the business logic in the stored proc. a little logic for filtering is fine but not have the comple business logic. you should...
Hi can this be approached in a diff way select @values = 'asahay.com,,asahay1.com,2,asahay2.com,2,N ' select @values = 'SELECT '''+@values select...
Try Rank if possible on BOL this should also be good one for your needs.
is it possible to do a Replace insted of Case When?
you could also rewrite as following. /*create table employee ( empno int, empname varchar(50), salary int, comission int) insert into employee...
do you want to export to a file, if so then click on the top right hand corner of the grid and right click and save as a csv. if you want column...
are you missing some thing to post any cross reference table's involved as OB is replaced to Own Brand. and other things. can you be more specific on...
Correct me if i am wrong, the create table and then writing to the temp table would take more time ?, as per my experience i was always advocated...
Congratulations i felt you must be congratulated, very well done Satya. [:D]
have a table Product Product_ID = 'XDell020458' Product_ID = 'XAcer05557' now i have a mapping talbe Product_ID , CountryCode ,...
Dont get it ? could you explain, what is the subject of the issue is it performence, i understand that you are want to do batching of the data, If...
I dont know if its the right answer, probaly few of the things are for backword compatiablity? the question is very basic and i have no answer for...
hope this helps. SELECT * FROM BR one LEFT OUTER JOIN SoxBillingRelationship two on one.BRID = two.brid WHERE two.brid IS NULL
[:D]do you want to see yout Index defragmentation, try to do a re-index of the table, using the dbccreindex command but do this when you have no...
and also should do a constant scan and so you should be ok with the time consumption remember to have the where caluse order also in the same order...
Can you try some thing realy bizar. Strip out yoru or conditions and make them like Select A,B,C from XYZ where A= @a and B=@b and c=@C union all...
Cheeky guys the developer workstation should habe been configurable to get it going but its not right. i mean if you go to sqlwb.exe we should be...
does that mean that i have stumbled upon some thing which i should have not stumbled upon.
i did check both the sections of sp's master database sp's and master databases extended sp's but i could not find the sp_dbidug , i am an local...
Separate names with a comma.
