Are declaring variables and if statements considered part of T-SQL? They're more VBA than SQL from an overview

Xixi sqlknowitall

Works great. Is there a good article about how the row_number() function works? I did a google search, but the pages that are listed don't really explain how the...

thanks

You can only return one part (day, month, or year) of the date with datepart, not the whole date

wow jimbo, as always another vanilla answer with no details

Hi John,

What should my expression be when I am using the Derived Column Transformation Editor? I tried "cast(getdate() as date)", but I am getting an error

What should my FROM statement be if I am writing a custom query? ie. If my Access database location is "I:\databases\quarterdata.mdb", how do I phrase that in my FROM...

I created a SSIS file using the wizard. But when I open the SSIS file, I don't see an option to change the destination table name

I have another table on the server with the same name. Anyway to import with a different name by default?

Access automatically inserts the "#"s around a date (as long as the column you are setting your criterion off of is in date format). Because of this, you should...

gratz

I am looking to get an integer (the number of days between the 2 dates)

Is there a way to get the numeric value of the date only (with 0:00 time) and use it in a subtraction?

This is what I have right now, but I...

Did some testing. I am able to run

sum(CASE

WHEN [days old] <= 0 THEN [balance remaining]

ELSE 0

...