varunkum (12/29/2010)

---

select ENTRY_DATE from CIRC.SUBS_TAG where ENTRY_DATE <> '10/27/2010'

I get "ORA-01843: not a valid month" error. ENTRY_DATE is date type. Why do i get this error. Please help me .Thank...

GSquared (12/28/2010)

---

Parthi:

That will generate negative hours if it's after noon. For example, 2 PM will end up as -2 PM. Not sure that's what you want.

Also, that kind...

simflex-897410 (12/28/2010)

---

Greetings again friends and helpers.

The code below grabs only month from getdate() and then day and year are static.

Given the code below, I get 12/2/2010 then minutes, seconds and...

TheSQLGuru (12/28/2010)

---

BAH! Just KILL their connections! 😀 I do that for several clients who are using a log ship box for a reporting instance - one of...

Hi

Have a look at CDC[Change Data Capture]

http://msdn.microsoft.com/en-us/library/bb522489.aspx

This will help u out ,which is added new feature in SQL Server 2008

Thanks

Parthi

Hi,

Have a look at this

declare @Temp table(Rid int identity,Col1 varchar(20),ddate datetime)

Insert into @Temp

Select 'Hi',GETDATE()

Union all

Select 'This is',GETDATE()

Union all

Select 'Test',GETDATE()

-- Case :1

Select Case When Col1='Hi' then 'Hello'+'...

Have a look on this

http://msdn.microsoft.com/en-us/library/ms189572.aspx

Thanks

Parthi

Nita Reddy (12/23/2010)

---

I am facing major issue on one of my sql db which contain 311 Tables and some of the table zie is like 400 GB some are 300...

Hi

Thanks for your query with Merge join New thing learned today on this.i have heared on this but not worked with data but now it also has been done...

ns_18 (12/21/2010)

---

I want to implement the below scenario.

If ther is any duplicate data then my SQL should run and find the duplicate rows and then delete them automatically.

Do you...

If you are using 2005 or 2008

Then use GROUP BY

A general GROUP BY clause includes GROUPING SETS, CUBE, ROLLUP, WITH CUBE, or WITH ROLLUP.

A simple GROUP BY clause does...

ns_18 (12/21/2010)

---

I want to implement the below scenario.

If ther is any duplicate data then my SQL should run and find the duplicate rows and then delete them automatically.

Do you...

saidapur_satish (12/21/2010)

---

Hi All,

After full backup all pages are emty after full backup we insert any thing it will store page no. 6 (SAM page).

...

saidapur_satish (12/21/2010)

---

Hi All,

Every time my boss restoring the MASTER DATABASE, i don't no if i ask he told me MASTER DATABASE is corrupted...

can any one tell...

Yes...