Greg Edwards-268690 (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that there...

Mention Dynamic SQL and suddenly that is THE solution for the immediate problem, but what problems may it cause down the road?

Won't be surprised if we hear from that OP...

erouse (6/8/2016)

---

Thanks for your reply Drew but the quotes aren't stored in the tables. If we run SELECT * from #mydaterangetable WHERE tbldaterangeID =3 we get:

3Last 7 daysDATEADD(day,...

Brandie Tarvin (6/8/2016)

---

<headdesk>

User asks me to move this bit of code into QA:

ALTER TABLE MyTable

ADD Col1 INT,

Col2 INT

GO

I push back and say "Please add your statement...

Firemander (6/8/2016)

---

1. If you need all the rows in a table, which provides a lower execution cost?

Selecting * from a particular table that is well indexed (SELECT * FROM tbEmployees)

...

Won't deny that, looks even weirder when you use the same variable name on each side. I have done it and...

Steve Jones - SSC Editor (6/8/2016)

---

Lynn Pettis (6/7/2016)

---

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the...

j-1064772 (6/8/2016)

---

I have used a trivial example - should have considered that the normal reaction would be that dynamic T-SQL is totally unwarranted for something so silly. I agree.

I...

Then TRUNCATE TABLE TableA will do just that, truncate the table of all data regardless if any of the data should...

You need to link sys.views and sys.sql_modules.

komal145 (6/8/2016)

---

I have a execute task beginning of the logic in which i have this logic

Declare @Truncate bit

BEGIN TRY

EXEC [GetLoadStatus]

@Query = N'accountname',

@StatusFlag = @Truncate OUTPUT

IF @Truncate...

Welsh Corgi (6/8/2016)

---

I execute the following query:

SELECT DISTINCT ID, Name, Abbreviation, CountryID

FROM Postal_StateProvince

WHERE CountryID = 2

It returns the following values:

IDNameAbbreviationCountryID

52AlbertaAB2

53British ColumbiaBC2

54ManitobaMB2

55New BrunswickNB2

56NewfoundlandNL2

57Northwest TerritoriesNT2

58Nova ScotiaNS2

59NunavutNU2

60OntarioON2

61Prince Edward IslandPE2

62QuebecQC2

63SaskatchewanSK2

64Yukon TerritoryYT2

It return the following...

Welsh Corgi (6/8/2016)

---

John Mitchell-245523 (6/8/2016)

---

Welsh Corgi (6/8/2016)

---

I am getting a Primary Key Violation when Loading a Table.

I queried the source table and there is only one record with value of...

j-1064772 (6/8/2016)

---

Good day,

I am having difficulty understanding how to make available a parameter set with dynamic T-SQL.

I expect value of the [font="Courier New"]@s_MaxOrderOut[/font] to be already defined in the [font="Courier...

Ed Wagner (6/8/2016)

---

SQLRNNR (6/8/2016)

---

Ed Wagner (6/8/2016)

---

Jeff Moden (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server check...