Try this on for size:

DECLARE @ProdCodes AS TABLE (

Prefix varchar(8),

Code varchar(5),

[Type] varchar(20)

);

INSERT INTO @ProdCodes (Prefix, Code)

VALUES

('b', 'CH0'),

('b', 'CH1'),

('b', 'CH2'),

('b', 'CHX'),

('b', 'CM0'),

('b', 'CM1'),

('b', 'CM2'),

('b', 'CMX'),

('b',...

.Netter (7/8/2015)

---

Hi thanks for your help, that seems to be working I did receive duplicate profiles again but I managed to resolve that by using DISTINCT on my select...

pwalter83 (7/8/2015)

---

Hi,

I am stuck at a requirement which is how to handle space between multivalue parameter values in SSRS. For e.g. if the values are as follows -'KLO LUG', 'HGY...

How about the following as a base from which to expand it to fit the need:

DECLARE @Rows AS INT = 1000000; -- One million rows

DECLARE @SampleSize AS INT =...

tcronin 95651 (7/8/2015)

---

trying to stay PC with rest of IT, but EMC did take a peek and saw numbers they could not believe. Disk queue spikes over 10000 MS...

phosplait (6/16/2015)

---

So it seems this is definitely an issue of parameter sniffing.

While option(recompile) did nothing, option(optimize for unknown) brought the dynamic query down to 3 seconds. Still slower, but I...

So... did the restore work ? It's usually considered good forum etiquette to post back with details on what the solution was and whether any help received was useful.

Any chance that one of the paths in the SAN fabric went offline ? How about a problem NIC for the SAN fabric? Check your event logs...

SAMDEV (6/5/2015)

---

I have a specific need in which I need to convert BLOB data to VARBINARY.

When I execute below statement, it gives me error - "ORA-000907: missing right parenthesis" whereas...

Casper101 (7/7/2015)

---

Hi,

We have a high volume database with 1000's of users and 1000's of procs. Our application enforces a 20 second timeout on all connections.

We can't adjust the 20...

dhanekulakalyan (7/7/2015)

---

Hi All,

I have a detailed report in ssrs in which data can come from start date and end date parameters.

but the problem is. for example i gave startdate as...

The basic problem here is assuming that just having an ODBC driver is enough to accurately convert rather different data types seamlessly between Oracle and SQL Server. The...

djj (6/16/2015)

---

Watch if you use Microsoft's conversion. We had to fight with a ZIP code column as INT which should have been a char and other cases where Microsoft...

Also, why wouldn't you use the following?

INSERT INTO REDSHIFT64.databasename.testschema.testoperation

(viasatsubscriptionID, subscriptionrowdate,

phonenumberday, viasatcustomerid)

SELECT viasatsubscriptionID, subscriptionrowdate,

phonenumberday, viasatcustomerid

FROM rdata.dbo.testoperation

sqlbidev (7/7/2015)

---

Hi,

I have a populated table on my local machine, I have created the linked server and connection is working fine.

I have also created the same table on redshift...