While you are working on getting us proper DDL for the 2 tables, can you also clarify your SQL statement?

cast(cb as varchar(12) = b) is not syntactically correct...

You use ROW_NUMBER(...) AS seqnum. Then you join and filter the CTE using WHERE seqnumber = 0. What a waste! Just find the 1 row you want from the...

1. Why are you using that case statement in your CTE? Seems useless at that point.

2. Why are you using the row_number in your CTE? It doesn't look to...

What is your query? Please post DDL and DML.

S_Kumar_S (3/27/2012)

---

Hi

I plan to upgrade a trail version of VS2008 on one of live sql server(2008R2). trial version has already expired and hence I can't use SSIS on this machine....

S_Kumar_S (3/27/2012)

---

To check it with SSIS, I 'll need visual studio on my machine. It is already there but it's a trial version of VS2008 which has already expired 🙁

So...

Charmer (3/27/2012)

---

Hi Friends,

I am having kinda same problem...

I have more than 7 million records in a table.. i was wondering to see how much time to execute and :ermm: it...

The first thing to do is find out what else is accessing this database. Ex. The OP said it was old an unused, but clearly something was accessing...

So you mean to say if I want to modify the maintenance plan from any client, then SSIS should be installed on all clients or do you mean that it...

jackimo (3/27/2012)

---

Jeff,

Thanks for mentioning Partitioning. I've never actually implemented it before. I'm now doing some research and reading. Here is my plan; just testing now....:-)

I have...

Modifying a maintenance plan requires SSIS to be installed, I believe. Do you have that installed? I don't really think there is a difference between the SSMS versions for express...

Can you please look at your post? You keep placing your text within IFCode Shortcuts... Why? Put only your SQL in the [ code = "sql" ][ /code ]...

CREATE FUNCTION dbo.DelimitedSplit8K

-- Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

-- "Inline" CTE Driven "Tally Table" produces values from...

I have to ask... Why are you doing all of this conversion? Did you develop this app or dis someone else? Can you change the way data is stored?...

Standard and higher will provide you with most replication. For Oracle or Peer to Peer, you must have Enterprise ed.