Viewing 15 posts - 2,386 through 2,400 (of 2,452 total)
this may help...
http://www.sqlservercentral.com/Forums/Topic199758-8-1.aspx#bm199774
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2009 at 5:10 pm
SELECT LTRIM(employeeid) AS employeeID, employeename
FROM dbo.[Table]
WHERE (LTRIM(employeeid) '')
will...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2009 at 3:16 pm
Where are these logs coming from?
Is there any way that you or the developer can "improve" the log files by including a delimiter?
Building on Matt's earlier example I can overcome...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2009 at 12:46 pm
Here is an informative article on ROW_NUMBER()
http://www.sqlservercentral.com/articles/T-SQL/66512/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2009 at 4:30 am
jbarker4682 (8/12/2009)
Lynn Pettis (8/12/2009)
How big is each row (in bytes)? What type of network are you on 10MB/100MB/1000MB? Are connected to the network via a switch or hub?
I'm...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 12, 2009 at 2:28 pm
now many columns and rows are in the tables you wish to compare?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 12, 2009 at 1:29 pm
Hi...
I have a similar scenario...whereby I import from Progress 9.1E (our production system) into SQL (our reporting system)... I use the MAX(IDNO) from the SQL table as the variable in...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 12, 2009 at 12:23 pm
hmmm...
http://codingforums.com/showthread.php?p=849545
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 12, 2009 at 11:56 am
“Caveat Emptor”
I am sure that there are many people in this forum who have, without question, accepted advice from the printed page, an article on the web or that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 5:40 pm
Hi you have posted this in the SS2K5 forum but you have a TIME datatype...I dont think this was introduced until SQL 2008...
If I run this on 2K5 I get...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 1:00 pm
You have another active thread here:
http://www.sqlservercentral.com/Forums/Topic768074-148-1.aspx
is this referring to the same process you are trying to develop in this thread?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 12:31 pm
roundel1900 (8/11/2009)
gah (8/11/2009)
In Control Flow create an "Execute SQL Task" ...In the task editor set the SQL Statement to TRUNCATE TABLE "yourtable"run this before your dataflow task
I don't...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 12:24 pm
can we see the new code ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 6:51 am
In Control Flow create an "Execute SQL Task" ...In the task editor set the SQL Statement to TRUNCATE TABLE "yourtable"
run this before your dataflow task
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 6:13 am
SELECT col1, col2, col3, col4, col5
FROM datatable AS tt
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 4:52 am
Viewing 15 posts - 2,386 through 2,400 (of 2,452 total)