Viewing 15 posts - 5,056 through 5,070 (of 5,678 total)
BaldingLoopMan (11/8/2010)
----RESULTS:--1,'Value1, Value2'
--2,'Value1, ValueC'
--3,'Value1, Value2,Value5'
--1,'Value2'
Need a results confirmation here, just making sure it's user error not expectation:
ValueC came from where?
There's no space between the second and third value in line...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 1:51 pm
I would usually port the tables over using either SSIS packages, or a one shot data import via the GUI.
Going to need more information about the 'calculation' portion of what...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 1:42 pm
GilaMonster (11/8/2010)
I'm not joking. To cover any one of those topics in moderate detail is a large...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 1:24 pm
goodguy (11/8/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 1:05 pm
Grant Fritchey (11/8/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 12:30 pm
snoop123 (11/8/2010)
maintaining around 99 but...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 11:30 am
GilaMonster (11/8/2010)
Does this count? http://www.sqlservercentral.com/Forums/Topic1017255-1292-1.aspx
Been guilty of that a few times myself. Service Broker was my last occurence of that.
Me: "Alright, I've got endpoints going cross domain, multi-dialog conversations...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 11:21 am
GSquared (11/8/2010)
For example, these days, I'd expect if you know Union, you should also know Intersect and Except.
I guess I need to learn intersects. 😉
And before I'd worry about isolation...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 11:15 am
If I'm understanding the question properly, swap the order of these items:
SET @Quary = 'SELECT '+@stmt + ' from tblfinance'
DECLARE db_cursor CURSOR FOR
SELECT Column_Name from tblColumns order...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 12:22 am
Bunty, you left out too much of the question for us to even point you in the right direction, because if I read this right, you CAN go from B...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 12:19 am
MonsterRocks (11/7/2010)
-- master table
---------------------------
menu id menuname
1 ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 7, 2010 at 1:14 pm
This works correctly for me:
declare @miljul varchar(5)
declare @y int
set @y = year('1/1/2008');
declare @yearpart varchar(4);
set @miljul = '312'
set @yearpart = convert(varchar(4), @y)
print @yearpart
set @miljul = RIGHT(@yearpart,2) + @miljul
print @miljul
Does...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 7, 2010 at 1:11 pm
The best starter and foundations of Service Broker articles I've seen are Adam Mechanic's.
http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 7, 2010 at 1:18 am
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
As Jeff mentioned above, that particular question is a trap. It implies...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 7, 2010 at 1:15 am
biju.pad (11/5/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 5, 2010 at 6:17 pm
Viewing 15 posts - 5,056 through 5,070 (of 5,678 total)