Viewing 15 posts - 5,761 through 5,775 (of 15,381 total)
Luis Cazares (2/5/2014)
I might not be realizing the problem that Sean is talking about...
Or maybe my brain is making it harder than it really is. 🙂
February 5, 2014 at 5:27 pm
pamozer (2/5/2014)
thanks. I found the funky data. I hate when its something so stupid. I appreciate your help and time.
No problem. I going to guess that you...
February 5, 2014 at 3:53 pm
hifaizal90 (2/5/2014)
I have updated my post . please refer the comments above.Many thanks for your contribution and support towards to me .
Thanks for the updated info. The problem here is...
February 5, 2014 at 3:52 pm
You must have something funky in your data. The insert you posted works perfectly fine with either query.
What about this one?
select app.endtm
FROM dbo.[_import_2_1_AppointmentsWorking] AS app
where isnumeric(app.endtm) = 0
February 5, 2014 at 3:47 pm
pamozer (2/5/2014)
February 5, 2014 at 2:41 pm
That is because your intellisense needs to be refreshed. ctrl+shift+r
Wait a couple seconds and the "red squigglies" will go away.
February 5, 2014 at 2:22 pm
Can you post your sample data as insert statements?
February 5, 2014 at 1:02 pm
SQLRNNR (2/5/2014)
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
February 5, 2014 at 12:51 pm
Duplicate thread. Please direct replies here. http://www.sqlservercentral.com/Forums/Topic1538311-391-1.aspx
February 5, 2014 at 12:45 pm
Well as I quoted previously and tried to point out from BOL, if you pass NULL as the Offset it will APPEND the existing data.
Since we don't have table structures...
February 5, 2014 at 12:42 pm
WayneS (2/5/2014)
Sean Lange (2/4/2014)
February 5, 2014 at 12:32 pm
Jeff Moden (2/5/2014)
Sean Lange (2/5/2014)
I am pretty sure that Jeff was thinking of using the DelimitedSplit8K function for this.Correct and well done. Thanks for the cover, Sean.
My pleasure.
February 5, 2014 at 9:22 am
I am pretty sure that Jeff was thinking of using the DelimitedSplit8K function for this.
I create the ddl and sample data for you to demonstrate how you should post this...
February 5, 2014 at 8:31 am
Hi and welcome to the forums. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form...
February 5, 2014 at 8:21 am
vahid.arr (2/5/2014)
I have two table that have many to many relationship so i add table between them.and this table column is Id of each table.my question is i want...
February 5, 2014 at 8:19 am
Viewing 15 posts - 5,761 through 5,775 (of 15,381 total)