Thanks a lot....

I should really tell this...

you people are really helping and motivating me a lot. Many a times I found best solutions with you people.

Thanks a lot.

Regards,

Ami

true,

i have newly joined to this company. I see a lot of design changes.

the dimension tables are not having clustered indexes 🙁

and fact tables are having datetime as one...

the execution plan will reveal the database names and the column names. I don't want to take any risk on that.

thanks for the inputs.

going through the articles.

thnx

regards,

ami

hi,

One huge thanks, 🙂

sorry, i can't post the execution plan. (company standards)

I'm just analysing in the same way. how best i can tune or rewrite the query to...

Hi,

Thanks for your inputs. the data resides in datawarehouse. and resides in different servers. merging the databases or duplicating the same data through some ETL process or...

yes they are linked servers.

Hi,

Check whether you've taken care of unicode characters from c# code.

You can do the same from Import and Export Wizard from Sql Server.

-Ami

I need both the counts individually,

result should be kind of

value, count1, count2

Thanks Paul,

It works in this way, say last year December and this year say February.

🙂

But I totally agree with you. Thats how I built the database. (Now, we...

Hi Steve,

Thanks for your reply.

To be more precise this is for a vehicle repairing company. actually, the want the master details in the reports without modification. If the...

Thanks,

It is working fine. I wonder on what scenario I've gone for Global Temporary tables. 🙁

Thanks,

Ami

Hi,

As I couldn't share the full code I've shared only the part where i've used the fn_split and the script for fn_split. If there are some more round abouts,...

On the basis of the value is not null I'm adding those in to where conditions. while doing this i want to find the IDs from a comma separated values....

Hi WayneS,

one more doubt,

if i have multiple break timings with in one task then it is clashing for example consider this

INSERT INTO @Tbl

SELECT 19,'01/11/2011 08:00:00 ','06:30',''

UNION ALL

SELECT 18,'01/11/2011 08:40:00...

Hi WayneS,

Thanks a lot, it is working

-Ami