Showing posts with label particular. Show all posts
Showing posts with label particular. Show all posts

Monday, March 26, 2012

duplicate in text file

I have my SQL server reads a text file into a temp table, then it copies
that data over to a main table, but it looks to see if a particular filed
has a certain value, if it does, it updates that record instead of creating
a duplicate.
But, what I am finding is that if the text file has duplicate records in it,
it will duplicate into the main table.
Any ideas on how I can weed out duplicates from the text file that I am
importing?
You can add an intermediate process to remove the duplicates after they are
loaded into the temp table and before perorming the insert or the update to
the main table.
"Johnfli" wrote:

> I have my SQL server reads a text file into a temp table, then it copies
> that data over to a main table, but it looks to see if a particular filed
> has a certain value, if it does, it updates that record instead of creating
> a duplicate.
> But, what I am finding is that if the text file has duplicate records in it,
> it will duplicate into the main table.
> Any ideas on how I can weed out duplicates from the text file that I am
> importing?
>
>
|||Can't you insert everything into the temp table -- the do the SELECT
DISTINCT at the temp table? prior to entering into the main table
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Johnfli" <john@.ivhs.us> wrote in message
news:%23SPhtYdLGHA.2216@.TK2MSFTNGP09.phx.gbl...
> I have my SQL server reads a text file into a temp table, then it copies
> that data over to a main table, but it looks to see if a particular filed
> has a certain value, if it does, it updates that record instead of
creating
> a duplicate.
> But, what I am finding is that if the text file has duplicate records in
it,
> it will duplicate into the main table.
> Any ideas on how I can weed out duplicates from the text file that I am
> importing?
>

duplicate in text file

I have my SQL server reads a text file into a temp table, then it copies
that data over to a main table, but it looks to see if a particular filed
has a certain value, if it does, it updates that record instead of creating
a duplicate.
But, what I am finding is that if the text file has duplicate records in it,
it will duplicate into the main table.
Any ideas on how I can weed out duplicates from the text file that I am
importing?You can add an intermediate process to remove the duplicates after they are
loaded into the temp table and before perorming the insert or the update to
the main table.
"Johnfli" wrote:
> I have my SQL server reads a text file into a temp table, then it copies
> that data over to a main table, but it looks to see if a particular filed
> has a certain value, if it does, it updates that record instead of creating
> a duplicate.
> But, what I am finding is that if the text file has duplicate records in it,
> it will duplicate into the main table.
> Any ideas on how I can weed out duplicates from the text file that I am
> importing?
>
>|||Can't you insert everything into the temp table -- the do the SELECT
DISTINCT at the temp table? prior to entering into the main table
--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Johnfli" <john@.ivhs.us> wrote in message
news:%23SPhtYdLGHA.2216@.TK2MSFTNGP09.phx.gbl...
> I have my SQL server reads a text file into a temp table, then it copies
> that data over to a main table, but it looks to see if a particular filed
> has a certain value, if it does, it updates that record instead of
creating
> a duplicate.
> But, what I am finding is that if the text file has duplicate records in
it,
> it will duplicate into the main table.
> Any ideas on how I can weed out duplicates from the text file that I am
> importing?
>

duplicate in text file

I have my SQL server reads a text file into a temp table, then it copies
that data over to a main table, but it looks to see if a particular filed
has a certain value, if it does, it updates that record instead of creating
a duplicate.
But, what I am finding is that if the text file has duplicate records in it,
it will duplicate into the main table.
Any ideas on how I can weed out duplicates from the text file that I am
importing?You can add an intermediate process to remove the duplicates after they are
loaded into the temp table and before perorming the insert or the update to
the main table.
"Johnfli" wrote:

> I have my SQL server reads a text file into a temp table, then it copies
> that data over to a main table, but it looks to see if a particular filed
> has a certain value, if it does, it updates that record instead of creatin
g
> a duplicate.
> But, what I am finding is that if the text file has duplicate records in i
t,
> it will duplicate into the main table.
> Any ideas on how I can weed out duplicates from the text file that I am
> importing?
>
>|||Can't you insert everything into the temp table -- the do the SELECT
DISTINCT at the temp table? prior to entering into the main table
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Johnfli" <john@.ivhs.us> wrote in message
news:%23SPhtYdLGHA.2216@.TK2MSFTNGP09.phx.gbl...
> I have my SQL server reads a text file into a temp table, then it copies
> that data over to a main table, but it looks to see if a particular filed
> has a certain value, if it does, it updates that record instead of
creating
> a duplicate.
> But, what I am finding is that if the text file has duplicate records in
it,
> it will duplicate into the main table.
> Any ideas on how I can weed out duplicates from the text file that I am
> importing?
>

Wednesday, March 21, 2012

Dumping all SQL queries.

Hi - is it possible to dump the query text of every query run
against a particular database, or all databases, in an SQL Server
2000 installation? We've an issue whereby a 3rd. party application
running queries over ODBC sometimes claims that gobbledegook is
returned, and it would be very useful to identify the query that's
being claimed is the problem. I suspect that it's an application
issue rather than a SQL Server one.

__________________________________________________ ___________
Are you Catholic ?
http://www.CatholicEmail.com

100s of FREE email addresses -->
http://www.UltimateEmail.com

Send an Online Greeting Card http://www.UltimateEcards.com"sqlserver yeahbaby" <Use-Author-Address-Header@.[127.1]> wrote in message
news:20031104161149.53F073965@.sitemail.everyone.ne t...
> Hi - is it possible to dump the query text of every query run
> against a particular database, or all databases, in an SQL Server
> 2000 installation? We've an issue whereby a 3rd. party application
> running queries over ODBC sometimes claims that gobbledegook is
> returned, and it would be very useful to identify the query that's
> being claimed is the problem. I suspect that it's an application
> issue rather than a SQL Server one.

Look at profiler.

> __________________________________________________ ___________
> Are you Catholic ?
> http://www.CatholicEmail.com
> 100s of FREE email addresses -->
> http://www.UltimateEmail.com
> Send an Online Greeting Card http://www.UltimateEcards.com

Wednesday, March 7, 2012

Dual axes in RS2k5

I seem to remember reading that in Reporting Services 2005 it would be
possible to create column charts with dual axes, in particular with a dual y
axis.
I've been playing around with the charts but I can't seem to find a way to
do this. Did this functionality find its way into the product in the end? How
is it done?
Thanks,
Matt.Hi Matt,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood would like to know whether Dual axes
will be supported in SQL Server 2005 Reporting Services. If I have
misunderstood your concern, please feel free to point it out.
Unfortunately, dual axes are not supported in the built-in charting
included with SQL Server 2005 RS. However, Dundas (see
http://www.dundasreporting.com/home/index.aspx) will be providing a plug-in
that supports this functionality.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.