Topics
Started by
Posts
Last post
Hi all, I trying to calculate the number of years between a date (anniversay dates) and today. Acc…
3 replies
Hello great Helpers, written a c# trigger, got it running and it appears to work as expected. It ke…
1 replies
I have a table with the name of states. I want the output to have 1>the first alphabet capital. …
13 replies
I have the following query: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE Your…
18 replies
I have a table with source data containing several columns including name, and a string. The string…
3 replies
I know I can do this easily enough Update tbl_UL Set WR = vtbl_Combined.BW From ( Select Blah , Bla…
5 replies
Hi, Is there any way to get statistic from a full text catalog? I have a full text catalog comprise…
3 replies
In SQL 2008 I can easily issue an 'ALTER TABLE dbo.tblName REBUILD WITH( IGNORE_DUP_KEY)' to add th…
1 replies
I have a function called F_TBL_VALS_FROM_STRING this function returns a table and uses '|' as a del…
5 replies
Hi, I had a nested sp.. In that sp.. i just need to execute a single sp alone from nested sp.. …
5 replies
Hi guys, right now i m learning the store procedure in sql server 2000. If you have any good articl…
2 replies
Hi there experts, I have the following TSQL - SELECT DISTINCT '1' AS Trigger_Status, dbo.Servic…
2 replies
I have an existing view1(vewsearchcategory) and now i need to add the columns from the TVF to this …
3 replies
I have multi selection boxes in my search page that a person can select some or not when submitting…
9 replies
I have two databases I need to join on. Issue is the project number on one is missing fist two dig…
6 replies
Viewing 15 topics - 826 through 840 (of 17,082 total)
You must be logged in to create new topics.