jcachado (11/19/2015)

---

Hi,

I need help please,

This statement work but the system only see the hour not the minute:

(create_dtim between #1/1/2015# and #3/1/2017#) and (hour(create_dtim) >= 22)+ (minute(create_dtim) >= 15)

Thks a lot...

Steve Jones - SSC Editor (11/18/2015)

---

Hopefully coming soon. Not nearly enough snow here...

Nope, no reason to.

rodjkidd (11/18/2015)

---

Lynn Pettis (11/18/2015)

---

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm not sure if search...

Or you could encapsulate the INSERT and DELETE in something like the code snippet I attached to this post. If someone else would like to copy it directly into...

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm not sure if search engines would care,...

fmarler (11/17/2015)

---

Wanting to do something like:

Select * from tbl

having cast(isnull(Column1,0) as int) + cast(isnull(Column2,0) as int) + cast(Column3 as int) > 0

my issue is all 3 columns are varchar...

OMG

Ed Wagner (11/17/2015)

---

Lynn Pettis (11/16/2015)

---

Ed Wagner (11/16/2015)

---

Lynn Pettis (11/16/2015)

---

And then you this type of question:

************(11/16/2015)

---

How can i round off decimal number. E.g if i have 7.9---i need to round it...

Even today I still make rookie mistakes at times. Know the order you need when doing multiple replaces and some of the values you are replacing are embedded in...

Why go to all that trouble. Dynamically create the entire SQL query in the application and call this proc:

create procedure dbo.QueryDB (

@SQLCmd nvarchar(max)

)

as

set nocount on;

execute...

I say this...

robert.sterbal 56890 (11/16/2015)

---

Lynn,

That is correct. I've had my email address changed, and I use to one log in from work that was changed at that time and I also use...

I have used aliases in this manner for years, never had a problem with a variance in data returned.

Break down the query into individual queries of each table and see...

Must have been using a different username as the profile for the username you...