Topics
Started by
Posts
Last post
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
Hi, I am trying to automate a restore of 2500+ databases. The files are named like so: survey_p1234…
3 replies
Hi All, i have values in a amount column as follows, 30,000.00 -74,000.00 45,000.00 It's data type …
3 replies
Sorry must be brain dead or blind, can someone tell me what is wrong with the sql below DECLARE @p_…
5 replies
hi i have problem with the dynamic sql. i am getting null values after execution, i think this ha…
3 replies
Viewing 15 topics - 4,936 through 4,950 (of 12,230 total)
You must be logged in to create new topics.