Topics
Started by
Posts
Last post
Hi all, I have a table that gets items added to it everyday through a SQL AGent Job. I would like …
3 replies
I have a database and need to delete from 4 tables starting with the first and ending with the last…
3 replies
Hi is there a limit on what the concat command can do in SQL 2005. I can use sql query and do a l…
2 replies
Hi, I'm trying to do some math, then convert the results to a percentage, but I come up with 0. H…
2 replies
Guys, Would appreciate your help! I'm trying to convert a ddmmyyyy (23052008) integer to a datetime…
4 replies
Hi, This may seem a little strange. But here is my challenge. I have data in Table 1. I execute …
4 replies
HI I would like to use a variable to populate my select statement. So I have a 'AREAS' table with a…
3 replies
Dear friends; pls Help me; WITH CTE AS ( SELECT *,Extmark / 2 [SUMOFEXTERNAL] FROM Regular where re…
3 replies
I have a tigger for insert statement in one of my table. what the trigger to do is when new row is …
3 replies
I'm drawing a blank on what seems to be a simple SQL problem. You have a name, a date and a score…
6 replies
hi.. I need three day back date from prasent date. example:today date : getdate() 3 days beforedate…
3 replies
Hi All, I have a table in a SQL 2000 database. The structure is shown below: ProdName Sale_Date I …
2 replies
I have a query that is not accepting GETDATE() . But when I hardcode today's date then it works fin…
4 replies
I have a query that I've written to find me all the properties on contract and then I want to find …
10 replies
I've got a datetime field for call date but I need to group my data by the hour of that call date a…
5 replies
Viewing 15 topics - 4,936 through 4,950 (of 12,234 total)
You must be logged in to create new topics.