Viewing 15 posts - 46 through 60 (of 104 total)
Paul White (9/9/2009)
KB (9/9/2009)
It has around 17 lacs of records.So i think it can be done through a simple update statement
Cool. What are 'lacs' though? :unsure:
Its 1,700,000 rows.
Hmmm...Will...
September 9, 2009 at 7:26 am
Paul White (9/9/2009)
KB (9/9/2009)
Is manual update(from NULL to 0), the only solution ?
There is rarely only one solution to any problem in SQL Server!
It might be easiest and as good...
September 9, 2009 at 7:10 am
Is manual update(from NULL to 0), the only solution ?
-
KB
September 9, 2009 at 6:59 am
Dave Ballantyne (9/3/2009)
KB (9/3/2009)
In this article, I need to know what is the purpose of SortKey in CTE.
In the hierarchy, will the Top level row is returned first??
(In our project...
September 3, 2009 at 8:38 am
Hi,
In this article, I need to know what is the purpose of SortKey in CTE.
In the hierarchy, will the Top level row is returned first??
(In our project we need only...
September 3, 2009 at 8:16 am
Erik Kutzler (8/20/2009)
You can add multiple Data Flows to the Control Flow and set precedence constraints between each Data Flow.
Instead of adding that many data flow tasks,
is there any...
August 20, 2009 at 7:43 am
Hi All,
One more on performance.
TableA has 140columns.
TableB has 40columns.
In one application, it has been used the 1st query below.
(but for processing only 15 columns are needed)
If I change the query...
July 29, 2009 at 11:08 pm
Michael Valentine Jones (7/29/2009)
KB (7/29/2009)
Which query executes faster in sql server 2005, if table has some 50k rows.
select count(id) from table --id being primary key
OR
select count(*) from table
how to...
July 29, 2009 at 10:56 pm
Ramesh Babu (6/24/2009)
@strSQL varchar(4000)
SELECT @CodeLen = MAX(DATALENGTH(Code)) from History_temp
--print @CodeLen
set @strSQL='SELECT POL_NO [Policy]
,Name
,AGY_NO [Agency]
,Initials
,cast(Code as varchar( ' +@CodeLen + ')) [Code]
,Method
,createdOn AS [Received...
June 24, 2009 at 6:20 am
Hi,
I am using the below cmd to generate Report.
but the problem is I'm not able to trim the column "Code" which is of varchar(max)....
in the report generated i can see...
June 24, 2009 at 3:35 am
Thanks all for the help,
-
KB
June 23, 2009 at 7:53 am
ps (6/23/2009)
June 23, 2009 at 7:20 am
Lynn Pettis (6/9/2009)
Post the table DDL and some sample data for the tables along with the expected results. I was looking at your query and I think it...
June 11, 2009 at 2:38 pm
Lynn Pettis (6/9/2009)
Post the table DDL and some sample data for the tables along with the expected results. I was looking at your query and I think it...
June 9, 2009 at 3:13 pm
GSquared (6/9/2009)
Can you post both execution plans? Can't really figure out the difference without looking at those.
I am sorry, right now I do not have permissions to see execution...
June 9, 2009 at 2:56 pm
Viewing 15 posts - 46 through 60 (of 104 total)