Topics
Started by
Posts
Last post
Is there a way to list the columns names in a table through a query? Thanks,.
4 replies
Below is a procedure that is taking around 8 seconds to complete and the progressively getting long…
7 replies
I am trying to get a list of databases that only contain a certain table. How can I do this? I hav…
5 replies
Hi, I have a table with a field called intIndex that needs to be updated according to the order of …
6 replies
Hi! I'm using a tracing solution for all my stored procedures which requires that every procedure r…
6 replies
Is there a way to get the unique identifier of a transaction that SQL uses. I know you can name the…
6 replies
I have a NAME field that consistes of a person's full name (first, middle, last) separated by space…
16 replies
I have the following query. select @1 = field1, case field2 when 'A' then 'X' when 'B' then 'Y…
1 replies
In the creation of a report, I need to set up a temporary table. The problem is, I don't know how …
3 replies
is there a way to retrieve the windows logonname and the computername using tsql?
2 replies
Is there a way I could pass a column name to a stored procedure to be used in a select statement? C…
3 replies
when i find between in my datetime field it like select top 10 * from FACT_INS_BOOKING where date_k…
5 replies
I am trying to select the top 20 results for each group within my query. Any suggestions?
1 replies
I am trying to compute statistical information and well I ran into a slight problem with my new met…
5 replies
My application imports much data from files created by analysts in Excel. I want to be able to sel…
3 replies
Viewing 15 topics - 14,116 through 14,130 (of 17,082 total)
You must be logged in to create new topics.