Viewing 15 posts - 301 through 315 (of 2,458 total)
There's many ways to tackle this, here's a few:Sample data
CREATE TABLE #TEMP(ID Varchar(200));
INSERT #TEMP
VALUES ('ABC205916_DAN'),('ABC243296'),('ABC222249_DAN25'),('IN217465_v99'),('ABC#243296');
GO
If it's...
March 23, 2017 at 6:40 am
The cmd file works no problem from the command line
March 22, 2017 at 9:07 pm
Correct that this has nothing to do with joins or anything that Joe was talking about.
The += syntax is an example of a compound assignment operator; These...
March 22, 2017 at 6:58 pm
Lynn - I'm good at dealing with XML in SQL too. Post the code and I'll also be happy to take a look.
March 18, 2017 at 3:11 pm
March 15, 2017 at 12:37 pm
January 25, 2017 at 9:27 pm
January 25, 2017 at 9:14 pm
Interesting technique Paul. Well done.
January 16, 2017 at 5:42 am
Jeff Moden (1/7/2017)
Alan.B (1/3/2017)
I found out a few weeks back that my department is moving to Phoenix AZ. I did not chose to transfer so...
January 10, 2017 at 1:53 pm
Fantastic article Hugo. I really love this stairway series - really great stuff.
January 5, 2017 at 8:45 am
You can also try attaching you tables to Excel and format the data however you'd like there. Excel has become a great reporting tool in recent years.
January 4, 2017 at 2:10 pm
Viewing 15 posts - 301 through 315 (of 2,458 total)