Hi

You should also have a look for the MSDN Academic Alliance (MSDN AA). I'm not sure if this is also available for teachers but it would be a low price...

Which Edition of SQL Server?

Could you please post your connection-string (sure, without real user and password!)?

Greets

Flo

Jeff Moden (4/5/2009)

---

steve dassin (4/4/2009)

---

C'mon you got something against...

Hi

Maybe the part with "apparently unqualified" was a little rude. Sorry for that Barry! But he is also right with it. Maybe I would write it in another way (e.g....

Hi Zen

Here we go... 😎

First, my final interpretation of your procedure:

If @TIENDA is 1, 2 or 3 the returned data are always the same.

If @TIENDA is 1 you also fill...

Oops, sorry! Thought you're from America like most people here

It's also not really morning here (currently it's 12:42 pm in Germany). May ask where are you from?

I'm out for now,...

Good morning Paul!

I would also handle this different. Just alike your second approach to provide the client UTC offset to the function as DECIMAL.

I'm sure it's just a typo in...

Hi Everybody

I didn't notice this "The Thread" since now. I've read (almost) all posts but I think there are some thinks still not said. Just the most important in, in...

I would suggest VARBINARY(MAX) because IMAGE is marked as deprecated and will be removed in future versions of SQL Server (I still don't completely understand why...).

If you use SQL Server...

So on my server the right value is:

SET @TimeDiff = CONVERT(DECIMAL(2,2),@TimeDiff / 24) + 0.003333334

Seems to be funny for deployment 😀

Greets

Flo

Hi Paul!

I've enjoyed this thread, and I think you have too. With luck the OP may get some use from it, or at least it might give him/her some...

Paul White (4/4/2009)

---

Good answer flo - it does exactly what the OP asked for, and efficiently too, with one minor comment: The UNIONs should be UNION ALLs (constant scan instead...

Hi kruti

I'm not sure if I tried correct, but if I execute your function I get a difference of 10 minutes:

SELECT GETDATE() here, dbo._GetActualDate('GMT::2:00') here_converted

Result

here ...

You're always welcome!

Hi

You can check the row-number by category partition:

DECLARE @Category TABLE (Category VARCHAR(50), Name VARCHAR(50))

INSERT INTO @Category

SELECT 'C0', 'N0'

UNION...