Hi Ken Simmons,

I want to know why you use (+2) in...

Hi Anil,

try this ....

SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"

FROM sysobjects o, sysindexes i

WHERE i.id = o.id

AND indid IN(0,1)

AND xtype = 'u'

AND o.name <> 'sysdiagrams'

ORDER BY i.rowcnt DESC

---

Hi Guys,

Thanks you very much for your kind posting. All the post statements are working fine and that are valuable for...

hI GilaMonster,

Below is my requirement.

...

Hi guys,

@T should be changeable one. It ends with '03' or '003' etc...

I think that is the stuff here. ...

Hi GSquared,

Yes GSquared. i have to choose Append to file option in that.

at last i got it.

Thanks for your kind help. Thanks man :):):)

---

hi GSquared,

in that i selected drop option, if i use this i will not...

Hi GSquared,

Thanks GSquared for your quick answer.

...

Thanks you guys for your valuable information. 🙂

Hi Chris,

Some simply approach.

DROP TABLE #Test

CREATE TABLE #Test(ID int,MyDate DateTime)

INSERT INTO #Test (ID,Mydate)

SELECT 1,'2008-05-14 10:37:48.933'

UNION ALL

SELECT 2,'2008-05-15 10:37:48.933'

UNION ALL

SELECT 3,'2008-05-16 10:37:48.933'

UNION ALL

SELECT 4,'2008-05-17 10:37:48.933'

UNION ALL

SELECT...

Hi nihcas77,

Use COLLATE Latin1_General_CS_AS

---

Hi Debbie Edwards,

Try this one....

DROP TABLE #test

CREATE TABLE #test(PER_ID int,SCH int,COUNTS int)

INSERT #test (PER_ID,SCH,COUNTS)

SELECT 72997,675,1

UNION ALL

SELECT 77960,954,1

UNION ALL

SELECT 121084,903,2

UNION ALL

SELECT 121084,950,2

UNION ALL

SELECT 121431,669,1

UNION ALL

SELECT 121647,1081,1

UNION ALL

SELECT 131220,1083,1

SELECT PER_ID,SCH,COUNTS,case COUNTS when...

Hi peitech,

One more 🙂

DECLARE @t TABLE (name varchar(20))

INSERT @t

SELECT 'DeBeers'

UNION ALL

SELECT 'debeers'

UNION ALL

SELECT 'Test'

UNION...

Hi jzi,

From this document you have to parse the xml?

---

Hi lothar,

Can you tell what your expected result when you executing select statement?

and try with the...