Topics
Started by
Posts
Last post
most time, if i want to retrieve a value from other i always use subquery, but if i want many value…
13 replies
Hi there, I would like to round the following number: 12,999 to 13,000 and I cant find a way, all t…
4 replies
This is an edited post: My wife kicked me out of bed Friday night because I insulted her friend at…
23 replies
Below is a question I got on an exam but not sure what the correct answer would be? Which of the fo…
11 replies
Hi - I'm trying my hand at some BCP and am getting this error. My bcp statement is bcp "EXEC WMS.db…
6 replies
I have the following SP: SELECT moncallAdd.FirstListing, DATEADD(MINUTE, mOnCallAdd.StartOn…
31 replies
Hi, In SQL Server 2000 with SP4. could anyone give me script for How to identified last date insert…
1 replies
Hello Everyone, It would be very helpfull to have a view called: INFORMATION_SCHEMA.INDEXES That gi…
5 replies
Hi guys, Please can you look at my issue bellow I have 4 table 1.biodata ---------------- username …
3 replies
I'm looking for the most efficient way of pulling data in a cross tabular format but with no sums. …
2 replies
Hi guys, I'm a fairly new DBA and am starting to get the hang of TSQL, but can't quite wrap my mind…
3 replies
I want to run the stored procedure only when value in the column called group is 1. If the value is…
8 replies
Hi guys, This is an SQL2000 question so no RANK() function or INTERSECT solutions please. I am su…
4 replies
As the title states, is it possible to use a With/As statement within a stored procedure? I've been…
3 replies
Can anyone tell me why the below code in example 1 works, but the code in example 2 doesn't work? …
5 replies
Viewing 15 topics - 571 through 585 (of 17,082 total)
You must be logged in to create new topics.