Viewing 15 posts - 2,116 through 2,130 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2018 at 8:33 am
At work, the answer is no. We're a heavy Windows environment, so integration would be a lot harder than using Windows. We're also heavy users of both SSIS and SSRS;...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2018 at 3:26 am
When you say you want to get it into the database what do you mean? SQL Server has an xml datatype, so do you mean simply store the xml in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2018 at 1:52 am
Yep... still a wicked bad idea. They should use dates, instead. If they...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 1, 2018 at 10:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 1, 2018 at 9:58 am
How about...
USE Sandbox;
GO
/*
All odd alignment issues courtesy of SSC's text editor 🙂
*/
CREATE TABLE SampleTable (ID int IDENTITY(1,1),
StartDay varchar(9),
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 1, 2018 at 9:32 am
Out of the box, no, not really. You might be able to find something in the default trace, however, the only way to guarantee this is to set something out...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 1, 2018 at 2:17 am
Thismmight even be something that can be done with project Variables as well, as opposed to environments. It depends if you have your dev and production database on the same...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 30, 2018 at 2:38 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 30, 2018 at 8:49 am
It honestly surprises me how many people still leave themselves open to SQL injection. Parametrisation and the use of QUOTENAME (in SQL Server) make a query infinitely easier...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 30, 2018 at 8:10 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 30, 2018 at 2:03 am
You can't really customise the look of SSMS, no, you just have the 3 theme options, Light, Blue and Dark (which is a hidden theme).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 30, 2018 at 1:59 am
The following code doesn't make sense:@[user::input file folder] + @[user::File Name] = \\ABC105.SSN.MERIT.PHILIPS.COM\VIPP_HT_Bckup_28-12\Actual load\2018\Mar_2018attachment_1
Firstly, you're trying to assign the value to 2 different variables which...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 30, 2018 at 1:56 am
Just noticed something in the post. ISNULL isn't the same as a CASE, that's COALESCE. ISNULL and COALESCE do operate different; especially when different data types are involved in the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 27, 2018 at 12:23 pm
You could use the old stuff method:STUFF(ISNULL(', ' + Addr1,'') + ISNULL(', ' + Addr2,'') + ISNULL(', ' + Addr3,'') + ISNULL(', ' + Addr4,'') + ISNULL(', ' +...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 27, 2018 at 10:15 am
Viewing 15 posts - 2,116 through 2,130 (of 5,109 total)