Eugene Elutin

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 2,894 total)

RE: Replace a Cursor

Since @CompanyName is also part of the table name it would be easy to leverage sys.objects to see if that table exists.
...
or use OBJECTPROPERTY function.
No cursor or loop requried...
_____________________________________________
"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 3, 2014 at 8:27 am

#1726850
RE: CONVERT PLSQL TO TSQL

STYLES (7/1/2014)
OK
this is where i am at and stuck
declare @period_name as date = 'DEC-10'
case when substring(period_name,5,2) = '@periodname' THEN SUBSTRING('@periodname' ,5,2)
the period names are in format ...
_____________________________________________
"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 1, 2014 at 10:58 am

#1726290
RE: Derived tables vs Normal table joins

In the OP case, there are many ways to write the query to return the same results, eg. using temp tables for intermidiate results...
Again, it's impossible to generalise the best...
_____________________________________________
"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 1, 2014 at 10:53 am

#1726285
RE: convert PLSQL TO TSQL

Double Post!
Replies in:
http://www.sqlservercentral.com/Forums/Topic1588112-3077-1.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 1, 2014 at 10:27 am

#1726269
RE: CONVERT PLSQL TO TSQL

Use
Oracle DECODE = T-SQL:
CASE WHEN [condition 1] THEN [expression 1]
WHEN [condition 2] THEN [expression 2]
...
_____________________________________________
"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 1, 2014 at 10:24 am

#1726264
RE: Can NoLock be used on table-returning functions?

nonghead-webspam (7/1/2014)
Reason I want to use NoLock is because queries are returning slowly. Instructions say that is what it is good for.
This is on a reporting database, not a...
_____________________________________________
"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 1, 2014 at 9:49 am

#1726243
RE: Derived tables vs Normal table joins

... My colleague argues that it is more efficient to use derived tables rather than joining two tables say and filtering with a Where clause. ...
You can argue to the...
_____________________________________________
"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 1, 2014 at 9:40 am

#1726239
RE: Can NoLock be used on table-returning functions?

...Must NoLock be used only on a query selecting from a table, or can it be on a table-returning function?
You better not to use NoLock at all.
What is your...
_____________________________________________
"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 1, 2014 at 9:26 am

#1726236
RE: XML Validation: Invalid simple type value dateTime

http://connect.microsoft.com/SQLServer/feedback/details/167649/xml-schema-collection-does-not-properly-validate-an-xsd-datetime
_____________________________________________
"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]

June 24, 2014 at 5:03 am

#1724277
RE: returning only portion of string

Alan.B (6/19/2014)
Eugene Elutin (6/19/2014)
SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)
Yep, as long...
_____________________________________________
"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]

June 20, 2014 at 3:57 am

#1723511
RE: Multiple ON Clauses In One Join?

Chris Wooding (6/20/2014)
Surely SELECT COUNT(*) should return 42?
Why so? Of course not!
On a clear, moonless night about 3,000 stars are visible with the unaided eye. A small telescope will...
_____________________________________________
"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]

June 20, 2014 at 3:30 am

#1723506
RE: returning only portion of string

SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)
Yep, as long you port to...
_____________________________________________
"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]

June 19, 2014 at 11:23 am

#1723377
RE: Modify Job Log Path

use sp_update_jobstep
_____________________________________________
"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]

June 19, 2014 at 9:56 am

#1723334
RE: returning only portion of string

May I ask please, if there is any reason to use SUBSTRING instead of PARSENAME other than love of typing and having more of pink in the code, especially...
_____________________________________________
"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]

June 19, 2014 at 9:53 am

#1723330
RE: Incremental Load

I hope I m not only the one here who cannot make any clue out of OP question...
What query brings data from source and destination?
What is your exepected results based...
_____________________________________________
"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]

June 19, 2014 at 9:46 am

#1723327

Viewing 15 posts - 106 through 120 (of 2,894 total)