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...

as a general rule, if you've deflared @variables, you made a mistake in a trigger, and are limiting yourself to single row data instead if set based.

the issue is your...

kaplan71 (3/3/2016)

---

Hello --

I am running a SQL script that is designed to query the whole log of a particular database. The syntax of the script is the following:

use RayStationMachineDB_472

select *...

EXEC sp_msdependencies @intrans = 1

that will give you all objects in foreign key hierarchy order. it can be painfully slow or never ends if you...

i googled a bit and i saw quite a few blogs and examples on how to do this;

I would recommend starting there:

https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=load+twitter+into+SQL

if it's truly a handful of tables, and the servers can talk to each other, i'd consider using either a MERGE statement or a pair of UPDATE/INSERT;

that assumes that...

I have Redgate SQL Compare, but we do not(unfortunately) use source control for SQL objects.

I have a methodology for this situation that might help, assuming you also have SQL Compare.

In...

you should just pass all the parameters; if one of the columns is a column name, you have to select it from the table;

select dbo.CountOpps(User_ID, @StartDate, @EndDate),*

FROM SOMETABLE

this almost sounds like ID_NUM is a foreign key, and you want to render the details inline in the table; why not just create a view that pulls the data...