Confirm Vijaya Kadiyala. DDL and some sample data would be helpful to help. 😉

Please have a look to the link in my signature.

Greets

Flo

Hi

I would also suggest a Calendar table. It's quiet easy with this!

@bob-2: hope it's okay to bring a sample for your suggestion. Feel free to correct me! 🙂

DECLARE @sla TABLE...

Hi Zen

Glad to help you!

Just because I'm pry, is the performance better than before?

Greets

Flo

Hi

Could you explain "unused tables"?

Greets

Flo

... or have a look to the script I populated here 😉

Edited: Oops, sorry it's SQL2k Forum. So this script might not work. My apologize!

Greets

Flo

Hi

Just for information, if possible you may consider to use BCP.

Nevertheless. Which data type are your codctb and nifctb? It seems that your codctb is INT, so you have to...

This is only my current status here (as yours is "Grasshopper" currently).

My Name is "Flo" or "Florian" 😉

Have a nice day

Flo

Developer rules 😎

Usually I would also do the copy-paste,...

Meeting is in one hour...

😀

@Kruti

I'm going to assume the results are right then (your time zone is GMT +5 or something?)

The 4ms...

Nothing to apologize, I just did the...

Hi Paul!

Dang! You've been to fast 🙂

Only for completeness and not completely senseless writing this test...

SET NOCOUNT ON

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = ''

SELECT TOP(100) @sql = @sql +

'CREATE TABLE...

Hi kruti

To solve you problem, replace the FLOAT with a DECIMAL and handle minutes instead of days. This should work:

--DROP FUNCTION [_GetActualDate]

CREATE FUNCTION [dbo].[_GetActualDate]

(

-- Add the parameters...

Hi

You are correct a deletion in parent table may cause deletes in related tables and their relations.

How long this can take? Anytime between 0 (nearly) and forever. E.g. if you...

Hi kruti

As written in my previous post, what about a decimal parameter instead of varchar? You eliminate the problems with the float and it is much faster because you have...

Steve Jones - Editor (4/5/2009)

---

I've often thought the production DBA should be insurance. If he/she's doing the job, you pay him/her, and don't worry about things. That's a big IF,...