TomThomson (6/10/2014)

---

As neither SQL nor T-SQL supoprts a complex number type, it's quite clear that the extended...

N_Muller (6/10/2014)

---

Is there a limit on the size of the strings on both sides of the '=' sign for string comparison? If I have two varchar(max) strings, will the...

What have you tried so far?

😎

subbubally (6/9/2014)

---

Hi Eirikur,

Thanks for your reply, i already tried this solution too, if we go by concatenation, there may be performance in future, that's the reason, i avoided...

You need a little bit of trickery here.

😎

USE tempdb;

GO

SELECT

(

SELECT

...

rockstar283 (6/9/2014)

---

IMHO, the simplest way is to restore a backup of production over the dev with replace unless the size is an issue. The second bird you hit with this...

Thanks for the explanation:-)

There is not much difference in the actual work though, the matching "old" values must be selected from the existing set, based on which ever matching criteria....

rockstar283 (6/9/2014)

---

My objective was to refresh the Test server with the live data, so that we will have some realistic data to test with and it needs to be done...

ayazniazi (6/9/2014)

---

It is a Foreach ADO Enumerator

In the enumerator configuration I have set the object source variable to subtaskArgs which is an Object variable.

In variable mappings I have subtaskArgValue which...

clucasi (6/9/2014)

---

Hi,

I am trying check if a files exists and if so continue with the procedure and if not exit out of the Procedure.

the code I used below but it...

This should get you started

😎

DECLARE @SXML XML = N'<ClMetadataDataContract xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.cch.com/pfx.net/psi/">

<EntityType>1</EntityType>

<NameLine1>David Jones</NameLine1>

<NameLine2 />

<DefId />

<ClientID>jones</ClientID>

<ClientSubID />

<SortName />

<ClientType />

</ClMetadataDataContract>';

DECLARE @TXML TABLE

(

TXML_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT...

Thank you Ed for this very good peace, nicely done indeed!

😎

abuhaidar82 (6/9/2014)

---

Thanks for the reply, i will try to upgrade the application to VB2008, if i can find the source code :-D, because it's not my program..

anyway could vb2008 conver...

Ed's version modified to show missing ranges.

😎

USE tempdb;

GO

DECLARE @num AS TABLE (

ID INT IDENTITY(1, 1),

Price Money);

DECLARE @range AS TABLE (

ID INT IDENTITY(1, 1),

...

gstarsaini (6/9/2014)

---

Hi,

I have nearly 1 TB of CSV file data .I need to load this data into SQL database using SSIS.What is the best way to perform this(or how). Also...