SqlBulkCopy Tutorial - Knowledge Base (KB)

New to SQL - Trouble getting quarterly date output

I'm really new to sql and databases in general. Trying to teach myself the language but I'm stuck and would like to know what's wrong. So here's what I have:...1976-01-01,6.1 1976-04-01,5.7 1976-07-01,5.7 1976-10-01,5.8 .........And I'm inserting it into...

How to skip same duplicate key data when copy table

I have a table1(key is X, XX) looks like below:...x,y,xx,yy,xxx,yyy ...I created a new table2 (key is code) as below:...code,name,xx,yy,xxx,yyy ...Now I wan to copy all data in table1 to table2, and if met same code skip it, ...x -> code Y -> name xx-> xx...