Any reason for not using splitter udf?

SQLSteve (8/7/2013)

---

Kingston Dhasian (8/7/2013)

---

You can create this stored procedure in the model database

When you create a new database, the new database will automatically inherit this stored procedure from the model...

You can create this stored procedure in the model database

When you create a new database, the new database will automatically inherit this stored procedure from the model database

Check the link...

Good question, but the explanation could have been better.

You could have explained why the condition is similar to "WHERE 1 = 1"

Your query is as below

SELECT

ID,...

Performance Considerations

Avoid adding unnecessary columns. Adding too many index columns, key or nonkey, can have the following performance implications:

Fewer index rows will fit on a page....

Something like this should work

DECLARE@num1 NUMERIC(12,2)

DECLARE@num2 NUMERIC(12,2)

SELECT@num1 = 29, @num2 = 30

SELECT CONVERT(NUMERIC(12,2),@num1/@num2)

OR this

SELECT 29/30.00

This issue happened because when you do something like SELECT CONVERT( NUMERIC(12,2), 29/30 ), an INTEGER...

Even I don't think it's about the money. You can get people with...

L' Eomot Inversé (7/11/2013)

---

Kingston Dhasian (7/11/2013)

---

Bajrang (7/11/2013)

---

Thank you SSC for posting this question.. 🙂

and

Thank you all members.. Yes, explanation provided on BOL link doesn't fit but couldn't find any other...

The...

The explanation is not completely correct

The upper limit for INT data type is 2^31 - 1( 2,147,483,647 ), the number 5555555 does not exceed this limit

As Danny has said above,...

You can do this using a Tally Table

declare @date1 datetime

declare @date2 datetime

set @date1='20130801'

set @date2='20130807'

SELECTDATEADD(DAY,T.N-1,@date1) AS Dates

FROMdbo.Tally AS T

WHERET.N <= DATEDIFF(DAY,@date1,@date2) + 1

For more information on what a Tally table is...

shy.n86 (7/6/2013)

---

Hi Geeks,

I have question about usage of this SP that how legal it is use to use this sp?

what kind of impact it does on your sever when a...

Can you post your execution plan?

You can try replacing the NOT IN with NOT EXISTS

SELECT

CASE WHEN substring(cli, 1, 2) = '44' THEN cli ELSE '44' + cli

END 'cli', min(call_date) 'date'

FROM...

I am not really clear what your requirement is.

You can probably explain it much better with some DDL, sample data( may be some 10 - 20 rows ) and the...

Bala' (6/27/2013)

---

Things not clarified ,,

More than one rows per date

how spend date was calculated

how late and half date was updTED

etc

GIVE PROPER EXPLANATION ON HOW THE DATA RESIDES , AND...