Topics
Started by
Posts
Last post
Background Information: I recently came across a problem with an Audit Trigger (no need to pipe in…
1 replies
Hi All, I have a where condition like where Fk_Event in (COALESCE((select fk_event from workscope…
5 replies
I’m hoping someone can assist me with SQL Syntax. I have a view which is used to create a bank tra…
3 replies
The strucutre of the table is: INSERT INTO [SF].[dbo].[PackageData] ([Package Grp No] …
8 replies
I've been struggling with this for a while. I imagine the answer requires a few temporary tables, b…
9 replies
Hello, I searched the prior posts and scrutinized the BOL ... I still have some confusion. …
3 replies
Hi I have a function call within an SP which is taking up 85% of the entire query. I tried a Select…
2 replies
What I am trying to do is select from one table (BWCheck) that has a list of tables in it and get r…
1 replies
Hi I am trying to extract information from the following string, it appears with quotation marks in…
3 replies
Hi, I originally posted this question in SQL2005 T-SQL forum, but it is actually a SQL 2000 problem…
4 replies
I need to be able to get the full classification hierarchy of a particular asset. If I was to pull …
10 replies
Hi All Sorry for being dim but it's been a long day! I need to create a temp table with 900 unique …
6 replies
I would like to find some records out of 2 table with some criteria. If first table do not have, th…
1 replies
Message Executed as user: dbo. Violation of PRIMARY KEY constraint 'PK_ErrorTrans'. Cannot insert d…
4 replies
I have an image column(FileBlob) in a large table with about 50,000 records. Now I have a query whi…
18 replies
Viewing 15 topics - 1,126 through 1,140 (of 17,082 total)
You must be logged in to create new topics.