pkaraffa (12/21/2010)

---

Good afternoon,

I am new to SQL what I am trying to do is to combine these 2 statements into 1. Can anyone please help me! Thank you in advance!

SELECT...

Hi,

Fullbackup(on 1st day) + Last differencial backup + transaction Log of 23rd till 3:00 PM

Thanks

Parthi

Is this you are looking for

Select Project ,Location,Itemtype,Sum(Amount) From mytable...

Jeff Moden (12/16/2010)

---

@ Parthi, Andrew, and Tom,

Good Lord... My humble apologies. That's the second time I made such a mistake in this forum this week. And I really...

GilaMonster (12/15/2010)

---

a.) Determine the logical file names of the tempdb database and their current location on the disk.

b.)Change the location of each file by using ALTER DATABASE.

c.)Stop and restart...

Hi

This are temporary tables ,these tables are created such as running stored procedures with Temp tables.If the stored procedure fails then you will be facing this type of problems.It means...

Just ONLY one Solution is there or we can have multiple solutions Trying to learn more (on possibilities ) Not only on CEILING but on all functions to know how...

Actual data is in float so we cant use modulo operator

Thanks

Parthi

so Now i got Three options CEILING / FLOOR /ROUND

-->CEILING--- Returns the smallest integer greater than, or equal to, the specified numeric expression.

-->FLOOR--- Returns the largest integer less than...

I think you all got misunderstand, i just want any other options is there to get this apart from CEILING.Nothing else.If this is only option you peoples says then ok.

Thanks

Parthi

But i want to know only CEILING can do this or some other functions can do this or not

Thanks

Parthi

samalex (12/8/2010)

---

Our system stores customer addresses with street, city, state, and zip, but would this be sufficient to use the SQL Plugin with MapPoint? From the few examples I've...

Hi

There is no such options in 2000

In 2000 you can use IDENTITY (data_type [ , seed , increment ] ) .Is used only in a SELECT statement with an INTO...

Hi

There will not be problem in your query defiantly it will work, Better keep alias separately so that your code may look gud

Note: You can...

Hi Craig

We can help on things which could not be solved at minimum time or when it is critical...