it's not obvious where the alias goes;

here's two examples:

SELECT POPRCTNM,

STUFF((SELECT ','+ CAST(ACTINDX AS varchar)

FROM POP30390...

a CLR has access to all tables in the scope of the transaction if you use the context connection; (ie #temp tables and @Tablevariables

one option is to have the CLR...

That trigger emulates what a column with an identity does... so you can simply define the column as having an identity and skip the trigger completely.

Create table tbname (colname int...

it's possible, but you have to register your DLL into the database as an assembly, before you can create a CLR which uses your Medical.DLL as a reference. You might...

probably one of the best maintenance solutions out there is this free, peer reviewed, used in major production facilities and major companies solution offer by the world renowned SQL DBA...

certainly possible, but you need to generate a list of all possible dates;

A Tally Table is one of the easiest ways to do that;

here's just one way to do it:

create...

a parameter declared like DECLARE @var NVARCHAR or DECLARE @var2 VARCHAR has a size of ONE character...I think that's what Phil is going after...bad definition in the Stored procedure.

you would...

ok i just tested this, but i made some assumptions;

when you say "

I THINK you are saying "If I pass this string 'd;c;b;a;e', i want the companies ordered in that...

saifulislam6720 (3/1/2013)

---

Hello Guys i think that If you want to see, at the time if someone is signed in twice and obtaining the same information look at the hosting server...

Oh yea,the only guys that remember it all, i...

Sigerson (3/1/2013)

---

This is a related question, hoping someone on this thread can answer it.

I've had a working bcp process for months that creates a CSV file on a network drive....

Great job on supplying the DDL and Sample data;

probably a copy paste error, but two of the dates have the month "22", so i couldn't get it loaded all teh...

Raghunath Garlapati (2/28/2013)

---

Thanks for your reply!!!

We have around 1500 tables and 15000 columns. My concern is not about the increase in DB size(memory).

I am more interested to know that...

extended properties don't have any significant impact on the database size; it's not describing per-row data, but rather schema data.

the other thing to remember is that objects that are not...

The query you posted is using the same index stats to determine when the LAST time a table was accessed. you had asked for the most frequently used, which my...