Topics
Started by
Posts
Last post
When I retrieve a data from a query, eg the max value in a table, i have found out that on the left…
4 replies
I am trying to use a bit datatype field for an indicator. This indicator can only be true (1) for o…
12 replies
CREATE TABLE #Bills ( BillNo INT identity, Account INT, Amount NUMERIC(10,2), Pai…
9 replies
A big problem....... A table has got a field -named datetest - data type is datetime in Enterprise …
8 replies
I have a where clause in a stored proc select statement that is giving me fits. This should b…
5 replies
When I run the following: SELECT DISTINCT [CheckNumbersWithClaims].pidate, Sum([CheckNumbersWithCla…
8 replies
I have a data set such as this... ID TIME Price 53A0438C-929B-4650-BD7D-DC4D64C7C87F 4/18/…
6 replies
Working in Sybase T-SQL, I am needing to return say, 5000 of 30,000 rows. Every 6th record perhaps …
4 replies
How to transfer SQL Server table data into Ms Access table Programatically instead of using D…
5 replies
Doesnt like this... as more than 1 value is returned.. can u somehow combine a LIKE with an IN…
3 replies
I am doing the following in my stored procedure: select replace(replace(replace(replace(t.comments,…
5 replies
Hi all, I'm really facing a bad problem. I'm using SQLServer as back-end and ASP as front-end. I ne…
1 replies
Does a truncate statement invalidate your logs or can you still backup to a point in time? Say you …
9 replies
Hi all, Need tip how to concatenate char values in one string (without cursor)? I mean, there is a …
11 replies
The following query selects all company information. Each company has many CallStart and CallEnd d…
15 replies
Viewing 15 topics - 10,246 through 10,260 (of 17,082 total)
You must be logged in to create new topics.