Viewing 15 posts - 2,131 through 2,145 (of 5,678 total)
Welcome RW.
Why not just do this?
INSERT INTO dbo.Units (PhaseID, BuildingID, UnitName, FileNumber, SubAddress, Eligible, EligibleReason, Priority, TownPriority, BidAmount, ConstructionCost, Comments, AccessCode)
VALUES (@phase_id,@bldg_id,'','',@index,'','','','','','','','');
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
December 8, 2011 at 2:05 pm
AndrewSQLDBA (12/8/2011)
I have been working on it, and going thru the small list by hand to see exactly what rows are not in the correct place. I am coming...
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
December 8, 2011 at 1:46 pm
Can you run the code I offered and tell me exactly which row(s) are not positioning correctly?
Apologies, but I just don't have time to dig through that at the moment,...
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
December 8, 2011 at 11:55 am
Brandie Tarvin (12/8/2011)
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
December 8, 2011 at 11:53 am
oweston (12/7/2011)
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
December 8, 2011 at 1:02 am
mtassin (12/7/2011)
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
December 7, 2011 at 7:00 pm
If this database is small and merely complex, I have a recommendation...
Script out all the schema, drop it to a new DB shell, and port your data over. Grab...
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
December 7, 2011 at 6:57 pm
matthew.peters (12/7/2011)
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
December 7, 2011 at 6:54 pm
SQL_Surfer (12/7/2011)
Thanks tfifield. The use of FOR XMl mentioned in the article did the trick. Is there any other way by just using the self join?
Yes, but not with a...
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
December 7, 2011 at 6:50 pm
SQLRNNR (12/7/2011)
try using a cte and a row_number() ranking function.Put your query in the cte with that ranking function, then select from the cte where rownum=1
I would not under most...
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
December 7, 2011 at 6:45 pm
Andrew,
I took a look through this and your data and what you've described as the business rules and it doesn't make sense offhand. Hopefully you can clarify.
Honestly, your initial...
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
December 7, 2011 at 6:36 pm
LutzM (12/7/2011)
I'll keep trying to talk those folks into more spindles and much larger local drives (the fact they still didn't answer my memory dump...
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
December 7, 2011 at 6:11 pm
matthew.peters (12/7/2011)
I have an issue where an application is running a few different select queries with 'like' operators on a large table in the datebase. These queries in turn...
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
December 7, 2011 at 5:17 pm
Sapen (12/7/2011)
I thought to run the victims (EF Generated SQL SELECT queries) through the DETA and see if it recommends any indexes. As expected DETA suggested that there will...
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
December 7, 2011 at 5:12 pm
hxkresl (12/7/2011)
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
December 7, 2011 at 4:57 pm
Viewing 15 posts - 2,131 through 2,145 (of 5,678 total)