Topics
Started by
Posts
Last post
Hey all, Its a whille since i used rank last. I cant seem to get it to do what i want. Example cod…
2 replies
Hi, I got there tables Table A, Table B, Table C Table A CREATE TABLE [dbo].[TableA]( [ID] [int] N…
9 replies
I know this should be simple but I can not find or think of how to do it... This is what I have and…
7 replies
--the idea is i need col2 to be a delimited list of all the imagenames for the given stock numer. c…
6 replies
Is there any difference between using IsNull or an OR statement as in the following: In a stored pr…
8 replies
Hi, How can i stop the long running transaction?any T-ssql command? Thanks
5 replies
I have been using TRY CATCH to capture errors and write them to the log. One particular error I had…
1 replies
Suppose I have a transaction record like: TransactionID LedgerID Period Amount Paid 1 …
6 replies
Proddb03 is the name of another server on our network. I want to be able to query it from Proddb04…
10 replies
Hi, I'm struggeling to create a view that will return YTD values. Basicly I have a huge Postings ta…
9 replies
Hi, During development I came across a strange scenario using DD with Macedonian_FYROM_90_CI_AS Col…
1 replies
I need to select the file name from a column in a database containing the full path and file name. …
21 replies
When calculating PercentOnGradeLevel, I have to do 2 Casts and a Round to get the results with one …
5 replies
Hello. I am trying to execute a query which contains what i am calling a 'dynamic 'IN' statement' (…
4 replies
Lets Say I have a table with 500K of rows I have an Update a Query that update 30k of the rows I ha…
42 replies
Viewing 15 topics - 7,186 through 7,200 (of 10,635 total)
You must be logged in to create new topics.