rsrvas (9/4/2015)

---

Ignore earlier thread..

"First A not followed by a B, C or D statement" means "A is present before B, C or D" need to ignore

i am explaining again with...

Please supply the following information:

CREATE TABLE statement for the table being inserted into.

CREATE TABLE...

amar_kaur16 (9/4/2015)

---

I have a table with appdt as first appointment date and the another record for the same customer# has follow up appointment.

Each customer is uniquely identified by a...

chandrakant_gaurav (9/4/2015)

---

IF Object_id('GoldenSecurity') IS NOT NULL DROP TABLE dbo.GoldenSecurity;

IF Object_id('GoldenSecurityRowVersion') IS NOT NULL DROP TABLE dbo.GoldenSecurityRowVersion;

CREATE TABLE dbo.GoldenSecurity (securityID INT, CompanyId INT, Securityname VARCHAR(50), issuedate SMALLDATETIME, currencyID INT)

CREATE TABLE dbo.GoldenSecurityRowVersion...

Very nice Luis.

(And here I was looking into a QU version)

And since the text data could be larger than 8k, I'd go with varchar(max) myself for the TextData column.

Glad it was helpful for you.

jasona.work (8/31/2015)

---

Jeff Moden (8/31/2015)

---

Steve Jones - SSC Editor (8/31/2015)

---

I'm not sure this is as big a deal as some people have written. Hard to decide if this is journalism run...

chindilog (8/31/2015)

---

The total quantity(sum(woitem.qtytarget) as total) result set is showing more than 6 numbers after the decimal point (example:442.2565485). How can I limit it to 2. (example:442.25)

select ...

myjobsinus (8/31/2015)

---

Thanks for all the responses.

Creating Stored Procedures for each query and use sys.dm_sql_referencing_entities is a good idea. but the problem is some queries will have variables used with...

JoseMenendez (8/29/2015)

---

The name can be, but will not always be the 2nd word in the string. It will be 1 of 8 names, and if none of those names...

For What It's Worth, my experience mirrors what Jeff has written. In fact, I even do an all day training sessions of bad things that are done to databases... and...

INSERT INTO <table> (<columnlist>)

EXECUTE <procedurename> <parameters>;

INSERT INTO <table> (<columnlist>)

SELECT <columnlist> FROM OPENROWSET (...)

alessandro.feltrin (8/29/2015)

---

[font="Arial"]

I don't use Windows authentication but SQL "sa" authentication, so i this case there should be no problem i feel. So, i should be able to restore my original...

duplicate post