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...

Satiz (4/10/2016)

---

Hey guys i tried by using synonym...

jude.pieries (4/8/2016)

---

Happy days are here again. Thought i will share my pain with and success with rest of you.

So it seems, having expression in the connection manager does...