Viewing 15 posts - 4,966 through 4,980 (of 13,872 total)
November 1, 2017 at 1:20 pm
November 1, 2017 at 11:51 am
November 1, 2017 at 10:45 am
I would change things a little. Your datatypes can be improved to take less space. Make the first three columns non-nullable so that you can create a PK on them....
November 1, 2017 at 10:25 am
A possibility?SELECT DISTINCT
x.term_name
, dir.Direction
FROM
tbl x
CROSS APPLY
(
SELECT Direction = CASE
WHEN
(
x.term_name LIKE '%OUT'
OR x.term_name...
November 1, 2017 at 5:43 am
Have you tried using Regasm to add it to the GAC? That may do it.
October 31, 2017 at 3:06 pm
October 31, 2017 at 1:40 pm
October 31, 2017 at 11:55 am
I have a table
CREATE TABLE tableName(id int primarykey, ProcessName varchar(50) null, IncomeDate datetime null, isProcessed...
October 31, 2017 at 6:31 am
October 31, 2017 at 5:40 am
I query that will be part of a store procedure. the store procedure will be...
October 30, 2017 at 2:01 pm
OK, managed to crack this in the end. Here is some code which may prove useful to others one day. It initiates a TC build and returns the Id of...
October 30, 2017 at 9:18 am
I have to zip files regularly and load them into destination, the destination folder should...
October 30, 2017 at 5:37 am
What is the error if you use DT_TEXT?
October 28, 2017 at 8:59 am
Viewing 15 posts - 4,966 through 4,980 (of 13,872 total)