divyang_dv 42143 (11/17/2015)

---

Alright, it makes sense, I really haven't thought that I am actually sharing invoice numbers between tenants. Can you please explain in a bit more on how to...

No, you stated it absolutly clear, separate sequence for each tenat. And this will generally allow for the same invoice number =123 to emerge for different tenats.

That's my question, why...

This...

My guess is 2 (value, defaultValue) ** 3 (number of rows) = 8

select [@YY],[@XX],[@ID]

from

(select v as [@ID]

from #Param

cross apply(values (value),(DefaultValue) ) t(v)

where Name ='@ID') _1,

(select v as [@XX]

from #Param

cross...

See this discussion for how to build polygon from points

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0ff0e3ec-fcb3-4aaa-9fbc-dbca6186d717/how-to-create-a-linestring-or-polygon-from-points?forum=sqlspatial

Also i'd aggregated polygon expression from points with FOR XML PATH('') rather them loop.

All the rest is rather straightforward.

Just date and integer arithmetic version

create function retailWeekNumbers(@dt date)

returns table

as

return select

[Year]

,[Week] = datediff(day

,dateadd(day, (t1.ws - datepart(weekday,YStartDt) -7) % 7, YStartDt) -- first week start

,@dt) / 7 +...

See this paper for accounting database design. I haven't found original publication by Michael Wigley.

https://vikrampareek.wordpress.com/2012/09/19/185/

Ok, then count them and decide.

declare @stemp varchar(50);

select @stemp = 'fl,ca';

with...

Try this query which utilises Left Anti Semi Join in its execution plan

--All the rows that have all of the states from a comma delimited parameter.

declare @stemp varchar(50);

select @stemp =...

So you need traverse menu hierarchy . Under above setup the

hierarchy CTE will do.

with hc as (

select menuCollection_idx, parentID

from [myMenuCollection]

where menuCollection_idx in (1,4,11)

union all

select mc.menuCollection_idx, mc.parentID

from [myMenuCollection]...

If you need the procedure to behave differently within the same run you need to place

SET @stoptime = CONVERT( CHAR(8), GetDate(), 14);

within the WHILE loop too .

alan.cdes (10/30/2015)

---

Try to insert your colum name with rates on a temporary table or variable table.

Order by rate.

Output the ordered colum name on comma delimited list.

Insert the comma delimited list...

Your last FETCH is beyond of WHILE loop. Is it what you really mean? Try

CREATE PROCEDURE procedure1

AS

DECLARE cursor_1 CURSOR FOR

SELECT

'This is a executable query'

FROM table_1

DECLARE @table_2

DECLARE...

Try

with allRatings as (

select * from [dbo].[InputTest1]

union all

select *

,[FormOrderForInstnRating] =

(select top(1) FormOrderForInstnRating from [dbo].[InputTest1] t1

where t2.[CreditRatingTranche] =t1.[CreditRatingTranche])

,[SortOrder] = 1+row_number() over(partition by [ShortestName],[CreditRatingTranche]...

May be as simple as the query below. Or may be not. 🙂

with allRatings as (

select * from [dbo].[InputTest1]

union all

select *

,null as [FormOrderForInstnRating]

,null as [SortOrder]

from [dbo].[InputTest2]

), nbr as (

select *

,rn...