Viewing 15 posts - 2,341 through 2,355 (of 2,894 total)
What version of SQLServer you are running?
I have tried:
select cd.* from [SERVERNAME].[master].[sys].[tables] cd
And it does work fine as expected.
Actually, should mention the following if your query uses joins between...
July 27, 2011 at 2:51 am
Sean Lange (7/26/2011)
I am thinking there has to be a set based solution to this but my brain is too full with my own stuff today. 😉...
There is...
At least one,...
July 26, 2011 at 9:30 am
In your case it's very simple:
You just need to apply query optimisation techniques and your query will fly.
July 26, 2011 at 8:25 am
andrei.burdun (7/26/2011)
insert into tbl1 values
(null, '10', '1');
This row should...
July 26, 2011 at 8:18 am
Simple answer is Yes you can join to TVF (actually is main reason it was designed for).
Example:
CREATE FUNCTION fn_List ( @p1 int ) RETURNS TABLE
AS
RETURN
(
SELECT @p1 AS...
July 26, 2011 at 7:28 am
I've found your sample inconsistent. I guess you will have all pairs of related Id's
I have updated your sample to have all ID pairs. However my query should work...
July 26, 2011 at 7:02 am
What cluster Id you would give to company named as "Alfa Beta Omega Ltd"?
Do you check company names do match by the first word only?
July 26, 2011 at 5:32 am
In this case I do usually use ForEach loop container and simply copy the file into “Work” folder and renaming it to the fixed name. Then connection can be configured...
July 26, 2011 at 5:22 am
frfernan (9/30/2010)
Eugene Elutin (9/29/2010)
October 1, 2010 at 6:34 am
1. If your clustered index is period and project_code, you better not insert anything which will be placed between existing data. Also, as you insert all data will be sorted...
September 29, 2010 at 10:40 am
The best thing I would suggest is to try insert all 8000 rows once (or in batches) with all required data populated.
If it is absolutely impossible in your case, I...
September 29, 2010 at 10:13 am
Post edited...
He is so well known that even googling for "Joe Celco" will find him easely! 😉
September 29, 2010 at 10:07 am
frfernan (9/29/2010)
At end of day, if you need to consolidate all movements (money movements, or warehouse movements) for this day - or week, or month -, you probably will start...
September 29, 2010 at 9:55 am
Nevyn (9/29/2010)
On the subject of non-clustered indexes, the issue would be the number of columns to be included. Even though they are only at the leaf level, it seems...
September 29, 2010 at 9:55 am
Nevyn (9/29/2010)
September 29, 2010 at 8:53 am
Viewing 15 posts - 2,341 through 2,355 (of 2,894 total)