Topics
Started by
Posts
Last post
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
By: pop
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
My query below is returning an unusally large number of results. 1,225,686 to be exact. …
13 replies
Viewing 15 topics - 10,246 through 10,260 (of 17,081 total)
You must be logged in to create new topics.