Topics
Started by
Posts
Last post
Hi declare @dFrom varchar(12) set @dFrom = convert(varchar,getdate(),112) INSERT INTO OPENROWSET (…
1 replies
The two queries are returning two different no of rows.Outer join is not supposed to duplicate the …
7 replies
I have a stored procedure where you can pass either @tableId, or @ParentId. In this case the progr…
1 replies
Hello I am trying to apply MIN function on computed Column. Wondering how can I do it. Code example…
1 replies
I wrote a function that I am not happy with the way it turned out. It recursively climbs the hiera…
1 replies
I created full text catalog & full text index in column Name,Description of table Product when…
1 replies
For example if I have inserted and deleted triggers, for how long does the data stays in the insert…
5 replies
Hi i want to write a stored procedure which executes for each row in a query: select email from ST$…
3 replies
hello. Send me any good links for how to create indexes in sql server 2005. Thank y…
3 replies
All, I have a large result set which return data for a 100's of customers with various information…
3 replies
We have two scripts that provide the same basic functionality, but one is for clients who still use…
11 replies
I have a table (Data_Periods) that contains a list of months, the table can contain between 1 and 1…
9 replies
Hi guys, This is driving me crazy, I have to trim off blank space in a table, but it just seems not…
28 replies
Sadly I am limited in what changes I can make at this time but I've been given a dynamic query whic…
27 replies
Hi all, I have the following basic t-sql statement: INSERT INTO PROVIDERS (LAST_NAME, FIRST_NAME, M…
6 replies
Viewing 15 topics - 8,566 through 8,580 (of 12,234 total)
You must be logged in to create new topics.