Sean Lange (4/23/2012)

---

Charmer you posted 2 of the 3 requested items and that one is only partially complete. You posted ddl for 4 tables but there is no data for...

herladygeekedness (4/23/2012)

---

Whew, thanks for reporting back! wasn't certain that Google's newest privacy policy would let you back out!! :hehe:

Seriously, tho, I have a string-compare issue myself now also...

GSquared (4/23/2012)

---

If you:

A) Describe what the cursor is doing

B) Provide the table definitions (Create Table scripts)

C) Provide sample data (a dozen or so Insert statements)

then we can probably (almost certainly)...

GSquared (4/23/2012)

---

If you:

A) Describe what the cursor is doing

B) Provide the table definitions (Create Table scripts)

C) Provide sample data (a dozen or so Insert statements)

then we can probably (almost certainly)...

My cursor is taking 1...

I am back..:-)

Yeah, i get the same result with trim and without trim...

but some times i see the columns have spaces in front of the values.....in this case i hope i need...

I'm not really sure. Maybe the function prevents the optimizer from using indexes (as it does if you are not using SARGs in the WHERE clause). The default setting of...

Koen Verbeeck (4/19/2012)

---

The problem is that MSDN is not...

Koen Verbeeck (4/10/2012)

---

You cannot debug a script component using breakpoints, unless SSIS 2012...

rockstar283 (4/2/2012)

---

Hello..I am using a Script component as a source in my DFT..Component contains the following code

public override void CreateNewOutputRows()

{

...

Lowell (3/30/2012)

---

Charmer (3/30/2012)

---

Lowell (3/30/2012)

---

how about a view, so you have the date? is that what you want?

Create view TableToday

AS

select

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) As TheDate,

GETDATE() as TheDateTime,

edit: misread the question...thought you...

Lowell (3/30/2012)

---

how about a view, so you have the date? is that what you want?

Create view TableToday

AS

select

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) As TheDate,

GETDATE() as TheDateTime,

edit: misread the question...thought you wanted a...

Gimme an example Please...

Sean Lange (3/28/2012)

---

At the very least you need define primary keys for every table. Without some way to identify a row you fighting a war you can't win.

Then you should...