Hey, wasn't there not a similar case. That a big company was split by law? into several smaller pieces. Can't remember the name. Was it AT&T?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you give more details what you want to do?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

I'm not aware of anything within SQL Server which would tell you this information.

---

unless you...

Normally I would say you see a trash icon above the posts you make. but you are the second recently who states that this is not possible.

Maybe Andy, Brian...

...read the article Steve mentioned, and think that everyone's free to speak one's mind.

....and everyone's free not to listen to.

Well, one interesting thing I've read somewhere is that, while Linux...

Not sure what your whole code looks like, but have you considered the use of DATENAME to determine the month?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Sorry, for the typo

Edited by - Frank...

Not sure if I understand everything

You're not after how to pass a parameter with the @ sign, right

You're looking for a way to dynamically change a variable declaration in a...

...but to answer the question, as an example you might want to take a look at

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=19663 on recursive stored procedures

Frank

http://www.insidesql.de

http://www.familienzirkus.de

<*big grin*>

Goostel's ASCII art remind me of some lunch break fun.

http://www.hsk.dk/note/kuriosa/cow-complete.html

Enjoy your meal!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Honestly, I wish I would have a need to be more in DTS, but I only import and export Excel and csv files and that's very straightforward

And to add another...

Thses links might help you

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14076

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14563

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Especially since I do not have the chance to use SQL Server to any depth on a daily basis. With all this...

Not much help, I guess.

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17451

In addition, I know there is a T-SQL command FORMATMESSAGE, but after reading this https://www.appsecinc.com/Policy/PolicyCheck2021.html I decided not to use

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Please avoid cross posts!

See http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17899

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I don't know Oracle, but if I haven't totally misunderstood the theoretical approach behind DBMS there shouldn't be a difference in positioning columns in a table. Also ordering of rows...