TVF may be. It can be used in FROM, you know.

create function SelectEmployees (@version varchar(10))

returns @t table (

-- fields compatible with RetailXX.dbo.Employees tables

)

as

begin

if @version = 'Dev'

insert @t

select *...

If i got it right ...

Suppose there's date range lookup table with N dates

create table #RangeLookup (

dt date

)

declare @strtDate date = '20140101'

declare @step int = 30

declare @N int...

It totally depends on what is the 'text'. Try patindex()

declare @txt varchar(100)

set @txt ='Te33 Text CD789 Te6t'

select substring(@txt,patindex('%[A-Z][A-Z][0-9][0-9][0-9]%', @txt),5)

Rgds

Serg

I wonder why only two records.

GROUP BY CRS.CN implies a separate row for every CN value in the join result.

May be you mean SUM (A+B+C) in the...

Noted REQUIRED_DATE is missing which defines the order of servicing.

At least try to get rid of inner loop

WHILE @sum_shipqty > 0.

1.Add running total column say RT to @Temp_Table.

2.After inserting to @Temp_Table compute RT. @Temp_Table is under...

If you need both subtotals and total see GROUP BY ROLLUP

http://technet.microsoft.com/ru-ru/library/ms177673.aspx

OP's c# code generates all the words of given length L consisting of characters from the set {'!',..,'~'} .

When L<=0 it generates empty set of words.

Try recursive TVF

create function testrec (@l int )

returns @t table

(c varchar(100))

as

begin

if @l > 0

begin

insert @t

select z.c + isnull(x.c,'')

from

(select top (ascii('~')...

You may hard code it as well

select * from [Temptable]

where namesrt in (100,599

, case @NAME when '410' then 410 when '430' then 430 end

...

...

CROSS APPLY A.xmldata.nodes('/Internationalization/contentRecords[@locale = sql:variable("@country")]/contentRecord') as N(X)

if i got it right and only contentRecords with the given @locale needed.

Try

select rating, min(AbsenceStartDate), max(AbsenceEndDate)

from (select r.*, AbsenceEndDate -

(select sum ( DATEDIFF (dd,AbsenceStartDate, AbsenceEndDate))

...

If you can't use MAX, use MIN 🙂

select -MIN(-SalesAmount)

from SalesOrder s

join ItemDetail i on i.ItemID = s.ItemID and i.CatID = 1

Then JOIN them

select x.R1,x.R2,x.R3, y.C1,y.C2,y.C3

from Database.table1 as x

join Database.table2 as y

to get all possible combinations aka cartesian product.

Restrict combinations using WHERE clause

http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx

Still wonder what you mean merge? Pls, provide sample src data and the result expected.