Eugene Elutin

Forum Replies Created

Viewing 15 posts - 241 through 255 (of 2,894 total)

RE: Convert DATEDIFF to Decimal and Help with another DATEDIFF (Excluding weekends)

Devide by 24.0
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 31, 2013 at 3:28 am

#1637281
RE: Global Variable

(*) Those who have worked with SQL Server for a long time, know that once there was something called "global variables", and indeed they had leading @@. But they were...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 31, 2013 at 3:26 am

#1637280
RE: Global Variable

Yep, there are some alternatives. First what comes into my mind it's a CONTEXT_INFO:
http://msdn.microsoft.com/en-us/library/ms180125.aspx
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 30, 2013 at 11:34 am

#1637085
RE: Global Variable

Broccoli (7/30/2013)
Hi, I would like to create a global variable that I can reference multiple times and here is the script. it runs fine, but the problem is it...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 30, 2013 at 11:22 am

#1637079
RE: why should we use schemabinding with views?

Erland Sommarskog (7/30/2013)
T.Ashish (2013-07-29)
A view without any Index, but bound with schema.
Does it gives any performance difference.
For a view, no. But for a scalar user-defined function WITH SCHEMABINDING can be...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 30, 2013 at 2:51 am

#1636878
RE: CAN ANY ONE WRITE QUERY FOR BELOW DESCRIPTION!

GilaMonster (1/14/2010)
Nice set of addresses. What are we supposed to do with them?
Pay a visit to some of them. I specificaly like these two:
4935 DROUBAY DR, Las Vegas, NV 89122...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 29, 2013 at 8:35 am

#1636666
RE: Conditional print for testing scripts.

No, you will not be able to call another function inside of RAISERROR, but you can use variables in very nice way:
DECLARE @strDT VARCHAR(30) = convert(varchar(30),getdate(),126);
RAISERROR ('Now that''s what I...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

July 29, 2013 at 8:30 am

#1636662
RE: Explanation of LIKE '%[0-9]%'?

Jeff Moden (7/29/2013)
Eugene Elutin (7/29/2013)
Solomon Rutzky (7/27/2013)

23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38...

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

July 29, 2013 at 8:18 am

#1636658

RE: Update all but last two rows of each category

Based on provided details I can suggets you to look into ROW_NUMBER() windowed function. It will allow you to write the query you want.

If you need more detailed help,...

How to post your question to get the best and quick help[/url]

July 29, 2013 at 8:10 am

#1636654

RE: Fiscal Week in TSQL

I would highly recommend to employ a Calendar Table for this sort of "calculations".

How to post your question to get the best and quick help[/url]

July 29, 2013 at 6:22 am

#1636604

RE: Explanation of LIKE '%[0-9]%'?

Solomon Rutzky (7/27/2013)
23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38 digits
...

You can convert it...

How to post your question to get the best and quick help[/url]

July 29, 2013 at 6:20 am

#1636603

RE: When NULL IS NOT NULL

Yeah I have the same error on the:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)

Mar 29 2009 10:11:52

Express Edition (64-bit) on Windows NT 6.1...

How to post your question to get the best and quick help[/url]

July 29, 2013 at 5:00 am

#1636587

RE: When NULL IS NOT NULL

... Note that OUTER APPLY or CROSS APPLY seems to make no difference.

same goes for JOIN, check the third column values 🙂

WITH Tally (n) AS (

SELECT...

How to post your question to get the best and quick help[/url]

July 26, 2013 at 3:33 am

#1636082

RE: Need help to build query

vignesh.ms (7/25/2013)
yes your query is very simple ..
but i cant understand ..
Please explain what is cross apply ..
how dose it work in this query?

Search for "APPLY" in this BoL article:

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

it...

How to post your question to get the best and quick help[/url]

July 25, 2013 at 10:47 am

#1635835

RE: Need help to build query

vignesh.ms (7/25/2013)
yeah its working ...
any other simple method ???

I thought it was quite simple... 😉

Cursor anyone?

How to post your question to get the best and quick help[/url]

July 25, 2013 at 10:26 am

#1635825

Viewing 15 posts - 241 through 255 (of 2,894 total)