The way I troubleshoot this kind of thing is to run each section of the query individually until I get the error that is being returned when I run the...

It's not a...

This should do the trick. This solution uses delimitedsplit8K which is referenced in my signature. Note my comments.

USE tempdb

GO

-- ingest the text as varchar(8000) or varchar(max) is you might receive...

TFS perhaps.

Try resetting the password and try again or check the username spelling.A bad username or password or the only reasons Ice ever seen that error. You could also try a...

DelimitedSplit8K is not built in, you need to create it. For...

SilverBack (4/22/2016)

---

I can get my code to return results like I want in SQL Studio however in SSRS

I can not get results they just come back blank. Any ideas by...

ffarouqi (5/5/2016)

---

Alan.B (5/4/2016)

---

A couple things here.

First, the message is pretty clear. The SSIS package is failing because the login for SA, inside at least one of your SSIS connection...

There's the old joke, "guy goes to the doctor and says, 'Doc, it hurts when I do this...' so the doctor says, 'don't do that'."

I digress, can you post the...

Here's a fun solution that uses all three T-SQL set operators.

DECLARE @table1 TABLE (col1 char(3) unique);

DECLARE @table2 TABLE (col1 char(3) unique);

INSERT @table1 VALUES ('a 1'), ('b 2'), ('c 4');

INSERT @table2...

This solution assumes that your sequences are always going to be 6 characters long...

Taking Luis' brilliant solution and turning it into a scalar UDF like this:

CREATE FUNCTION dbo.SeqRank (@number CHAR(6))

RETURNS...

It's interesting, a Google search does not return any useful info. Apparently Microsoft has pulled anything abut 2005. Another reason to upgrade I suppose.

All I can say is, give it...

I have had this exact same problem before. If you're developing the report in SSDT then restarting SSDT then trying again sometimes resolves the problem. Sometimes the only thing you...

This may help: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/%5B/url%5D

No problem. Glad to help.