SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

X002548
Not Just a Number

15586 Posts

Posted - 10/11/2006 :  11:02:03  Show Profile  Reply with Quote
"Any Ideas"

Yeah, hire a dba



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/16/2006 :  14:19:10  Show Profile  Reply with Quote
Just keep posting new topics with the same question, and sooner or later someone will be able to read your mind and figure out what you want.


http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73584

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73581

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73534



CODO ERGO SUM
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30249 Posts

Posted - 10/16/2006 :  14:29:27  Show Profile  Visit SwePeso's Homepage  Reply with Quote
To quote
quote:
He is a Rain Man, without the math skill


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/16/2006 :  14:48:09  Show Profile  Reply with Quote
quote:
Originally posted by Peso

To quote
quote:
He is a Rain Man, without the math skill


Peter Larsson
Helsingborg, Sweden



I'm a good DBA,
I'm a good DBA...





CODO ERGO SUM
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/16/2006 :  14:49:58  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by Peso

To quote
quote:
He is a Rain Man, without the math skill


Peter Larsson
Helsingborg, Sweden



I'm a good DBA,
I'm a good DBA...





CODO ERGO SUM



Make sure you click your ruby slippers 3 times



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30249 Posts

Posted - 10/17/2006 :  06:16:38  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I am the mood now for some serious bitch-slapping...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73610


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 10/17/2006 06:20:08
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/17/2006 :  10:05:07  Show Profile  Reply with Quote
How does one begin to answer this one?

http://www.dbforums.com/showthread.php?p=6237541&posted=1#post6237541



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 10/18/2006 :  09:51:37  Show Profile  Reply with Quote
Its back!!!!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72614

EDIT:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70055
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72310
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70009
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69990

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Edited by - DonAtWork on 10/18/2006 09:58:17
Go to Top of Page

qailoh
Starting Member

4 Posts

Posted - 10/18/2006 :  11:50:30  Show Profile  Reply with Quote
I joined this forum just so I could follow this fascinating saga...
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/18/2006 :  11:59:35  Show Profile  Reply with Quote
I want to replace all of my street suffixes with margarita





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/18/2006 :  15:39:56  Show Profile  Reply with Quote
quote:
Originally posted by DonAtWork

Its back!!!!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72614

EDIT:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70055
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72310
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70009
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69990

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp



He reminds me of that movie Groundhog Day where he lives the same day over and over.

It’s like he wakes up and starts the same thread again every day.

What I don’t understand is why anyone responds to his posts anymore.






CODO ERGO SUM

Edited by - Michael Valentine Jones on 10/18/2006 15:49:18
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30249 Posts

Posted - 10/19/2006 :  02:22:38  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

He reminds me of that movie Groundhog Day where he lives the same day over and over.
It’s like he wakes up and starts the same thread again every day.
Thank you, Michael! This is a very memorable post.
Now my week (and next) is saved. When it is getting boring, I just look up this reply again


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 10/19/2006 02:23:33
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 10/19/2006 :  07:26:17  Show Profile  Reply with Quote
I have noticed a slight attitued in St.Peter's responses. He starts out with things like "Where do I even begin?"

Next we are going to see "Are you stupid?!?"



[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30249 Posts

Posted - 10/19/2006 :  07:30:45  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Actually I wrote "Are you insane?"
In this answer http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73540#263630

He really got to my nerves, but after that I realized that the problem itselt was interesting. At the end, I got a optimized solution http://www.sqlteam.com/forums/topic.asp?whichpage=2&TOPIC_ID=73610#264068
that is fast and works every time. But there is only one problem with the code. I can't select from the table #GiveAway! I hade to use double # as ##. Can anyone explain why?

But I was upset with his manner to occupy resources on several forums and he didn't listen to any of us.


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 10/19/2006 07:39:22
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 10/19/2006 :  07:31:27  Show Profile  Visit spirit1's Homepage  Reply with Quote
as i said... i'll give him until 3k



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 10/19/2006 :  08:29:10  Show Profile  Visit spirit1's Homepage  Reply with Quote
you constructed your #temp table with dynamic sql and it got created in the scope of the EXEC() statment.
once exec() finished the #temp table was dropped.
##Global temp tables are however perserved.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp

Edited by - spirit1 on 10/19/2006 08:29:43
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/19/2006 :  12:17:24  Show Profile  Reply with Quote
quote:
Originally posted by spirit1

you constructed your #temp table with dynamic sql and it got created in the scope of the EXEC() statment.
once exec() finished the #temp table was dropped.
##Global temp tables are however perserved.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp



I really try to avoid ##temp tables, but in some cases it is hard to do. For example, when you want to BCP the table out.

I use a NEWID() to create the table name to avoid the possibility of a collision if two people are running the same procedure at the same time. It can be really hard to track that down if it is happening. We specifically check for ## table before moving procedures into production, and only allow it if it is really needed, and the name is generated dynamically with a NEWID()


declare @temp_table_name sysname
set @temp_table_name = '##temp_'+replace(newid(),'-','')

exec ('create table '+@temp_table_name+' ( MyCol int not null )')

exec ('insert into '+@temp_table_name+' select 1' )
exec ('select * from '+@temp_table_name )
exec ('drop table '+@temp_table_name )


CODO ERGO SUM
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 10/19/2006 :  12:52:53  Show Profile  Visit spirit1's Homepage  Reply with Quote
i do the same thing.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 10/19/2006 :  13:10:06  Show Profile  Reply with Quote
You realize that if you don't help him pass this class, he will just have to take it all over again next semester...OK, imagining he can be helped was a bit of wishful thinking.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/19/2006 :  13:25:16  Show Profile  Reply with Quote
Only if it's created in the thread BEFORE and Referenced in the thread that launched the dynamic sql

If not, then any global in a spawned dynamic thread thhat was not referenced would go bye-bye as well



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000