Kyalo (1/7/2013)

---

Thank you Folks, yes I am brand new in this forum. From the two questions, it appears as if I have already included the suggested test data (the two...

Since everyone is playing word games why don't we look at this one:

This should really say:

by default a Primary key creates a...

Not sure why you don't want the cte version, but this works (though untested):

SELECT A.House_acc ,

...

L' Eomot Inversé (1/4/2013)

---

Dineshbabu (1/3/2013)

---

I think few days back same conversation happened... Unique constraint is different from unique index. While creating unique index we can create with filter and that...

Cadavre (1/4/2013)

---

SET NOCOUNT ON;

DECLARE @a DATETIME;

SET @a = GETDATE();

--First

SELECT DATEADD(DAY, 0, DATEDIFF(DAY, 0, @a ));

--Second

SELECT DATEADD(DAY, DATEDIFF(DAY,...

Cadavre (1/4/2013)

---

SET NOCOUNT ON;

DECLARE @a DATETIME;

SET @a = GETDATE();

--First

SELECT DATEADD(DAY, 0, DATEDIFF(DAY, 0, @a ));

--Second

SELECT DATEADD(DAY, DATEDIFF(DAY,...

Cadavre (1/4/2013)

---

10e5x (1/4/2013)

---

So if i have an sql statement in my execute sql task that looks something like this:

Delete from TABLE where (CREATION_D = ?)

CREATION_D is the column i am...

Not enough single quotes in your dynamic sql:

DECLARE @sql VARCHAR(max)

SET @sql = '

; WITH list_cte (table_name,field_name,fld_id,sql_value,field_value,exporttype)

AS

(

SELECT table_name,field_name,fld_id,CAST('''' AS VARCHAR(8000)) as sql_value, CAST('''' AS VARCHAR(8000)) AS field_value,exporttype

FROM #configdetail

WHERE LEN(LTRIM(RTRIM(table_name))) >...

Took this a bit further. You...

Sean Lange (1/4/2013)

---

Agreed. Your best option is to use datetime. I would strongly urge you not to do something you will regret like using a varchar for datetime. If you...

karthik_ayyagari (1/4/2013)

---

Yes Maz,

For the time being can you write a procedure which can calculate number of weekends between two datetimes so that i can delete the n*48 hrs from the...

I don't have time right now to do anything real with the code, but if anyone is interested I have reformatted the code to make it a little bit easier...

Bhuvnesh (1/3/2013)

---

i tried it with PIVOT but its more resource intensive (as compared to other provided solution ) . can we avoid UNION here

SELECT CompanyName, 'Low' as Type,

[Sunday],...

zombieisdead2020 (1/3/2013)

---

The recursive CTE may not scale well as the length of the strings increase. Both sets of options really need to be tested to determine which is better...

zombieisdead2020 (1/3/2013)

---

declare @t table(id int, string varchar(500))

insert @t values (1,'abcABC,0123456789~!@'),(2,'123abcdefghijklmnopqrstuvwzyz');

with cte1 as

(

select id,

0 nbr,

cast(string as...