Dominic Gagné (3/17/2014)

---

Hello folks,

I need to create a StoredProc who will load a jpeg image from the hard drive and return it to a remote SQL Server. I have found...

It seems like you are getting dangerously close to a "catch all" query. You should read up on that topic here. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

jbalbo (3/17/2014)

---

Hi Trying to use an if in a where clause using a parameter value

My where looks like ..

WHERE

(CostCenter.Code = '918')

AND ((CostCtrGrp.AdmitDate <= @EndDate) AND...

JP10 (3/17/2014)

---

Hello Sean,

Thanks for the help really appreciate it. Looks like I solved my problem by using a cursor and updating the StartDates manually and then selecting that table...

altana (3/17/2014)

---

Sean Lange (3/17/2014)

---

How do you know that the users are entering the right values in your textbox?

Your C# code is passing the value from a...

You could greatly simplify this proc and remove about 40% of the lines which don't really provide anything.

create proc [SP$insert]

(

@p1 nvarchar(100),

@p2 nvarchar(100),

@id int output

)

as

set nocount on

select @p2 --What value...

'Warning 1 The currently targeted framework ".NETFramework,Version=v4.0,Profile=Client" does not include "System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which the referenced assembly "CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL" depends on. This caused the referenced assembly...

Did you look at my last post? The logic in your proc can very easily...

How do you know that the users are entering the right values in your textbox?

Your C# code is passing the value from a textbox as p2.

cmd.Parameters.Add(new...

sten.f.soerensen (3/17/2014)

---

I have a lot of PDFs stored in a table, and it works fine when extracting (and displaying) them using WriteBLOB (http://support.microsoft.com/kb/103257).

I'm looking for a way to extracting the...

altana (3/17/2014)

---

No, it's the right value. Wenn I insert...

Slightly off topic but you might look closely at what @@IDENTITY returns. Almost everytime I see this the person really wants the identity value from the insert they just executed....

As pietlinden stated you need to provide your sample data in a consumable format. But you also need to provide your results in a meaningful way. You have listed three...

While this approach is a little easier to understand...

Hi and welcome to the forums. There are lots of people around here willing and able to help. But posting pictures of your tables does not provide the kind of...