Topics
Started by
Posts
Last post
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
select * from a,b,c where A.cash_id in ( select B.cash_id from B where B.cash_id = C.cas…
4 replies
I have the following 2 xml codes and I want to do a search on tag name DECLARE @X xml SET @X = '<…
2 replies
I have got a data like: IDLevelSeq 1001,1,1 1002,1,2 1003,1,3 1004,1,4 1005,1,5 2001,2…
1 replies
I have two columns 1 appointment 2 joindate date is like Appointment | joi…
3 replies
Viewing 15 topics - 7,201 through 7,215 (of 10,647 total)
You must be logged in to create new topics.