ravisamigo (7/16/2012)

---

Hi All,

We have configured 2 jobs for db full backups and both jobs having the same number of databases

[ i.e JOB 1 - Total size of all...

Hi deepzzzz,

It is always better to provide sample INSERT statements and required output to avoid...

addition

Little correction in Subbareddy code will work.

DECLARE @T1 TABLE(ID INT,NAME VARCHAR(30))

INSERT INTO @T1(ID,NAME)

SELECT 1,'AA'

UNION...

bitbucket-25253 (7/16/2012)

---

rhythmk (7/16/2012)

---

weblorquins (7/16/2012)

---

Delete From TableName

Where ID Not IN

{

Select MAX(ID) From TableName

Group By Col1, Col2...

}

By The help of Table name useing ID and the Group By we can delete the...

honza.mf (7/16/2012)

---

rhythmk (7/16/2012)

---

kupy (7/16/2012)

---

+1

I copied...

weblorquins (7/16/2012)

---

Delete From TableName

Where ID Not IN

{

Select MAX(ID) From TableName

Group By Col1, Col2...

}

By The help of Table name useing ID and the Group By we can delete the duplicate record...

kupy (7/16/2012)

---

+1

I copied the strings...

rhythmk (7/16/2012)

---

rob.vig (7/15/2012)

---

Can someone help me? I am getting this error:

Msg 102, Level 15, State 1, Procedure sp_Create_Accounts, Line 23

Incorrect syntax near '@Status'.

Msg 102, Level 15, State 1, Procedure sp_Create_Accounts,...

rob.vig (7/15/2012)

---

Can someone help me? I am getting this error:

Msg 102, Level 15, State 1, Procedure sp_Create_Accounts, Line 23

Incorrect syntax near '@Status'.

Msg 102, Level 15, State 1, Procedure sp_Create_Accounts, Line...

Smash125 (7/15/2012)

---

Have created Scalar User Defined Function and when i try to execute the function it fails.What could be the problem

Please find the function as below.

CREATE FUNCTION fnContactFullName(@ID INT)

RETURNS NVARCHAR(100)

AS

BEGIN

DECLARE...

Homosapiens

shamshad.ali (7/14/2012)

---

Hi,

I have following table:

USE [Test_Shamshad]

GO

/****** Object: Table [dbo].[mTable1] Script Date: 07/14/2012 13:26:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[mTable1](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Name]...

Congrats....its party time now 🙂

Hi Ankit,

Have a look on below link.

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