Viewing 15 posts - 1,426 through 1,440 (of 2,894 total)
Why not to post DDL together with explaining your problem in words. That would help a lot (link at the bottom of my signature).
From what you described looks like...
June 14, 2012 at 7:53 am
Sorry mate, I don't know the one. And I guess there are no many as not many DOS programmers are still around...
Windows engineers forums will be your best bet.
June 14, 2012 at 7:49 am
No, SQL Server doesn't track such things.
You will need to review your triggers (you can use handy Search add-on from Redgate) and find which one do update your columns, you...
June 14, 2012 at 6:51 am
It kind of SQL forum, not the DOS one...
It took me a while to figure out how to do it in DOS using REG QUERY, you need to follow all...
June 14, 2012 at 6:43 am
Daxesh Patel (6/14/2012)
...- you cannot specify file group, INTO will always create new table in default file group
...
Depends, sometimes (for example in DW serial load) the following is...
June 14, 2012 at 5:10 am
Daxesh Patel (6/14/2012)
...- you cannot specify data types of columns (especially calculated column in select)
basically no control on new table definition
You can specify data types of columns:
SELECT CAST(NULL...
June 14, 2012 at 5:07 am
It will help, but, will it satisfy your performance requirements (if any)? It is really depends on what you load and what transformations and validation you perform. I am not...
June 13, 2012 at 3:55 am
Pre-load all data with all required validations into staging tables. When done, you can load it into destination if there are no errors.
June 13, 2012 at 3:38 am
DZN61 (6/13/2012)
I now that UDF are fare more slower than Stored procedure due to the compilation.But what about Table value functions ?
Tks.
Yes, sure! And submarines are slower than tanks! The...
June 13, 2012 at 3:19 am
If you would provide the setup (ddl & sample data) I could test my query, but...
Select a.trainingcourse, c.name, c.personID, b.expirydate
from trainingcourses a
cross join staff c
left join trainingcourselog b on...
June 12, 2012 at 10:29 am
SQLKnowItAll (6/12/2012)
Adam Bean (6/12/2012)
...
I'm confused... Here you have no "specified end date."
I guess, it's a kind of achievement to confuse KnowItAll one 🙂
In reality for the given requirement, You don't...
June 12, 2012 at 9:49 am
What about providing something like this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 12, 2012 at 8:40 am
You don't need the cursor! If you have the calendar table, just select records you need filtering by date.
Or you can use some run-time tally table like that:
DECLARE...
June 12, 2012 at 8:22 am
1. There is no such function in T-SQL as "get(@id)", If you want to get table id you can use SQL function OBJECT_ID('TableName')
2. The first errors you have is...
June 6, 2012 at 9:42 am
Viewing 15 posts - 1,426 through 1,440 (of 2,894 total)