there's nothing in your procedure that requires a cursor, let alone a cursor/while/cursor triumvirate of looping constructs.

In the end, you populate a #Results table, and return the results.

while the rewrite...

i've done something similar, but i just add the items together, and test for greater than zero; my query is assuming cost is a positive value, never negative, is that...

szejiekoh (3/7/2016)

---

Lowell (3/7/2016)

---

The SQL Browser service has to be running on the server in order to do that;

that service keeps track of what port SQL is running on, and forwards...

i am definitely under the impression that procedures/functions/packages have to be hand edited, as there's no specific set of rules to convert them;

the migration assistant is fine for tables and...

i think State 16 means the default database assigned to the login does not exist. it might have been dropped or renamed.

change the default database of the login in question...

The SQL Browser service has to be running on the server in order to do that;

that service keeps track of what port SQL is running on, and forwards requests to...

here's one way to do it:

DECLARE @xml XML ='<Item>

<Item customerid="101" customername="Ram" gender="Male" married="Y"/>

<Item customerid="102" customername="Sham" gender="Male" married="Y"/>

<Item customerid="103" customername="Tom" gender="Male" married="N"/>

</Item>'

select

...

Thanks mister magoo! what tool did you use that helps you identify case sensitivity issues like that?

Igor thank you very much for your feedback!

Your feedback was spot on, and the extra pair of eyes helped enormously.

because you gave such detailed feedback, i was easily able to...

i would recommend adding an explicit formatting to the date to guarantee it's converted to YYYY--MM-DD format.

you could potentially be getting dd/mm/yyyy,mm/dd/yyyy or event ""Mar 3 2016" if you don't...

bcp called via xp_cmdshell runs under the context of the service account running SQL, and not as the logged in user who executed it.

the account is probably not a...

There's a nifty builtin function called PARSENAME that splits a string like an Application Versions, IP addresses or Servername.Databasename.SchemaName.TableName into it's parts.

you can use that to isolate the second section...

Sean Lange (3/3/2016)

---

Don't know what you want your trigger to do but be careful. Triggers fire once per operation, not once per row. So you need to create set based...

i did a big Powershell documentation initiative.

this script from awhile ago started it:

Powershell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list of...

sgrimard (3/3/2016)

---

Good day,

I am wondering what would be the easiest way to recreate an existing database schema (sprocs, tables, constraints, etc..) without the data.

In MSSQL, I know you can use...