SELECT DATEDIFF(SECOND,0,'20:10:10')

CREATE TABLE [dbo].[SourceCode](

[SourceCode] [varchar](50) NOT NULL,

[SRCvalue] [varchar](50) NULL,

[Description] [varchar](50) NULL,

[Years] [int] NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING ON

GO

INSERT [dbo].[SourceCode] ([SourceCode], [SRCvalue], [Description], [Years]) VALUES (N'SC1', N'3', N'PAS', 0)

INSERT [dbo].[SourceCode] ([SourceCode], [SRCvalue], [Description],...

CREATE TABLE [dbo].[SourceCode](

[SourceCode] [varchar](50) NOT NULL,

[SRCvalue] [varchar](50) NULL,

[Description] [varchar](50) NULL,

[Years] [int] NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING ON

GO

INSERT [dbo].[SourceCode] ([SourceCode], [SRCvalue], [Description], [Years]) VALUES (N'SC1', N'3', N'PAS', 0)

INSERT [dbo].[SourceCode] ([SourceCode], [SRCvalue], [Description],...

DECLARE @NUMBER VARCHAR(50)

DECLARE @FINAL VARCHAR(50)

SET @NUMBER = '1,2,3,4,5'

SET @FINAL = '''' + REPLACE (@NUMBER,',', ''',''') + ''''

SELECT @FINAL

hi will you make little be clear to you query with an example what actually you want.. i am little bit confuse

Hi

Friend I need very much clear picture for what you actually want i am getting littel bit confuseing ....

Hi Friend

The count for the select is 98797 and the count for update is 25784

as for the your above statement I show how you might be getting more records when...

Chris Metzger i agree with the all the above post.. as i was worked most with redgate tool so i suggest you with it... but its true fact i have...

Hi

Not sure about you whole query and requirement but if its finally have to be deleted based on id passed then you can go with this dynamic query.

Can change query...

Hi Chris Metzger

Without second thought go with RedGate Tools i have been working redgate tool for last 2years and i feel its have everything that you might be looking and...

Hi

Please will you clear me what this sentace means

"first identity column is regular id and second identity column is primary Key "

Look brother you can have only one identity column...

Hi

I really not getting what you want to say.

When your saying that view has alies names of the orignal table then how come your getting the orignal column for the...

Try this out

SELECT SomeColumn

FROM SomeTable

WHERE SomeDateColumn >= '20110901' AND SomeDateColumn <= '20111031'

Hi jnuqui

Good Work Dude.

Hi Simon

Hope you have got the solution from the above comment but respect to your query i just want to make you aware

update my_table

set dur = (SELECT

@rec_count = (select count(*)...