DataAnalyst011 (8/27/2013)

---

Thanks to you both - I really appreciate the advice. It looks like I'm out of luck: the connection made always uses SQL Server. But this saved me a...

anupam.jha (8/26/2013)

---

Sean Lange (8/26/2013)

---

anupam.jha (8/26/2013)

---

I need to create around 26000 Views whose scripts are ready.

But, some of the views are dependent on other views. Thus, I am not able to...

Claudio Pinto (8/26/2013)

---

Hi Koen,

Thank you for your support

These are table definitions and sample values for contact_link.cs_seqno 20 assuming that contact cs_seqno 20 is the first contact that has a phone...

Deja vu...I think you have...

anupam.jha (8/26/2013)

---

I need to create around 26000 Views whose scripts are ready.

But, some of the views are dependent on other views. Thus, I am not able to create the Views...

DataAnalyst011 (8/26/2013)

---

I've been trying on this one for a while. I implemented change data capture, but I found interpreting some of the columns difficult (even after reading through several articles...

Use ROW_NUMBER. http://technet.microsoft.com/en-us/library/ms186734.aspx

I would recommend breaking this into batches of 10k rows or so. A single insert with 13 million rows is going to kill your logs. This is one of those...

You are missing parenthesis. But you can actually streamline this quite a bit. I think you are looking for something along these lines.

WHERE SV00300.DATE1 Between (@Start_Date) and (@End_Date)

and

(

SV00300.CUSTNMBR in...

vignesh.ms (8/26/2013)

---

Hi Everybody,

Im using following query, is there any other alternative way?

MERGE DistinctData AS TARGET

USING DataTable AS SOURCE

ON (TARGET.msisdn = SOURCE.Charged_party_number)

WHEN NOT MATCHED BY TARGET THEN

INSERT (msisdn)...

Your question topic suggests you want the first row but in your example it is different.

Could it be as simple as this:

Where phone like '6%'

wolfkillj (8/23/2013)

---

Resealing concrete counters is easy enough that...

patrickskelton (8/24/2013)

---

I see. Thank you for those replies. Got it working now.

(Now I only have 1,999,999 questions still to ask. Into the forums, I think.)

Kind wishes ~...

farrukhhameed786 (8/23/2013)

---

Hello all,

I need two sample sqlserver queries

1. query get the data 1st date of the month to calendar week like week 1 , week 2 , week 3...

patrickskelton (8/23/2013)

---

Hi,

I am a complete beginner developing with MSSQL.

I have just created my first stored procedure in Visual Studio. If I try to use the keyword 'GO', I get...