This post[/url] could help

😎

Further on Jeff's fine solution, you may want to consider converting the column from (var)character data type to date data type. Not only does it take less storage (3 bytes),...

RIP

\\//,

😎

Jeff Moden (2/26/2015)

---

There's no question here. The third select on the original post shows the set-based replacement for the cursors. The title truly reflects what was posted... it's...

serg-52 (2/27/2015)

---

SELECT t1.*,t2.dueDate

FROM Table1 t1

LEFT JOIN Table2 t2 ON t1.ID = t2.ID

...

The same way as any other download, the client initiates the download by clicking a link/button and the source of the file is the output of the stored procedure. Alternatively...

Simply replace ' & ' with '&'

😎

MaggieW (2/26/2015)

---

Dear all:

I need to write a stored procedure or SSIS to export data to client's desktop. What is the best way to achieve it?

The requirement is to develop a...

Several ways of doing this, here is one suggestion using a CTE. The important thing here is to pre-filter the second set because any filtering after joining the sets will...

Have a safe journey back home.

😎

Thank you all for the interesting discussion, don't panic and remember the Towel day[/url]

😎

In the explanation I used the term unassigned for the lack of a better one as the value of the variable is neither truncated nor is it null.

😎

ChrisM@Work (2/26/2015)

---

Jeff Moden (2/25/2015)

---

Brandie Tarvin (2/25/2015)

---

Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but...

On SQL Server 2008 you can manipulate the image data just like any other data type, consider this example

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.MY_BLOB') IS NOT NULL DROP TABLE dbo.MY_BLOB;

CREATE TABLE...

Quick question, what is the question?

😎