Topics
Started by
Posts
Last post
Trying to return sproc metadata (only input paramaters) by using sp_sproc_columns. So I tried modi…
1 replies
I have records for few columns which have data suffixed with _Error . I am trying to trim the _Erro…
13 replies
Select * FROM :: FN_TRACE_GETTABLE('D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', …
6 replies
How to Create a stored procedure to find the following output. [Q1 = Jan + Feb + Mar ][ Q3 = July +…
2 replies
I have a very perplexing problem. There is a stored procedure that creates 5 temp tables (to de-no…
6 replies
im having some issues with the scipt below. i would like for it to cycle through every table in eac…
3 replies
I'm trying to create a view but I'm struggling, here is my scenario. The first table has a list of …
8 replies
hi all, i have a table like this table1(Id,username,DateOfBirth) i have alot of data in this table …
1 replies
I'm looking for some input and comments/ideas. I've got a transaction table (orders) which contains…
7 replies
I have a query which takes a parameter. If a parameter is passed. the query takes 11 minutes to com…
4 replies
I have a table witha column as clientid. the client id datais as follows '55566', '00055566' 'abcd…
7 replies
I am working on a SQL query that takes a variable to base the join on. The same variable is used fo…
3 replies
hello what would be the easiest way to convert a datetime column into an integer column?
18 replies
I am an app developer who writes queries. My DBA has added an index to a table and I want to compa…
7 replies
Hello All Not sure this doesn't qualify as a 'newbie' question, but it certainly is beyond my capab…
17 replies
Viewing 15 topics - 1,246 through 1,260 (of 12,234 total)
You must be logged in to create new topics.