Brandie Tarvin (12/22/2015)

---

Sorry to interrupt a valuable discussion on posters, but I need some sympathy.

Cancer cat (Formerly had a sarcoma removed) now needs to go back in for some surgical...

Good stuff, care to share the solution?

😎

stevennjuki (12/22/2015)

---

Hello,

I am able to get various totals summed up from varying row numbers of this table

CREATE TABLE [dbo].[tb_a]([cl_t][datetime] NOT NULL ,[cl_a][decimal](18,5) NOT NULL) ON [PRIMARY]

like this...

Michael L John (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

GilaMonster (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

One recent poster kept asking over and over again why he was getting an error whilst trying to do something he'd already...

Crossing the...

sharonsql2013 (12/22/2015)

---

Hi,

I am trying to compare two columns but looks like its a data issue

One column as data like "Team Leader - XYZ" and second one has "Team Leader-XYZ"

Is there...

GilaMonster (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

One recent poster kept asking over and over again why he was getting an error whilst trying to do something he'd already been told was impossible, had...

ScottPletcher (12/22/2015)

---

Edit: Not at all "moving the goalposts". The only reason for the rule is the issue it causes if you get the type wrong, as I stated many...

patrickmcginnis59 10839 (12/22/2015)

---

Eirikur Eiriksson (12/21/2015)

---

The problem is that xp_cmdshell can only...

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

ScottPletcher (12/22/2015)

---

Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that...

Ed Wagner (12/22/2015)

---

Phil Parkin (12/22/2015)

---

Sean Lange (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

Silver Spoon really doesn't seem to care about learning anything. Just the answer, that's all he is interested in.

I really hope...

ScottPletcher (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

My bad in the post before on the conversion, sorry about that.

😎

My point is that incorrect typing and implicit conversions do cause problems, I've lost count of...

Piling on Chris's and Jeff's good points, no need to persist that number, easily done in a query.

😎

Some sample data

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE...

Jeff Moden (12/20/2015)

---

Interestingly enough, I think that anyone passing 100K parameters to a stored procedure is 1) doing something wrong or 2) doing something really wrong. 😀 There...

Bhushan Kulkarni (12/21/2015)

---

Hi,

In our project, we have requirement such that user can set user defined properties for Entities- these properties will be dynamic.

So we implemented it using EAV model.

Base table...