Jon.Morisi (4/5/2016)

---

Hi,

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...

Luis Cazares (4/5/2016)

---

I constantly avoid that person's threads. It doesn't...

sks_989 (4/5/2016)

---

I am getting error while i run query. Client id is numeric 18,0 when i run with parameter with ALL it is working, It is in statement

DECLARE @clientid varchar(20)...

clbishop (4/5/2016)

---

Hello. Pardon me, I'm new to both this forum and SQL.

I need assistance with code that will allow me to change the return order of week names. Currently, the...

Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.

swansonm (4/5/2016)

---

This would work if the termDate is the date of the term of that line/effective rate, but not since the termDate is actually the term date of the line...

The error message provides that information, if you read it closely enough.

Your error (as you posted originally) was this:

"Cannot truncate table 'Postal_StateProvince'...

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...

Further to Gail's comment, your options are to either change your TRUNCATEs to DELETEs, or DROP CONSTRAINT / TRUNCATE / CREATE CONSTRAINT.

doasidont (4/5/2016)

---

I created a table using a query, but the table needs an ID column as primary key. First question is: Is there a make table query command that...

In addition, the query would be easier to read if suitable table aliases were used.

Tables should be schema-qualified throughout.

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.

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

...

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...