Topics
Started by
Posts
Last post
Hello comunity When in a query we use for exemple : select aa,SUM(xx) from tableA where aa='1' grou…
2 replies
Dear Forum, The UDF I've written below does not return any decimal places. Any idea what I mig…
3 replies
Hello: I have a table that contains one column with the following six values: a1 a2 a21 a10x a2a …
2 replies
I remember seeing something about this recently, but I'm not sure it was here. I was performi…
3 replies
I need to find inclusive datetime ranges to calculate time-in-state durations. Exclusive is f…
7 replies
I have a text data type column in SQL Server. I want to export that data to text file using the bcp…
4 replies
Hi, Oracle query : create table test(sno int, sno1 int) NOCACHE Is there any equivalent in SQL Serv…
2 replies
Hello All - I'm looking for a more efficient way of doing this query. It currently takes about 23 s…
2 replies
We have a smaller development box and want to do some testing on future data changes. Can Ins…
3 replies
I have a query for a report. I was under the impression that there was a 1:1 relationship bet…
11 replies
Hello, MSSQL 2000; TSQL I have a developer who has created a stored procedure (SP) which calls…
1 replies
DECLARE @idoc int DECLARE @doc1 varchar(8000) DECLARE @doc2 varchar(8000) SELECT @doc1 = SUBSTRING(…
1 replies
How can I add some "Ignore alpha, report with alpha" logic to the following when doing "WHERE (ITEM…
2 replies
I'm sure you're reading this post because you're laughing to yourself..."What a dumb question!". Ho…
5 replies
Before I begin, yes, I do realize Primary Keys should not be changed... If I want to track Updates…
1 replies
Viewing 15 topics - 11,866 through 11,880 (of 17,082 total)
You must be logged in to create new topics.