More for fun but fitting the discussion, kind of before and after:-D

😎

Before

create function sys.fn_numberOf1InBinaryAfterLoc (@byte binary, @loc int)

returns int

as

begin

declare @index int, @mark-3 int, @counter int

...

What are the data types of the stored procedure's parameters? Is it possible that the @IdEmployee is a character type?

Better yet, can you post the procedure code (remove any sensitive...

Quick question, can you do a normal select with the same openrowset statement, something like select * from sysobject?

😎

KGJ-Dev (7/9/2014)

---

When i execute the above query here is the error am getting

Msg 7357, Level 16, State 2, Line 1

Cannot process the object "

...

Koen Verbeeck (7/9/2014)

---

Imo there is not necessarily something wrong with the group by.

The coalesce on the other hand is for people...

Alan.B (7/9/2014)

---

Eirikur Eiriksson (7/8/2014)

---

No need to complicate things, the only thing needed here is correct window specification for the row_number function.

😎 ...This brings the cost of execution for this...

Do you...

Quick question, do you have some sample data?

😎

SQLRNNR (7/9/2014)

---

Eirikur Eiriksson (7/9/2014)

---

...and now the Backups are coming for...

KGJ-Dev (7/9/2014)

---

Hi Eric,

Thakns for your reply and when i execute am getting sysntax error

declare @IdEmployee int = 11,@Name varchar(20) = 'Peter';

EXEC('SELECT *

...

...and now the Backups are coming for a visit this...

Grant Fritchey (7/9/2014)

---

I'll come right out and say it. No, it's impossible to just migrate your database over using any straight method.

I agree with the steps Hanshi laid out...

Quick thought, place the function in a cte and use the output in the insert.

😎

This isn't too much of a challenge and definitely NOT a question of transferring 7TB in 30 min. Here is a quick suggestion:

a. Do a full backup of the 2K...

Without more information, it is impossible to say. Any kind...