Yes indeed - date, time, datetime, datetime2 (and possibly others). These are the "proper" data...

Thanks Steve. Glad you got it all sorted. I was actually responding to Ben's point. Sorry, I should have made that clear.

John

You're confusing dates with date formats. Since this is a SQL Server forum, let's talk about SQL Server, which stores dates internally as a number (two numbers, maybe -...

You want this to be false, I think, so that should be your expression:

[font="Courier New"]@Counter1 != @Counter2 && @Counter3 <= 3[/font]

John

Calculate the actual date something like this

SELECT DATEADD(day,[Date],'20040701') AS ActualDate

FROM MyTable

John

Yes, or if this is part of an ETL process, consider copying the rows you want to keep to a new table, dropping the old table, and renaming the new...

Insert into Track (RunDate,Dbname,file_Size_MB)

select

getdate() as RunDate,

DB_NAME() AS DbName,

sum(size)/128.0 AS File_Size_MB

from AdventureWorks.sys.database_files

John

First, is there any blocking going on? Second, have you looked at the execution plan to see what the pain points in the query are? If you have...

Goodness! If the IT department isn't fulfilling one of its most important roles by taking backups, then that needs escalating to the very top, doesn't it?

John

Yes, or just do the conversion after calculating the minimum:

CONVERT(varchar(17),MIN(a.orderdue),103)

This has the added advantage that it only has to do the conversion once (on the minimum date) instead of on...

What version of BIDS/SSDT are you using? Make sure you're at the top level of the package (ie not in a data flow) and then look in the menu....

Alex

You can use Package Configurations and pass in the variable value via the config file or table, or you can have the package fetch the value at runtime, for example...

I imagine you'll have to concatenate, something like this:

'*' + $Code + '*'

I don't use Powershell all that much so I'm afraid I don't know the exact syntax off the...

Indeed you can.

John

My guess is that the Get-QADGroup cmdlet detects the variable in the middle of the search string, whereas Get-ADGroup treats it as a literal. You'll need to find a...