Viewing 15 posts - 7,321 through 7,335 (of 13,876 total)
Jon.Morisi (4/5/2016)
Can someone please help me navigate the SSDT waters?
I just setup SQL Server 2014 and would like to do some SSIS package development. Hopefully I can avoid paying...
April 5, 2016 at 11:06 am
Luis Cazares (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
I constantly avoid that person's threads. It doesn't...
April 5, 2016 at 10:42 am
sks_989 (4/5/2016)
DECLARE @clientid varchar(20)...
April 5, 2016 at 10:20 am
clbishop (4/5/2016)
I need assistance with code that will allow me to change the return order of week names. Currently, the...
April 5, 2016 at 10:00 am
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
April 5, 2016 at 9:43 am
swansonm (4/5/2016)
April 5, 2016 at 9:39 am
The error message provides that information, if you read it closely enough.
April 5, 2016 at 9:05 am
Welsh Corgi (4/5/2016)
Phil,Thanks for your input.
I had already tried deleting before making this post but I got the same error.
--
Your error (as you posted originally) was this:
"Cannot truncate table 'Postal_StateProvince'...
April 5, 2016 at 8:09 am
Are there any 'singular spaces' anywhere else in the data?
If yes, you have a very solid basis on which to complain to the creators of the files – how would...
April 5, 2016 at 7:35 am
Further to Gail's comment, your options are to either change your TRUNCATEs to DELETEs, or DROP CONSTRAINT / TRUNCATE / CREATE CONSTRAINT.
April 5, 2016 at 7:29 am
doasidont (4/5/2016)
April 5, 2016 at 6:27 am
In addition, the query would be easier to read if suitable table aliases were used.
Tables should be schema-qualified throughout.
April 5, 2016 at 4:52 am
Please attach an actual execution plan and DDL for all the tables.
Also tell us what you have tried so far and your ideas about what the underlying problems may be.
April 5, 2016 at 4:41 am
OK, let me try again with this post.
I have some questions about your sample code. Looking only up to the end of the first APPLY:
select top 10
...
April 4, 2016 at 6:16 pm
So am I right in thinking that the number of columns which you are returning depends on the number of rows in the temp table? There's some unusual stuff going...
April 4, 2016 at 6:12 pm
Viewing 15 posts - 7,321 through 7,335 (of 13,876 total)