studySQL (8/7/2015)

---

I have a data flow that brings the data from flat file (.txt) to a table but after processing few rows, it fails with this error.

Violation of PRIMARY...

mar.ko (8/10/2015)

---

Thanks Guys. I think decimal(9,2) is adequate....and it uses only 5 bytes.

The only problem :

when summing large numbers of rows....that could result in overflow if it is not...

Luis Cazares (8/10/2015)

---

Please don't use a recursive CTE to generate a calendar table as it's only a way of hidden RBAR. You can read more about this on this article:...

Can't help but wonder why you want to use CHECKSUM... perhaps the combination of Linked Server and ENCRYPTION is going to cause...

jbalbo (8/10/2015)

---

Hi

I need to display all the dates within a range even with no data

for example right now my query get the records with the range say...

The range is...

Grant Fritchey (8/10/2015)

---

Might be a good idea to put an index on your temporary table and ensure that the statistics are up to date. This query is the most costly:

SELECT...

M Joomun (8/10/2015)

---

I'm using the SQL below to work out recruitment figures. The query works well, but I now need to build this query into a DotNet application as a...

I copied and pasted into Notepad, then saved it as TEST.SQLPLAN. It's attached, and it did successfully open in SSMS for SQL 2008 R2.

I took one look at the stored procedure and it definitely needed work. Take a look at the way it's been re-written by comparing it to the original.

There...

ssk7317 (8/6/2015)

---

I am a Infosec guy and don't know a whole lot of details about Database. But as a part of our infosec lockdown activity, we are giving a shared...

tooba111 (8/7/2015)

---

Steve,

Thank You for your reply. The purpose for this task is the user can run SSIS Package without any problem or ask IT. SSIS Package is reading the data...

tooba111 (8/7/2015)

---

Hi Everyone,

I want to complete this task but don't know how. Need help!!

I want to give Users to execute SQL AGENT JOB. SQL Agent is running SSIS Package. I...

kyagi.jo (8/7/2015)

---

I did think that would have been likely, does anyone know if there there are any resources on the internet that might give me a headstart on getting this...

Just constructing such an example would require more time than I have available....

At the time I wrote...