Topics
Started by
Posts
Last post
Hi I have a Item table and next to that I have a table with extended lines. This is like extra des…
4 replies
Hi Folks, I have one query: 1. I have a date range in a table. EmpCode, Start Date and End Dat…
7 replies
What is difference between != and <> operators in SQL ? Thanks in advance Amit Choudhary &nb…
7 replies
How can i get the result of this in temp table sp_MSForEachtable 'sp_spaceused ''?'''
10 replies
Hi , I need to transpose the column name to row( without using any function) ,can …
4 replies
I have a source table like below Data_Staging: Unique_id Gender Ethnicity Race MCP_key Admission_Dt…
4 replies
I have date column in integers in almost all the tables. I want to convert integer to date from all…
20 replies
Hello everybody, I have a table 'online_batch14' with the following structure : SerialNumber Varcha…
9 replies
Hello, What is the correct syntax for a call to the RegExp.Execute method from sp_OAMethod? The fol…
5 replies
CREATE TABLE #tbls ( tbl_name SYSNAME ) exec sp_msforeachtable 'IF (SELECT COUNT(*) FROM ?) >…
4 replies
How can i measure the sizse of the rows. say for example when i ran a query, it returend 49974 rows…
9 replies
I am trying to create a pagination stored procedure using sql server 2005. I seem to be runni…
4 replies
Dear experts Does anyone know a method of 'rolling up' data using calculations such as median and i…
1 replies
Hi, I have a stored procedure that takes 30s to run: CREATE PROCEDURE dbo.usp_get_untranslated_prom…
28 replies
Hello, I have a table called WellsResubmit_Staging that contains a single column called ‘Res…
9 replies
Viewing 15 topics - 4,171 through 4,185 (of 17,082 total)
You must be logged in to create new topics.