Be...

Answer: Yes.

Next Question: How?

Next Answer: Please post DDL and sample data. See the first link in my signature for more help if you need it.

pop up a SSIS package with a single data flow item, then put in your three OLEDB sources and destinations in the flow.

Define your source and target server in the...

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...

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...

GilaMonster (11/8/2010)

---

Certainly. When would you like us to get started on those 400-800 pages?

I'm not joking. To cover any one of those topics in moderate detail is a large...

goodguy (11/8/2010)

---

I believe that programmers, especially freelancers like me, need to embrace basic sql admin skills in order to leverage their output. The reason they have not done so so...

Grant Fritchey (11/8/2010)

---

Let me put a question back at you. Since most of the topics you outline have extensive documentation, courseware, books, etc., how do you propose getting developers to...

snoop123 (11/8/2010)

---

we are using a SQL server 2005 SP3. i have been monitoring the pagelife expectancy and buffer cache hit ratio .the cache hit ratio is

maintaining around 99 but...

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...

I guess I need to learn intersects. 😉

And before I'd worry about isolation...

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...

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...

MonsterRocks (11/7/2010)

---

wht will be the query to find all the menu available in menu id 1?... any help?

-- master table

---------------------------

menu id menuname

1 ...

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...