Topics
Started by
Posts
Last post
Hi I want to insert values in my table after executing one store procedure because i want to store…
4 replies
Is it possible to use the count(*) statement more than once such as: SELECT members, count(*) …
5 replies
Hi all, I have two tables. The first one 'AccountActivity' and the other 'PaymentInfo'. When a paym…
5 replies
I am trying to output a file, using bcp, that is PIPE delimited, and it keeps giving me syntax erro…
3 replies
Hi , I have the following query and after several hours I still can't get the correct syntax to get…
4 replies
i am trying to do a simple transformation through DTS. My source column TreatyNumber ha…
1 replies
I can make this to work DECLARE @PositionID int SELECT @PositionID = PositionID FROM Employee…
7 replies
Hi, I want to alter a table to add a particular column at specified ordinal position .. Ex.. Suppos…
12 replies
ok this is doing my head in! create procedure myproc @aValue bigint begin as select aField from t…
2 replies
Hi Background: I have Invoice Data with Invoice Number in a form of alphanumerics (nvarchar). Basi…
2 replies
I have this code: declare @tabla table(field char(20)) insert @tabla values ('AABBZ') insert @t…
6 replies
i have a table Called GE_Trans which has a column TreatyNumber which has values like below Sa…
13 replies
Hi, I'm using SQL2k as the back end database to my CMS and want to provide users with the ability t…
6 replies
I created a Temp Table to insert the output of an Proc. When I do this it returns only about 7 rows…
8 replies
Hope everyone had a great holiday! I was wondering if there is away to pull in a value of the curre…
2 replies
Viewing 15 topics - 5,371 through 5,385 (of 17,082 total)
You must be logged in to create new topics.