Topics
Started by
Posts
Last post
Hello Does anyone know if it is possible to somehow assign the COMPUTE results into local variables…
3 replies
By: noeld
I need to run a query in all servers, but I can not write a cursor becuase It is to create a report…
7 replies
Does SQL evaluate both parts of an OR condition or does it stop when one condition is TRUE? For exa…
2 replies
By: noeld
So I was playing with the ISDATE function and scripted this: DECLARE@Datum2 datetime SET @Datum2 =…
2 replies
If possible I need help to write a stored procedure, or pseudo code, that looks into a table named …
4 replies
By: itortu
Hello All, I have an issue with isnull. basically what iam trying to do is: where col1 = isnull(@v…
14 replies
I'm trying to execute something like this: DECLARE @Ind int , @Result nvarchar(50) SELECT@Result =…
17 replies
Hi, Hope someone can offer me some guidance here. When I try to execute the following tSQL, I get t…
3 replies
By: Dunger
how can i do like this With GetAllCategories as ( Select ROW_NUMBER() OVER (Order By [Name] ASC) a…
3 replies
I have a stored procedure which is broken into several steps. Steps are updating different columns …
4 replies
So this is what I want to do: I have this database, on a daily basis we have a table in this databa…
7 replies
Hi, I am seeking some advice on how best to approach a problem I have been asked to solve. I need t…
2 replies
I am trying to delete a foreign key dynamically in my package. I have come up with this so far but …
2 replies
hi everybody, this is really blowing my mind :crazy: i'm converting a vb routine to ms sql server 2…
36 replies
I think this is a very easy question but I am a relatively new to T-SQL and I can't find anything t…
4 replies
Viewing 15 topics - 11,191 through 11,205 (of 12,234 total)
You must be logged in to create new topics.