Viewing 15 posts - 4,486 through 4,500 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 14, 2017 at 12:21 pm
There's an article on TechNet about this on for SQL 2008-2014, I would hazard a guess that the same would apply for 2016 as well: http://social.technet.microsoft.com/wiki/contents/articles/24364.sql-server-troubleshooting-could-not-find-database-engine-startup-handle-error-during-installation.aspx
If that doesn't...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 14, 2017 at 11:40 am
Both char and varchar are non unicode strings. You don't want to do a conversion to DT_WSTR if your source and destination fields are either of these types. Take the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 14, 2017 at 11:32 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 11:34 am
You need to use a date table. Have a look at Bones of SQL - The Calendar Table[/url]
So, for example, you can then do the following:CREATE TABLE...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 9:26 am
bzoom100 - Friday, January 13, 2017 8:58 AMWill this just copy the node "Description"?
Thank you for your help.
The code I gave you would...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 9:08 am
What do you mean by insert blank rows. Do you mean that you want rows for Months 1-8 and 10 displayed on your top account?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 8:58 am
If you want Powershell/CMD to go straight to sqlcmd, you could make it a shortcut with the command passed through
For example:C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -Command "sqlcmd -S MySQLServer -d TestDB...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 7:51 am
A nice to have, but when using the IFCode tags with SQL, starting a line with -- doesn't display the text in the comments colour. Wrapped in /* */ works...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 5:54 am
This is a bit of guess work based on data you provided in prior posts, and the above but something like this should work:--WITH XMLNAMESPACES(DEFAULT 'MgmsSchema/Business_Information_Detail_Entry') --Not sure if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 5:51 am
Good to hear you got it working.
If you're going to be changing the way you present your data in the presentation layer, always return the data in it's...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 3:34 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 2:03 am
You're SQL language won't make any difference to how format works, no. You define the format using characters, for example dd = two character day, MMM = three character month....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 13, 2017 at 1:45 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 1:29 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 10:01 am
Viewing 15 posts - 4,486 through 4,500 (of 5,109 total)