Viewing 15 posts - 2,206 through 2,220 (of 5,678 total)
Use the DMVs.
master.sys.databases
<database>.sys.tables
<database>.sys.columns
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 29, 2011 at 2:30 pm
I think you're over-thinking it SQL-Dude.
Think more like this:
CREATE TABLE Bldg (BldgName VARCHAR(20) NOT NULL CONSTRAINT PK_Bldg PRIMARY KEY CLUSTERED)
-- Floor is a SQL Function and keyword
CREATE TABLE Floors
(FloorName...
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 29, 2011 at 2:27 pm
The other option is to force the datatype on the select before it hits the select into.
IE: SELECT CONVERT( varchar(9), xyz.fLeft_Pad('0', Str(123456789),9))
At that point though you might as well define...
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 29, 2011 at 2:13 pm
Hey Dougie,
Don't feel bad about this code, that's some signficantly nasty iterations they've got going there. Have you been having performance problems with this code as well?
Can you script...
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 29, 2011 at 2:07 pm
I'd personally approach it via the second method, at least for the primary build, but I wouldn't associate room to floor and building, I'd merely associate it to a floor...
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 29, 2011 at 1:54 pm
Dev (11/28/2011)
Jeff Moden (11/24/2011)
PaulB-TheOneAndOnly (11/22/2011)
All reporting should happen in a database other than OLTP either a "Reporting" database or a properly structured "Data Warehouse"
Although that's the general concensus,...
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 29, 2011 at 12:47 pm
Jeff Moden (11/21/2011)
Evil Kraig F (11/21/2011)
Any SQL services or tools to aid in this?
Not really.
What about table partitioning or even partitioned views?
You're correct, Jeff, I'm just concerned about using partitioning...
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 29, 2011 at 12:45 pm
Sorry it took a bit to get back to this, pesky Thanksgiving...
Alexander Suprun (11/24/2011)
I've played around with your scripts and here are my thoughts and findings:
I see why you've...
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 29, 2011 at 12:38 pm
Kiara (11/29/2011)
Evil Kraig F (11/28/2011)
Evil Kraig F (11/28/2011)
That's just screaming someone hit the wrong dropdown option for title... but seriously, don't they do skillset matching anymore for email dumps?
Title:...
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 29, 2011 at 12:13 pm
f.panci (11/29/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
November 29, 2011 at 12:09 pm
sql_er (11/29/2011)
Do you have additional comments now?
As mentioned above, it's the same problem. , + CR to CR or , to blank and leaving the CR alone leaves the...
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 29, 2011 at 11:12 am
At first glance, you'll need to use the directory or filesystem commands in a script object to read the attributes of the file, edit a local SSIS variable used as...
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 29, 2011 at 1:38 am
derekr 43208 (11/28/2011)
Something like this
start /wait <CD or DVD Drive>\setup.exe /qn
INSTANCENAME=<InstanceName>...
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 29, 2011 at 12:32 am
Faye Fouladi (11/28/2011)
when bv.SpotDescription <> 'Spot Description' Then
pf.SpotDescription = bv.SpotDescription
End,
instead of the line that says:
pf.SpotDescription = bv.SpotDescription
I keep getting an error: Incorrect syntax...
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 28, 2011 at 6:44 pm
You want it to look like:
insert into #t1(col1, col2, col3, col4, col5)
Select
col1, col2, col3, col4, col5
from
R1
where
R1.col1 > 0
and R1.col5 = 1
and R1.col1...
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 28, 2011 at 5:41 pm
Viewing 15 posts - 2,206 through 2,220 (of 5,678 total)