Some examples:

DECLARE @IPTable TABLE ( IP_Address VARCHAR(15))

INSERT INTO @IPTable (IP_Address)

SELECT '1.2.3.4'

UNION ALL SELECT '11.12.13.14'

UNION ALL SELECT '21.22.23.24'

UNION ALL...

You can use PARSENAME function to accomplish that.

THere is something called as Output Parameters while defining a Stored Procedures. Thats what you are looking for .

Here is the link : CREATE PROCEDURE

To be precise, Example C...

Cross Post.. divert your replies here http://www.sqlservercentral.com/Forums/Topic1253537-392-1.aspx

Or:

SELECT

Id,

Overseas,

scholarship,

ResultCol =

STUFF( ( CASE WHEN OVERSEAS = 'True' THEN ',FRN' ELSE '' END

...

How about this?

SELECT

Id,

Overseas,

scholarship,

ResultCol =

CASE WHEN OVERSEAS = 'True' THEN ',FRN' ELSE '' END

+ Case WHEN scholarship = 'True' THEN ',SCH' ELSE '' END

FROM #sample;

Results:

IdOverseasscholarshipResultCol

111,FRN,SCH

201,SCH

310,FRN

Like this:

DECLARE @Table TABLE ( TextData VARCHAR(100))

INSERT INTO @Table ( TextData )

SELECT 'Product 123'

UNION ALL SELECT 'Another Product 14 XX'

UNION...

Try PATINDEX

This?

declare @table table ( id int, sourcecode int, dt datetime)

insert into @table

select 1, null ,'02/06/12'

union all select 2, 2333 ,'02/07/12'

union all select 2, 2345 ,'02/07/12'

union all select 2, null ,'02/07/12'

union...

Not sure and clear on your requirement. Can you please take a gander at the following article and give us more information?

Forum Etiquettes[/url]

I sense your requirement is going to be...

fahey.jonathan (2/7/2012)

This code will not...

here

Use tempdb

GO

create proc getsthedate @dateval datetime

as

select @dateval ;

GO

declare @d datetime = getdate()

exec getsthedate @dateval = @d;

exec getsthedate @dateval = getdate() ;

drop proc getsthedate;

You cannot use Functions as direct input parameters. Initialize it to a variable and use it as an input parameter

Not unless you can code using Dynamic-SQL or a series of IF clauses!

This?

DECLARE @Date1 DATE = GETDATE()-1

,@Date2 DATE = GETDATE()-29

SELECT @Date1 , @Date2

[invoice date] BETWEEN @Date1 AND @Date2