I would say that's a little ambiguous of a question. You don't state whether the time in the question is your local time, or the UTC time, which would result...

I would agree yes. NULL and 0/blank are completely different in terms of data.

A NULL value represents an COMPLETE ABSENCE of data, where as a 0, or Blank String...

When posting, it's always best to supply your DDL and INSERT statements (see my link to Jeff's post in my signature).

Hopefully, however, this meets your goals:

CREATE TABLE #Structure (VCode INT...

ranala (10/17/2016)

---

No, i am asking about database connection manager.

in my production server connection name is abc but in my local machine connection name is aaa then if i...

Phil Parkin (10/16/2016)

---

Actually, this bit is not quite correct. SSDT and...

What do you "Generic" connection manager? If you mean something that could connect to anything (SQl Server, Excel, CSV, ADO), then there is no such thing. If you're going to...

Web mark up language as will remove double spaces, and replace with a single space, unless inside the correct tags. Using the code IFCode tag will fix this for you.

Basic...

When supplying data, you really should provide a DDL and Insert statement. Providing a copy and paste of the data is often far from useful, especially when you data doesn't...

You're attempting to get a list of valid clients from your dataset that requires the parameter Client, which is impossible to run. SSRS needs a value for @Client to run...

richard.gardner 6009 (10/11/2016)

---

That's quite useful Thom, could I ask what you're looking at to do that check? I was assuming that lifting the parameters would occur prior to the report...

My only 2 cents is "is 10 seconds long enough?"

I do "data driven subscription" myself, using standard, however, sometimes my reports take a little more than 10 seconds. If you...

Really wasn't expecting that answer. The skeptic in me does wonder how many people ran the SQL before giving an answer though 🙂

mw112009 (10/10/2016)

---

John:

Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the...

See the link in my previous post, it tells you how you should share sample data.

Sending stuff over Skype isn't great for a number of reasons.

Your Connection Manager must be set up to treat the first row as a header. Go to your Connection Manager properties for the Excel sheet, and change FirstRowHasColumnName to FALSE.