for me,trolling through the forums here on SSC, i literally copy and paste every example that interests me into a SSMS window and run it.

that's why everyone encourages(demands?) that...

the devil is in...

andrew in my sql 2008 db, if i create a diagram, then a single row is created in the table dbo.sysdiagrams.

select * from dbo.sysdiagrams

name ...

you can do it with a tally table as well;

for example the function I'm pasting below will strip out everything except chars in my specific range of ascii characters:

--ascii...

Thank you for the salute Jason and Thanks for identifying the fix, Chris;

Something that might escape some folks is did you know that C2 auditing is just another version...

i think you want something like this, but the key is which column has the "status", and it's data type:

i assummed a string field, but you'll get the idea once...

duplicate post.

continue reading here:

http://www.sqlservercentral.com/Forums/Topic887248-391-1.aspx#bm887384

duplicate post.

continue reading here:

http://www.sqlservercentral.com/Forums/Topic887248-391-1.aspx#bm887384

with stored procs, it's a best practice to add SET NOCOUNT ON as the first line of the proc;

this prevents other applications from thinking subsets or commands like (x...

slight formatting change, added a few aliases, this is syntactically correct:

INSERT INTO database2..table1 (Date, Emails1, Emails2, Emails3)

SELECT getdate() -1 As TheRightDate,X1.CNT,X2.CNT,X3.CNT

FROM

(SELECT count(*) AS CNT FROM database1..table1 WITH (NOLOCK) WHERE...

i'd have to test it, but by avoiding some string manipulations, it might save a microsecond or two on a big batch; i think it's just shorter and easier on...

data that is in YYYYMMDD format will natively change to datetime with the code i added...no need to chop it up into pieces; try convert(datetime,sdate) and it should work fine.

once you've converted to datetime, the comparison should be easy;

here's how to convert your julian date; the other appears to already be datetime....if it's not, explicitly convert it to datetime.

update...

i think SELECT COUNT(DISTINCT fieldname) will do what you want:

CREATE TABLE user_registration_tbl

(id int identity,

user_first_name varchar(100) not null,

parentid int not null, ---coresponding ID of parent

Node int not null, ----'0' if member...

if it HAS to be done in T-SQL, I've written a stored proc which returns the DDL of any table (or treats a view as if it were a table)...