tmiller 90290 (8/31/2016)

---

gotcha, for me I have no problem with the 24 clock, I understand it, my boss however, well, she wants to see the AM/PM, lol. I will...

It doesnt need sysadmin, but you do need to give the account you setup in SSRS configuration manager access to the virtual directory for the web service calls that SSRS...

I would try 2 things at this point.

1. Try using a password like 12345 (I know same as your luggage, haha never heard that one before) some FTP sites will...

arkiboys (8/17/2016)

---

Hello,

using a combination of ssis and C#, we are placing file data into sql server tables.

The files contain around 70 million of rows...

We can not use bulk insert as...

Not from a testing standpoint. a...

charles.russell (8/8/2016)

---

I am sorry I don't see a Business Intelligence forum for 2008. I have several SSIS packages that launch external programs either batch programs for things like SFTP...

hrmm I...

Anandkumar-SQL_Developer (8/8/2016)

---

Hi Friends,

please some one help me how can i get my Expected output.?

Sample Input...

Jeff Moden (8/3/2016)

---

Smendle (8/3/2016)

---

Jeff Moden (7/20/2016)

---

Smendle (7/20/2016)

---

Something like this?

With MyCTE(val)

AS

(

SELECT '9.0.0832.1032' UNION ALL --need to get...

mw112009 (8/1/2016)

---

This is my update statement.

UPDATE [MEMBER].[IMP_MEMBER_INT]

SET

[ContactLastName] = CASE WHEN LEN(ISNULL(LNAME,'')) > 1 THEN left(ltrim(rtrim(LNAME)),60) ELSE @DefOfNull END

,[ContactFirstName] = CASE WHEN LEN(ISNULL(FNAME,'')) > 1 THEN...

Please provide the following to help us help you:

Table Definition:

i.e.

CREATE TABLE [dbo].[Dim_Colour](

[colour] [varchar](30) NULL,

[model_number] [varchar](30) NULL,

[commission_group] [varchar](30) NULL,

[custom_1] [varchar](30) NULL,

[custom_2] [varchar](30) NULL,

[custom_3] [varchar](30) NULL,

[custom_4] [varchar](30) NULL,

[custom_5] [varchar](30) NULL,

[product_name] [varchar](30) NULL,

[description]...

Jeff Moden (7/20/2016)

---

Smendle (7/20/2016)

---

Something like this?

With MyCTE(val)

AS

(

SELECT '9.0.0832.1032' UNION ALL --need to get the 32 (one...

navtec (8/3/2016)

---

Hi,

I currently have snapshot replication running and my publisher and distributor both sit on the same server.

I want to move my distributor to another server.

How can I do this?

Is...

Simple

Select myvar,sk,recnum,

Case Recnum

When 0 Then sk Else Recnum

End as ModRecnum

From tmp.mytable

If your VMs are saturated CPU wise and you have Hyperthreading enabled I would consider disabling it.

This article explains why and is 2005 tagged but applies to all versions of...