Topics
Started by
Posts
Last post
I was writing/testing a sproc today. My first SQL statements hard coded a date just for testing pur…
12 replies
Hi, I have two DB running on same instance of MSDE. DB1 is third party production DB and DB2…
1 replies
I need a query for the following (simplified) situation: There is a table with customers, a table w…
8 replies
I have the following instead of insert trigger that I need a little help with. The reason I a…
12 replies
I am trying to build an administration script for SS2K to find all instances where a specific integ…
14 replies
I cannot merge these 2 seperate queries. Can anyone show me how please? 1. set dateformat dmy selec…
3 replies
Hi IN SHORT: How do you write a search query that searches for multiple words, BUT only returns a r…
13 replies
Hello, I'd like to use some financial calculations in sql server like NPV and IRR. I have read htt…
4 replies
Hi there, I like to get the year and month from a given date in the format yyyymm. I can do this fi…
2 replies
I have a description field that I need to update that has an apostrophe in it. How do you upd…
1 replies
Hello all, I want to have a table that has one filed that holds a password that is encrypted s…
2 replies
Hi, I have a problem with select statement. For my report purpose i am creating a table dynamically…
1 replies
I have the following query: UPDATE table SET datetime_field = '2005-11-21' that fails with: T…
20 replies
Hi, MSSQL 2000/SP3 I've ran a trace (using SQL Profiler) and a column called textdata displays only…
4 replies
I have a problem: I fill a table from the result a query and obtain a table like: Item &…
1 replies
Viewing 15 topics - 8,581 through 8,595 (of 17,082 total)
You must be logged in to create new topics.