Numeric data imported from Excel does not have leading...

Are you able to provide sample DDL, data with DML and desired results, as described in the link in my signature? It would make things clearer.

oneteabag (4/12/2016)

---

Hi all,

I have a Source table Tbl_Src that has 5 columns:

Company_id,Salesrep_sales_date,Product_id,sales_Amt

I have a process that runs and re-calculate the sales_amt and re-distribute portion of the sales to...

Change your CATCH block to include a THROW rather than a SELECT ...

I suggest you add this before creating the temp table, just in case:

if Object_Id('tempdb..#BBMDetail','U') is not null

drop table...

Can I suggest a non-looping way of doing this?

INSERT dbo.test

(

...

Phil Parkin (4/11/2016)

---

This

Is odd.

I don't know what...

jameslauf (4/11/2016)

---

I am pulling data from an application database. Our vendor is not the most responsive and the do not fulfill our requests very fast.

I want to hard code a...

This

Is odd.

I don't know what is happening,...

Very strange indeed.

Try this one:

GO 3

SELECT

FROM [Reporting].[WorksheetReporting]

Do you see the error once or three times?

I am no PoSh / XML expert, but I did find this[/url] blog which seems to have everything covered pretty well. Maybe it will do what you need.

If you run just these statements, do you still see the error?

USE [CmsTestDB]

GO

And how about

GO

SELECT

FROM [Reporting].[WorksheetReporting]

SQLTougherGuy (4/11/2016)

---

Hello,

I am trying to update a connection string in an XML file using POWERSHELL. I have the following code that is not working. I have a code snippet for...

Enterprise on a dev server?

fantom (4/11/2016)

---

I get an error that it cannot upgrade. These are the features that it is trying to update.

Database engine services

sql server replication

full-text and semantic extractions for...

Satiz (4/10/2016)

---

Phil Parkin (4/10/2016)

---

Satiz (4/10/2016)

---

Hey guys i tried...