deekadelic (10/5/2016)

---

I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a small part of the code of the script, then ran it...

Based on what you said about grouping, the results look OK to me. This is difficult to troubleshoot when we don't know what the source data looks like and we...

tfoley 60758 (10/5/2016)

---

Hi All,

We have an on-premise CRM 2016 setup that's using SQL 2014 in Denver, CO. We have a large office in Australia and CRM access is pretty slow...

Eric M Russell (10/5/2016)

---

Phil Parkin (10/5/2016)

---

If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within...

If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within a column would be constrained...

What is the purpose of the LEFT JOIN to addb20.Source_MergeAMD3_WithData.dbo.ConfigChoice?

I ask because that table is not referenced anywhere else in the query.

No. The overlapping has nothing to do with...

Are you asking whether...

Eric M Russell (10/4/2016)

---

Phil Parkin (10/4/2016)

---

New Born DBA (10/4/2016)

---

Experts,

Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop...

New Born DBA (10/4/2016)

---

Thanks for your kind response but there are 35 tables and all these tables have to be created in 150+ DBs. I already generated the script from...

komal145 (10/4/2016)

---

Source datatype:

[First Name] [nvarchar](255) NULL,

[Last Name] [nvarchar](255) NULL,

[ItemID] [bigint] NULL,

[E-mail] [nvarchar](255) NULL,

[Address] [nvarchar](255) NULL,

[Address 2] [nvarchar](255) NULL,

[City] [nvarchar](255) NULL,

[State] [nvarchar](255) NULL,

[Zip] [nvarchar](255) NULL,

[Trade...

komal145 (10/4/2016)

---

[Derived Column [24]] Error: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.

I keep getting this error again...

New Born DBA (10/4/2016)

---

Experts,

Is is possible to create multiple tables with same tablename and column in multiple databases without selecting each database from the drop down menu and execute the...

Derived Column:

"'"+ (DT_STR, 50,1252) [column]

for a varchar(50)-type column, for example.

komal145 (10/4/2016)

---

I have a package which laods data to excel ,but my manger wants to force column explicitly to string type before we export to excel.

So users just open and...