shezi (4/13/2016)

---

I want to insert only unique tracerNo field if it doesn't exist. Here is my code. This is not working for some reason. When I run this nothing get...

Did you also rebuild the indexes?

Eric M Russell (4/13/2016)

---

below86 (4/13/2016)

---

I've got a question on how I should handle a situation. I've been looking at local companies and I've found one that has an opening...

I would love to go, but I am pretty sure that would have to be on my dime. I don't the company would pay for me to fly to...

Just my opinion, but if the backup system you are using doesn't quite the database before doing the snapshot, you aren't guaranteed to get a reliable backup.

Running SQL backups using...

I am glad you resolved your problem, but it doesn't answer the question.

Run the following code, there are no issues:

declare @StartDate datetime = '2016-01-01 13:00:00.000';

declare @StartDateN nvarchar(30);

set @StartDateN = convert(nvarchar(30),@StartDate,121);

select...

richjlamb (4/12/2016)

---

I am trying to create a dataset for a range chart in SSRS, the purpose of this chart is to act as a promotional calendar for our sales team...

Okay, can you recreate the problem in an empty database with a subset of the data?

arbra.strong (4/11/2016)

---

No....I am able to put GO after the select statement and it runs with no errors. It is only when it...

Is there a procedure named GO?

tindog (4/11/2016)

---

TomThomson (4/8/2016)

---

I don't know how accurate it is for the USA, because I've never tried to live there - and short visits don't...

That's ridiculous. A person claims to "brain dead" and (actually said bread dead) can't read an article so asks for an example when the article itself has an example....

From a quick Google search RDM (Raw Disk Mode) is a method of configuring disks on VM server. SSDs are solid state drives and are used to replace standard...

Peter Schott (4/8/2016)

---

I'm not sure housing prices as in San Francisco are like _anywhere_ else in...

Here is the view definition reformatted. If I didn't know better I'd swear this is XML. Would XML shredding be better?

CREATE VIEW [dbo].[vw_aspnet_UserProfiles]

AS

SELECT

P.UserId,

...