Viewing 15 posts - 7,351 through 7,365 (of 13,876 total)
Sergiy (3/30/2016)
1. Create a "translation" table:
CREATE TABLE #Mapping (
FromChar NCHAR(1) PRIMARY KEY,
ToChar NCHAR(1)
)
INSERT INTO #Mapping ( FromChar, ToChar )
SELECT 1, 'A'
UNION ALL
SELECT 2, 'B'
UNION ALL
SELECT...
March 31, 2016 at 6:10 am
Kevlarmpowered (3/30/2016)
March 30, 2016 at 11:07 am
Sean Lange (3/30/2016)
Lynn Pettis (3/30/2016)
March 30, 2016 at 9:18 am
Can you elaborate on the conversion rule?
Does every character map to another specific character, or is its position within the string also important?
March 30, 2016 at 9:09 am
sqlfriends (3/29/2016)
But for implementing and upgrading to new environment, just want to know to put ssis on a separate server or on the...
March 29, 2016 at 3:27 pm
ramana3327 (3/29/2016)
It works me in this wayInstead of running as proxy account, you can modify the SQL job enter the password at the commandline. It is working fine for me
This...
March 29, 2016 at 10:45 am
Alan.B (3/29/2016)
You would use AND.
SELECT vend_id, prod_id, pro_priceFROM products
WHERE prod_price <=5
AND vend_id IN (1001, 1002);
Disagree. This requires an OR.
select a from b where condition1
union (should probably be union all)
select a...
March 29, 2016 at 10:36 am
diamondgm (3/29/2016)
TomThomson (3/28/2016)
Eric M Russell (3/28/2016)
The stored procedure I'm currently tasked with refactoring reads like a 20 page short story by Clive Barker.
You have my deepest sympathy.
I wrote some of...
March 29, 2016 at 5:20 am
SQL 2016 (3/28/2016)
SELECT customers.cust_name,
customers.cust_id,
Count(orders.order_num) as num_ord
FROM customers INNER JOIN orders
ON...
March 28, 2016 at 5:40 pm
melinda.savoy (3/28/2016)
Yes when I click the CONNECT button in my Connect to Server dialog box.Thanks.
Then I guess that there is some sort of version issue (accessing SSIS 2014 from SSMS...
March 28, 2016 at 2:39 pm
melinda.savoy (3/28/2016)
When I try to "ADD" in my object explorer Integration Services for...
March 28, 2016 at 2:24 pm
What do you mean by this, please? What is being 'added' to what?
When I try to add Integration Services from my desktop
March 28, 2016 at 1:58 pm
Here is your query again, reformatted to help others:
SELECT dbo.Systems.SiteNumber
, Derived_Policy_Audit_Latest.PolicyID
, dbo.PolicyAudit.ProductCode
, ...
March 28, 2016 at 8:39 am
matt 25763 (3/27/2016)
March 27, 2016 at 4:18 pm
May I ask what the purpose is behind these scripts? Are you using them to generate a dev database, or something similar? There may be other ways to do what...
March 27, 2016 at 3:41 pm
Viewing 15 posts - 7,351 through 7,365 (of 13,876 total)